Thread: Don't succedd in initializing database

Hi, all,

I tried several times to initialize the database, but I didn't succeed.

Here's what I typed on the CygWin prompt:

-------------------- Schnipp! --------------------

bash-2.05b$ ls -lisa
total 317
 165189    0 drwxrwxrwx+   5 Administ Benutzer     4096 Oct  1 00:55 .
3761467680    0 drwxrwxrwx+  14 Administ Benutzer     4096 Aug 18 07:50 ..
 157377    0 drwxrwxrwx+   2 Administ Benutzer     8192 Oct  1 00:55 contrib
 157419   38 -rwxrwxrwx    1 Administ Benutzer    38176 Aug  5 15:31 conversion_create.sql
 169165    0 d---------+   2 postgres Kein            0 Aug 18 08:07 data
3761333996    0 drwxrwxrwx+   2 Administ Benutzer        0 Oct  1 00:55 java
 157425    3 -rwxrwxrwx    1 Administ Benutzer     2329 Aug  5 15:31 pg_hba.conf.sample
 157426    2 -rwxrwxrwx    1 Administ Benutzer     1441 Aug  5 15:31 pg_ident.conf.sample
 157427  221 -rwxrwxrwx    1 Administ Benutzer   225499 Aug  5 15:31 postgres.bki
 157429   48 -rwxrwxrwx    1 Administ Benutzer    48711 Aug  5 15:31 postgres.description
 157430    5 -rwxrwxrwx    1 Administ Benutzer     5043 Aug  5 15:31 postgresql.conf.sample
bash-2.05b$ initdb -D /usr/share/postgresql/data
grep: not found
grep: not found
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

Fixing permissions on existing directory /usr/share/postgresql/data... \c
chmod: changing permissions of `/usr/share/postgresql/data': Permission denied

initdb failed.
bash-2.05b$ whoami
postgres

-------------------- Schnapp! --------------------

Some questions:
1) What does the "initdb" message "This user must also own the server process." mean?
2) Why do I get the error message "Permission denied" during the execution of "initdb"?
3) Why does "initdb" want to change the permission of:
     /usr/share/postgresql/data
    This directory is already owned by "postgres"...

Thank you in advance for your help..

Kind regards
Stephan Rupp

--

Stephan Rupp
- Philologe / Netzwerkspezialist -
Mirabeauweg 4
D-72 072  Tübingen
Tel.: +49 (7071) 84093
Fax: +49 (7071) 84048
E-Post:    stephan.rupp@gmx.net
    stephan.michael.rupp@t-online.de

Stephan,

On Wed, Oct 01, 2003 at 01:56:41AM +0200, Stephan Rupp wrote:
> bash-2.05b$ initdb -D /usr/share/postgresql/data
> grep: not found
> grep: not found

The above indicates that your Cygwin setup is broken.  I recommend
posting to the Cygwin list for help or trying to resolve the problem
yourself.  When Cygwin is set up correctly, then try to initdb again.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6