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

Hi all,

I'm currently running PostgreSQL 7.4.5 using cygwin on Windows 2000. When i tried to initialise the db using the following:

initdb -D /usr/local/pgsql/data -W -E LATIN1

the following is the outcome:

The files belonging to this database system will be owned by user "Administrator
".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
selecting default max_connections... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
10
selecting default shared_buffers... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
50
creating configuration files... ok
creating template1 database in /usr/local/pgsql/data/base/1... FATAL: lock file
"/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??

Rgds,
Tracy

---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!