Re: Postgresql database does not start and just hangs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "SALUNKHE,MANDAR (HP-Singapore,ex1)" <mandar(dot)salunkhe(at)hp(dot)com>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgresql database does not start and just hangs
Date: 2003-04-21 02:00:19
Message-ID: 21758.1050890419@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"SALUNKHE,MANDAR (HP-Singapore,ex1)" <mandar(dot)salunkhe(at)hp(dot)com> writes:
> Viewing the pid file ( newly created ) shows:
> 18140
> /usr/local/pgsql/data

> And then

> hp(at)ACACIA /usr/local/pgsql/data
> $ ps -aef|grep 18140
> hp 18140 18204 con 21:19:40 /usr/bin/ps

I'm not familiar with how Cygwin assigns process PIDs, but the above
sure looks like the ps process has been given the same PID that the
postmaster thought it had. Are you copying-and-pasting from more than
one test session? If not, there's something odd here.

Perhaps it'd be worth your while to reinstall Cygwin --- I wonder if
the Cygwin executables could have gotten corrupted in your crash.
(While you're at it you might as well reinstall ipc-daemon and Postgres
too. Just be sure not to munge your data directory ...)

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-04-21 02:11:25 Re: What locale is my DB using?
Previous Message Jean-Christian Imbeault 2003-04-21 01:46:52 What locale is my DB using?