Re: [SQL] How to check postgres running or not ?

running [EMAIL PROTECTED]:~$ cheers Worik Jeff Eckermann wrote: --- Christopher Browne <[EMAIL PROTECTED]> wrote: In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] ("Sandeep Gaikwad") transmitted: Hello Sir, I want to know how to check whether post

Re: [SQL] How to check postgres running or not ?

postgres 670 0.1 0.6 8544 1688 pts/1S12:33 0:00 /usr/lib/postgresql/bin/postmaster [EMAIL PROTECTED]:~$ So... " ps aux | grep postmaster | grep -v grep " is more reliable(?) cheers Worik Regards Gaetano Mendola ---(end of

Re: [SQL] How to check postgres running or not ?

:02 postgres: stats buffer process postgres 889 0.0 0.2 8624 632 ?SSep07 0:05 postgres: stats collector process worik25927 0.0 0.2 1612 540 pts/10 S13:54 0:00 grep post [EMAIL PROTECTED]:~$ If it is not running it will produce output like... [EMAIL PROTECTED

[SQL] pg_dump/pg_restore question

I have tried adding the line host all 127.0.0.1 255.255.255.255trust to pg_hba.conf but it makes no difference. The only thing I can do is edit the dump file into the part that wants to connect as postgres and the part that wants to connect as worik and run them under the