Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
tracy ong
Date:
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
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??


Rgds,
Tracy

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

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

From
Reini Urban
Date:
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/