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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo