Thread: initdb crashes under Windows

initdb crashes under Windows

From
Randy Yates
Date:
Can't get the postgres server started under Win2000/cygwin. Here's
what happens:

$ initdb -D /Gauss/rr/data -W
The files belonging to this database system will be owned by user "yates".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /Gauss/rr/data... ok
creating directory /Gauss/rr/data/base... ok
creating directory /Gauss/rr/data/global... ok
creating directory /Gauss/rr/data/pg_xlog... ok
creating directory /Gauss/rr/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 /Gauss/rr/data/base/1... FATAL:  lock file "/Gauss/rr/data/postmaster.pid" already
exists
HINT:  Is another postgres (PID 1672) running in data directory "/Gauss/rr/data"?

initdb: failed

yates@leibniz ~
--
%  Randy Yates                  % "Rollin' and riding and slippin' and
%% Fuquay-Varina, NC            %  sliding, it's magic."
%%% 919-577-9882                %
%%%% <yates@ieee.org>           % 'Living' Thing', *A New World Record*, ELO
http://home.earthlink.net/~yatescr

Re: initdb crashes under Windows

From
Randy Yates
Date:
$ initdb --version
initdb (PostgreSQL) 7.4.5

yates@leibniz ~
$
Randy Yates <yates@ieee.org> writes:

> Can't get the postgres server started under Win2000/cygwin. Here's
> what happens:
>
> $ initdb -D /Gauss/rr/data -W
> The files belonging to this database system will be owned by user "yates".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> fixing permissions on existing directory /Gauss/rr/data... ok
> creating directory /Gauss/rr/data/base... ok
> creating directory /Gauss/rr/data/global... ok
> creating directory /Gauss/rr/data/pg_xlog... ok
> creating directory /Gauss/rr/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 /Gauss/rr/data/base/1... FATAL:  lock file "/Gauss/rr/data/postmaster.pid" already
exists
> HINT:  Is another postgres (PID 1672) running in data directory "/Gauss/rr/data"?
>
> initdb: failed
>
> yates@leibniz ~
> --
> %  Randy Yates                  % "Rollin' and riding and slippin' and
> %% Fuquay-Varina, NC            %  sliding, it's magic."
> %%% 919-577-9882                %
> %%%% <yates@ieee.org>           % 'Living' Thing', *A New World Record*, ELO
> http://home.earthlink.net/~yatescr

--
%  Randy Yates                  % "Rollin' and riding and slippin' and
%% Fuquay-Varina, NC            %  sliding, it's magic."
%%% 919-577-9882                %
%%%% <yates@ieee.org>           % 'Living' Thing', *A New World Record*, ELO
http://home.earthlink.net/~yatescr