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

Wed, 3 Jan 2001 19:12:35 +0000
Patrick Welche <prlw1@newn.cam.ac.uk>
global/pg_database ?
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

Sat, 06 Jan 2001 15:41:59 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: global/pg_database ? 
>> 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

Sat, 06 Jan 2001 16:07:33 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: global/pg_database ? 