From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | initdb prob |
Date: | 2001-01-03 19:04:12 |
Message-ID: | 20010103190412.C28924@quartz.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
psql: FATAL 1: cannot open /usr/local/pgsql/data/global/pg_database: No such file or directory
and it's true..
% ls /usr/local/pgsql/data/global
1260 1261 1262 1264 1269 17127 17130 pg_control
source from Jan 3 15:59 GMT
configure --enable-locale --enable-recode --enable-debug --enable-cassert --with-CXX
all but geometry (rounding errors) pass gmake runcheck
PGLIB=/usr/local/pgsql/lib
PGDATA=/usr/local/pgsql/data
PGDATESTYLE=European
LC_ALL=en_GB.ISO8859-1
then did the initdb
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.
Creating directory /usr/local/pgsql/data
Creating directory /usr/local/pgsql/data/base
Creating directory /usr/local/pgsql/data/global
Creating directory /usr/local/pgsql/data/pg_xlog
Creating template1 database in /usr/local/pgsql/data/base/1
DEBUG: starting up
DEBUG: database system was shut down at 2001-01-03 18:51:59
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/local/pgsql/data/global
DEBUG: starting up
DEBUG: database system was shut down at 2001-01-03 18:52:03
DEBUG: CheckPoint record at (0, 108)
DEBUG: Redo record at (0, 108); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 514; NextOid: 17199
DEBUG: database system is in production state
Initializing pg_shadow.
Enabling unlimited row width for system tables.
Creating system views.
Loading pg_description.
Setting lastsysoid.
Vacuuming database.
Copying template1 to template0.
Success. You can now start the database server using:
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
or
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start
Any ideas?
Cheers,
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Welche | 2001-01-03 19:12:35 | global/pg_database ? |
Previous Message | Peter Eisentraut | 2001-01-03 16:54:26 | Re: [HACKERS] Re: Inheritance docs error. |