Обсуждение: 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
>> 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
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