James A Cole wrote:
> mkeB_reports=# \d arrivals
> Did not find any relation named "arrivals".
>
> mkeB_reports=# select * from arrivals where ontime>'2006-6-21';
> [data]
> There are many other databases on this server. Most
> do not have this problem.
Ah, so this is the only one that has suffered transaction id wraparound.
If you don't want to restore from backup, you may want to search the
archives for old threads. Use keywords "transaction id wraparound" or
maybe "xid wraparound".
Next time you really want to make sure you vacuum the whole database,
often.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
