vacuumb avz, pg_dumpall, and vacuum freeze analyze on the former standby database that received the corruption via replication all came back without errors. Is the vacuum freeze intended to potentially fix problems or just reveal if other tables may have corruption, Im trying to decide if this needs to be run in production.
On Thu, Nov 21, 2013 at 5:09 PM, Kevin Grittner <kgri...@ymail.com> wrote: > Mike Broers <mbro...@gmail.com> wrote: > > > Is there anything I should look out for with vacuum freeze? > > Just check the logs and the vacuum output for errors and warnings. > > -- > Kevin Grittner > EDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company >
