Re: FATAL 1: Relation 'pg_shadow' does not exist

Gavin Sherry wrote:
> 
> I am getting this error when I attempt to connect to a production
> database. All other databases have valid pg_shadow and appear to be fine.
> 
> The database version is
> 
>  PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
> 
> Logging was going to the terminal (completely useless, I know) but there
> was an interesting error from a VACUUM of another database on the system:
> 
> NOTICE:  Rel qafinal_fti_i: TID 2023/112: OID IS INVALID. TUPGONE 0.
> 
> The affected database was not being vacuumed, not had it been since I'd
> seen it 'stable'.
> 
> Does anyone have any ideas about this? Anything to prevent my needing to
> go to tape and spend a long night in a cold cold server room?

Can you connect to the db using standalone postgres ?
i.e.
 postgres -P -O your_database_name

regards,
Hiroshi Inoue
> 
> Thanks
> 
> Gavin
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)