Re: Help me recovering data - Mailing list pgsql-hackers

From Kouber Saparev
Subject Re: Help me recovering data
Date
Msg-id 002201c512bb$dfb23670$8100030a@pdc.imro.bg
Whole thread Raw
In response to Help me recovering data  ("Kouber Saparev" <postgresql@saparev.com>)
List pgsql-hackers
> Once you've found a NextXID setting you like, I'd suggest an immediate
> pg_dumpall/initdb/reload to make sure you have a consistent set of data.
> Don't VACUUM, or indeed modify the DB at all, until you have gotten a
> satisfactory dump.
>
> Then put in a cron job to do periodic vacuuming ;-)

Thank you, I just discovered in the mailing lists that I'm not the first nor
the last guy that have forgotten to VACUUM the database. ;-)

Regards,
Kouber Saparev



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help me recovering data
Next
From: Ron Mayer
Date:
Subject: Re: Query optimizer 8.0.1 (and 8.0)