So, as I mentioned, I have tried to get this straightened out by vacuuming all in --single mode, but to no avail. I executed the following command, to see which tables were in trouble:
SELECT relname, age(relfrozenxid) FROM pg_class WHERE relkind = 'r'; And found a table listed, that DOES NOT exist any longer. Do I have any recourse other than to drop and rebuild all of my tables? Can I just dump, drop and recreate my database? How do I drop a database in --single mode? Thanks, r.b. On Sun, Oct 10, 2010 at 7:21 AM, Robert Burgholzer <rburg...@vt.edu> wrote: > > ERROR: database is not accepting commands to avoid wraparound data > loss in database "vwuds" > > So, I vacuum each and every db in my ... but am still hampered by this > error. > -- -- Robert W. Burgholzer http://www.findingfreestyle.com/ Find us on Facebook by searching "Finding Freestyle" -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
