Tagged Questions
-1
votes
0answers
28 views
Not able to Delink the old tables [closed]
When i tried to delink the old tables i'm getting the following error
NOTICE: SELECT COUNT(*) AS count from pg_tables where schemaname='fr' and tablename='check_deny_2013_04_17'
CONTEXT: PL/pgSQL ...
0
votes
1answer
28 views
How to restore the user postgres?
In the second answer in this thread is a warning about changing the UNIX password for "postgres".
I have already changed the password for "postgres".
How could I restore the initially state of the ...
2
votes
1answer
252 views
Running a query without the OS cache
I want to emulate a client site who doesn't have much caching because they have so much I/O all the time. I want to run a SQL query on my machine (on my VM to be precise) with the same limitations ...
6
votes
3answers
638 views
Choosing Linux Distro for PostgreSQL
I'll begin by saying I'm a newbie sys admin.
I need a new PostgreSQL 9.1 machine. My go to distro is Debian (for no good reason other than it's what I first learned). However, when I started ...
0
votes
1answer
177 views
Postgres 9.0 linux command to windows command conversion [closed]
i am working on an application using delphi 7 as the front end and postgres 9.0 as the back end.
I have to upload images to the server so i use \lo_import and \lo_export for inserting images on the ...
