Skip site navigation (1) Skip section navigation (2)

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

From: tracy ong <tracy_ong(at)rocketmail(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: FATAL: lock file "usr/local/pgsql/data/postmaster.pid already exist
Date: 2004-09-13 05:11:38
Message-ID: 20040913051138.81837.qmail@web51405.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
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!

Responses

pgsql-cygwin by date

Next:From: J. HondiusDate: 2004-09-13 08:28:39
Subject: Re: All Production releases of PostgreSQL hung because of
Previous:From: Gaetano MendolaDate: 2004-09-11 18:30:51
Subject: Re: Adding columns in the middle (Was: Developers page is down)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group