"Carlos Sotto Maior (SIM)" <csotto(at)sistemassim(dot)com(dot)br> 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