[GENERAL] invalid data in PID file

2006-10-11 Thread J S B
Hi,I'm trying to start my postgres server using# pg_ctl start -D /usr/local/pgsql/abcand get an error like:invalid data in PID file /usr/local/pgsql/abc/postmaster.pid can anyone comment whats wrong.My postmaster.pid file is empty at the time when i run this command.Regards,Jas

Re: [GENERAL] invalid data in PID file

2006-10-11 Thread Martijn van Oosterhout
On Wed, Oct 11, 2006 at 02:50:59PM -0400, J S B wrote: I'm trying to start my postgres server using # pg_ctl start -D /usr/local/pgsql/abc and get an error like: invalid data in PID file /usr/local/pgsql/abc/postmaster.pid can anyone comment whats wrong. My postmaster.pid file is

Re: [GENERAL] invalid data in PID file

2006-10-11 Thread J S B
i never touched it. when i opened it to check the stuff inside, found it empty.What should i do now?On 10/11/06, Martijn van Oosterhout kleptog@svana.org wrote:On Wed, Oct 11, 2006 at 02:50:59PM -0400, J S B wrote: I'm trying to start my postgres server using # pg_ctl start -D

Re: [GENERAL] invalid data in PID file

2006-10-11 Thread J S B
I deleted postmaster.pid file and got rid of the previous error.Now its a new error which say something as follows after i try starting my postgres server usring pg_ctl start -D /usr/local/pgsql/jsbali :-postmaster starting LOG: could not bind IPv4 socket: Address already in useHINT: Is another

Re: [GENERAL] invalid data in PID file

2006-10-11 Thread Tom Lane
J S B [EMAIL PROTECTED] writes: FATAL: could not open lock file /tmp/.s.PGSQL.5432.lock: Permission denied Can you please tell me what is this all about? It looks to me like you have, or had, another postmaster running under a different userid. Perhaps you should back up to the beginning

Re: [GENERAL] invalid data in PID file

2006-10-11 Thread Madison Kelly
Tom Lane wrote: J S B [EMAIL PROTECTED] writes: FATAL: could not open lock file /tmp/.s.PGSQL.5432.lock: Permission denied Can you please tell me what is this all about? It looks to me like you have, or had, another postmaster running under a different userid. Perhaps you should back up

Re: [GENERAL] invalid data in PID file

2006-10-11 Thread J S B
Actually i've been trying to setup my postgres database in a new machine.the machine that i'm using right now is goin to die very soon. So i was trying to restore it in another machine but before that I have to install postgres in this new machine. I installed postgres successfully, created a DB

Re: [GENERAL] invalid data in PID file

2006-10-11 Thread Tom Lane
J S B [EMAIL PROTECTED] writes: There was some problem with postmaster.pid file, so i just removed it. Without bothering to stop the old postmaster first, I take it. At this point your best bet is to find out the PID of the old postmaster with ps and then kill it with kill -INT pid. I suspect

Re: [GENERAL] invalid data in PID file

2006-10-11 Thread J S B
Well, I've been very particular with the user id. There's just one single user ID am working on my postgres with.when i start the postgres, it creates the follwoing processes for postgres:1 S jsbali 4034 4033 0 76 0 - 2489 - 15:41 pts/2 00:00:00 postgres: logger process 1 S jsbali 4036 4033 0 75 0

Re: [GENERAL] invalid data in PID file

2006-10-11 Thread Tom Lane
J S B [EMAIL PROTECTED] writes: Then i try to start postgres again and it gives me the same error: LOG: could not bind IPv4 socket: Address already in use HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. Um, have you tried waiting a bit as the