Skip site navigation (1) Skip section navigation (2)

global/pg_database ?

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: global/pg_database ?
Date: 2001-01-03 19:12:35
Message-ID: 20010103191235.E28924@quartz.newn.cam.ac.uk (view raw or flat)
Thread:
Lists: pgsql-hackers
Posting again as even though I receive mail from hackers I am apparently
not a member (registered correctly as prlw1(at)cam(dot)ac(dot)uk - from will say
prlw1(at)newn(dot)cam(dot)ac(dot)uk - setting reply-to to prlw1(at)cam(dot)ac(dot)uk used to get
around it..)

====

psql: FATAL 1:  cannot open /usr/local/pgsql/data/global/pg_database: No such fi
le 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 --wit
h-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

Responses

pgsql-hackers by date

Next:From: ineckDate: 2001-01-03 20:07:22
Subject: ERROR: cannot find attribute 10 of???
Previous:From: Patrick WelcheDate: 2001-01-03 19:04:12
Subject: initdb prob

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group