Tom Lane writes:
Francisco Reyes <lists@xxxxxxxxxxxxxxxx> writes:
I have one database owned by "user1" which as of 4 days ago the superuser,
pgsql, can't see any tables.
After furhter researching found that I could not see the tables because I
have them in diferent schemas.. and the superuser didn't have them in the
path.
However the pg_dumpall is still freezing in that database.
Transaction ID wraparound ... I take it this is not PG 8.1?
8.1.3 Compiled from ports in FreeBSD 6.1 Stable.
select version();
version
----
PostgreSQL 8.1.3 on i386-portbld-freebsd6.0, compiled by GCC cc (GCC) 3.4.4
[FreeBSD] 20050518
As long as it's at least 7.4, vacuuming the system catalogs should help.
vacuum the database in question?
