possible bug... - Mailing list pgsql-bugs

From SriKumar Kareti
Subject possible bug...
Date
Msg-id 1127328575.3913.5.camel@karetis.spanlink.com
Whole thread Raw
Responses Re: possible bug...  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-bugs
Hello!

I am trying to install postgres 8.0.3 from rpms.

[karetis@karetis ~]$ rpm -qa | grep postgres
postgresql-8.0.3-1PGDG
postgresql-server-8.0.3-1PGDG
postgresql-libs-8.0.3-1PGDG
[karetis@karetis ~]$


After I install the RPMs, when I try to initdb I run into problems.
I did set the data directory to belong to "postgres" and I am trying to
initdb as "postgres". I have read through several postings and have not
seen anyone have the same problem.

Thank you for your help.

SriKumar.

Here is the run:

bash-3.00$ ls -l /usr/local/
total 88
drwxr-xr-x  2 root     root     4096 Apr 28 00:09 bin
drwxr-xr-x  2 root     root     4096 Apr 28 00:09 etc
drwxr-xr-x  2 root     root     4096 Apr 28 00:09 games
drwxr-xr-x  2 root     root     4096 Apr 28 00:09 include
drwxr-xr-x  2 root     root     4096 Apr 28 00:09 lib
drwxr-xr-x  2 root     root     4096 Apr 28 00:09 libexec
drwxr-xr-x  3 root     root     4096 Sep 16 10:01 man
drwxr-xr-x  3 postgres postgres 4096 Sep 20 09:21 pgsql
drwxr-xr-x  2 root     root     4096 Apr 28 00:09 sbin
drwxr-xr-x  4 root     root     4096 Sep 14 16:59 share
drwxr-xr-x  2 root     root     4096 Apr 28 00:09 src
bash-3.00$ ls -l /usr/local/pgsql/
total 8
drwx------  2 postgres postgres 4096 Sep 21 13:37 data
bash-3.00$ whoami
postgres
bash-3.00$ initdb -D /usr/local/pgsql/data/
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 en_US.UTF-8.
The default database encoding has accordingly been set to UNICODE.

initdb: directory "/usr/local/pgsql/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/usr/local/pgsql/data" or run initdb
with an argument other than "/usr/local/pgsql/data".
bash-3.00$ rm -R /usr/local/pgsql/data/*
bash-3.00$ initdb -D /usr/local/pgsql/data/
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 en_US.UTF-8.
The default database encoding has accordingly been set to UNICODE.

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... child
process exited with exit code 1
initdb: removing contents of data directory "/usr/local/pgsql/data"
bash-3.00$

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum doesn't seem to vacuum pg_attribute
Next
From: "Brian Cox"
Date:
Subject: BUG #1904: using distinct with null col causes error