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

Re: global/pg_database ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: prlw1(at)cam(dot)ac(dot)uk
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: global/pg_database ?
Date: 2001-01-06 20:41:59
Message-ID: 18358.978813719@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> writes:
> 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..)

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

In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2001-01-06 21:05:08
Subject: pg_restore options issues
Previous:From: Tom LaneDate: 2001-01-06 20:24:51
Subject: is_view seems unnecessarily slow

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