initdb crashes under Windows - PostgreSQL Database

Randy Yates

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 %
%%%% <ya***@ieee.org> % 'Living' Thing', *A New World Record*, ELO
http://home.earthlink.net/~yatescr

Nov 23 '05 #1

Subscribe Reply

1872

Randy Yates

$ initdb --version
initdb (PostgreSQL) 7.4.5

yates@leibniz ~
$
Randy Yates <ya***@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 %
%%%% <ya***@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 %
%%%% <ya***@ieee.org> % 'Living' Thing', *A New World Record*, ELO
http://home.earthlink.net/~yatescr

Nov 23 '05 #2

Similar topics

InitDB fails

by: supersize me | last post by:

After looking at many of the DBMS choices out there (commercial and open source), I settled on PostgreSQL because of its stablity and feature-set. I'm having a problem getting it to install,...

PostgreSQL Database

Error on initdb with 7.4RC2

by: Martin Marques | last post by:

When running initdb on a fresh 7.4 install I get this error: postgres@bugs:~$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -E latin1 The files belonging to this database system will be...

PostgreSQL Database

Can't initdb, libdir points to static location

by: Tim Farrell | last post by:

I use PostgreSQL as a default database in our solution and with the 7.2 version I was able to tar up the area pointed to by the --prefix build argument and untar to an arbitrary path as part of my...

PostgreSQL Database

initdb reporting error.

by: Seamus Thomas Carroll | last post by:

Hi, I have installed postgres in a non-standard location with this call to configure: ../configure --prefix=/scratch/postgresql-7.4/ --exec-prefix=/scratch/postgresql-7.4...

PostgreSQL Database

Where is initdb?

by: Jerome Lyles | last post by:

Hello List, I have installed Postgresql 7.4 on a Suse 9.0 system using apt. I cannot do this: /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data Because there is no "/pgsql/bin/initdb"...

PostgreSQL Database

7.4.2 initdb problem

by: Medora Schauer | last post by:

I've installed 7.4.2 on a PowerPC system running linux 2.4.13. When I try to run initdb to create to create the database cluster I get the following: $ initdb -D $PGDATA The files...

PostgreSQL Database

PostgreSQL 7.4.2 initdb problem

by: tech tech | last post by:

Hello All, I installed postgresql 7.3.4 on HPUX PA in /usr/local/pgsql and put the libraries in /usr/local/pgsql/lib/LIB_new. During the initialization( initdb), it loads libraries (language)...

PostgreSQL Database

How to pass initdb LC_COLLATE & locale parameters when using windows? (with or without pginstaller)

by: Manolatos Tilemahos | last post by:

Dear friends, First pls accept my apologies, because I am a new Postgres user, so my questions could be silly. We need to setup a database using UTF-8 encoding, however, by some way, we have...

PostgreSQL Database

beta3 winxp initdb problems

by: BARTKO, Zoltán | last post by:

Hello, folks, I am trying to install pgsql8 on winxp. I tried first to install "as is" with pginstaller beta2-dev3, no luck, it froze, switched off Nod32, froze a little later, ran through the...

PostgreSQL Database

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP