Initdb fail error - help!

From: "Jonathan Lonon" <jlonon(at)newlifesys(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Initdb fail error - help!
Date: 2001-05-31 18:11:06
Message-ID: 003b01c0e9fd$1019d520$a748d6d1@nls01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

I installed the latest cygwin tools from web two weeks ago onto my laptop (WinME) and it works well. The goal was to get the PostgreSQL included up and running. I printed and followed the v1.9 readme file for the Cygwin PostgreSQL and all steps through step 4 work fine:

1. install latest cygipc
2. ipc-daemn --install-as-service (Skipped this step since not NT)
3. $ ipc-daemon &
4. export PGDATA=/usr/share/postgresql/data
5. initdb (this is where failure occurs)

Step five seems to be happening fine but then fails. Here is brief snapshot:

$ initdb
This database system will be initialized with username "JLONON".
This user will own all the data files and must also own the server process.

Creating directory /usr/share/postgresql/data
(or Fixing permissions on existing directory /usr/share/postgresql/data if I create it first)
Creating directory /usr/share/postgresql/data/base
Creating directory /usr/share/postgresql/data/global
Creating directory /usr/share/postgresql/data/pg_xlog
Creating template1 database in /usr/share/postgresql/data/base/1
cat: not found
DEBUG: database system was shut down at...
DEBUG: CheckPoint record at (0, 8)
DEBUG: Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE
DEBUG: NextTransactionId: 514; NextOid: 16384
DEBUG: database system is in production state
Creating global relations in /usr/share/postgresql/data/global
cat: not found
DEBUG: database system was shut down at ...
DEBUG: CheckPoint record at (0, 72)
DEBUG: Redo record at (0, 72); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 514; NextOid: 16384
DEBUG: Database system is in production state
Initializing pg_shadow.

initdb failed.
Removing /usr/share/postgresql/data.
Removeing temp file /tmp/initdb.38015571.

I have searched the list and found a few things that seemed to be the answers such as being sure I was logged on as postgres user, which I determined is not the problem so I'm still logging in as my own username, which is what I do successfully now on my Mandrake Linux box with (I think) v7.0 of PostgreSQL. The other thing was that I have ownership and wrx rights to the /usr/share/postgresql/data directory, and I do.

The purpose of trying this is to have a "portable" version of my database for this test laptop system. Since I'm a bit new to the linux/unix commands, please give detail about what to try or do to fix this. Thanks.

Any help on this would be appreciated.

Jonathan.

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Fred Yankowski 2001-05-31 18:34:00 Re: Initdb fail error - help!
Previous Message Jerry Asher 2001-05-31 16:50:05 building the client libraries with gcc?