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

Поиск
Список
Период
Сортировка
От tracy ong
Тема FATAL: lock file "usr/local/pgsql/data/postmaster.pid already exist
Дата
Msg-id 20040913051138.81837.qmail@web51405.mail.yahoo.com
обсуждение исходный текст
Ответы Re: FATAL: lock file "usr/local/pgsql/data/postmaster.pid  (Reini Urban <rurban@x-ray.at>)
Список 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
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!

В списке pgsql-cygwin по дате отправления:

Предыдущее
От: Nah CP
Дата:
Сообщение: Insert data to new table
Следующее
От: Reini Urban
Дата:
Сообщение: Re: FATAL: lock file "usr/local/pgsql/data/postmaster.pid