possible bug...

From: SriKumar Kareti <SriKumar(dot)Kareti(at)spanlink(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: possible bug...
Date: 2005-09-21 18:49:35
Message-ID: 1127328575.3913.5.camel@karetis.spanlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello!

I am trying to install postgres 8.0.3 from rpms.

[karetis(at)karetis ~]$ rpm -qa | grep postgres
postgresql-8.0.3-1PGDG
postgresql-server-8.0.3-1PGDG
postgresql-libs-8.0.3-1PGDG
[karetis(at)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$

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-09-21 19:16:14 Re: BUG #1903: result incorrect when function max() in table with inherit used
Previous Message Cesar Paipilla 2005-09-21 16:40:07 BUG #1903: result incorrect when function max() in table with inherit used