[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

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

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 ?

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