Postgres Pro
Downloads
Home   >   mailing lists

Re: Superuser lost access to particular database - Mailing list pgsql-general

From Tom Lane
Subject Re: Superuser lost access to particular database
Date
Msg-id 9449.1158030418@sss.pgh.pa.us
Whole thread Raw
In response to Superuser lost access to particular database  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
Tree view 
Francisco Reyes <lists@stringsutils.com> writes:
> I have one database owned by "user1" which as of 4 days ago the superuser,
> pgsql, can't see any tables.

Transaction ID wraparound ... I take it this is not PG 8.1?

As long as it's at least 7.4, vacuuming the system catalogs should help.

            regards, tom lane

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Superuser lost access to particular database
Next
From: Francisco Reyes
Date:
Subject: Re: Superuser lost access to particular database