initdb failing

From: Tony Grant <tg001(at)dial(dot)oleane(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: initdb failing
Date: 2001-01-18 08:54:35
Message-ID: 20010118095435.A861@tonux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am going throught the pains of initdb failing again. I know that usually
this is a permissions problem but can't remember how I fixed it 18 months
ago (yes we should all have a notebook to document such things...)

I had a working 6.5.x on RedHat 6.2 and (stupidly) decided to upgrade to
7.0.3.

rpm -Uvh postgres*

installs all the bits that interest me, but "initdb -D /var/lib/pgsql" and
"/etc/rc.d/init.d/postgres start" both fail.

postgres]$ initdb -D /home/postgres
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.

Fixing permissions on pre-existing data directory /home/postgres
Creating database system directory /home/postgres/base
Creating database XLOG directory /home/postgres/pg_xlog
Creating template database in /home/postgres/base/template1
Creating global relations in /home/postgres/base
Adding template1 database to pg_database
/usr/bin/initdb: /tmp/initdb.29795: Permission denied
/usr/bin/initdb: /tmp/initdb.29795: Permission denied
/usr/bin/initdb: /tmp/initdb.29795: Permission denied
/usr/bin/initdb: /tmp/initdb.29795: No such file or directory

initdb failed.
Removing /home/postgres.
rm: cannot remove directory `/home/postgres': Permission denied
Failed.
Removing temp file /tmp/initdb.29795.

HELP!!!!

=;-`

Cheers

Tony Grant

Browse pgsql-general by date

  From Date Subject
Next Message Dan Langille 2001-01-18 09:30:48 Re: GET DIAGNOSTICS SELECT PROCESSED INTO <int4_variable>
Previous Message J.H.M. Dassen (Ray) 2001-01-18 08:05:56 Re: GET DIAGNOSTICS SELECT PROCESSED INTO <int4_variable>