Re: FATAL: lock file "usr/local/pgsql/data/postmaster.pid

tracy ong schrieb:
> I'm currently running PostgreSQL 7.4.5 using cygwin on Windows 2000.
> When i tried to initialise the db using the following:
...
> "/usr/local/pgsql/data/postmaster.pid" already exists
> HINT: Is another postgres (PID 1164) running in data directory
> "/usr/local/pgsq
> l/data"?
>
> initdb: failed
> initdb: removing data directory "/usr/local/pgsql/data"
> [1]+ Done ipc-daemon
>
> i tried to run ps -a:
>
> $ ps -a
> PID PPID PGID WINPID TTY UID STIME COMMAND
> 1500 1 1500 1500 ? 500 12:00:11 /usr/local/bin/ipc-daemo
> n
> 1900 1 1900 1900 con 500 12:23:33 /usr/bin/bash
> 700 1900 700 1804 con 500 12:34:49 /usr/bin/ps
>
> it seems like there's no other process running this DB.
>
> So I'm not sure where is the problem. Any ideas anyone??

if you are using the 7.4.5 cygwin release you may not use ipc-daemon!
you must use cygserver instead. This is in the readme.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/