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 Si gnal 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??
