Re: Postgresql database does not start and just hangs - Mailing list pgsql-novice

From Tom Lane
Subject Re: Postgresql database does not start and just hangs
Date
Msg-id 21758.1050890419@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql database does not start and just hangs  ("SALUNKHE,MANDAR (HP-Singapore,ex1)" <mandar.salunkhe@hp.com>)
List pgsql-novice
"SALUNKHE,MANDAR (HP-Singapore,ex1)" <mandar.salunkhe@hp.com> writes:
> Viewing the pid file ( newly created ) shows:
> 18140
> /usr/local/pgsql/data

> And then

> hp@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


pgsql-novice by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: What locale is my DB using?
Next
From: Tom Lane
Date:
Subject: Re: What locale is my DB using?