global/pg_database ?
Posting again as even though I receive mail from hackers I am apparently
not a member (registered correctly as prlw1@cam.ac.uk - from will say
prlw1@newn.cam.ac.uk - setting reply-to to prlw1@cam.ac.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
Patrick Welche <prlw1@newn.cam.ac.uk> writes:
Posting again as even though I receive mail from hackers I am apparently
not a member (registered correctly as prlw1@cam.ac.uk - from will say
prlw1@newn.cam.ac.uk - setting reply-to to prlw1@cam.ac.uk used to get
around it..)
Easiest answer might be to subscribe again under that address and then
set it to 'nomail', or whatever the option is to turn off actually
receiving mail from the list (yes, there is one...).
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
That is the correct contents of $PGDATA/global in current sources ---
pg_database's file is now named by its OID, ie 1262, not by its relname.
Not sure why you are getting such a message, but it strikes me that you
may have a corrupted set of sources, ie, some out-of-date files. Have
you tried doing a fresh cvs checkout and build from scratch?
regards, tom lane
psql: FATAL 1: cannot open /usr/local/pgsql/data/global/pg_database: No such file or directory
Not sure why you are getting such a message, but it strikes me that you
may have a corrupted set of sources, ie, some out-of-date files. Have
you tried doing a fresh cvs checkout and build from scratch?
To be more specific, I suspect that would be coming out of
GetRawDatabaseInfo if compiled with OLD_FILE_NAMING defined. Possibly
you have an old config.h (have you rerun configure lately?) or neglected
to do a make clean before rebuilding.
regards, tom lane