"Carlos Sotto Maior (SIM)" <csotto@xxxxxxxxxxxxxxxxxx> wrote: > If I run a database wise 'vacuum freeze' and all goes well does it > means I do not have to take any action? If you run it in all databases except template0, and it doesn't generate any errors, you are good. > Dumping and recreating the data base would be my best option to > get rid of this potential problem. Correct ? If you're in a state where a simple VACUUM FREEZE won't fix it, the pg_dump won't run without error, and won't contain all your data. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
