Upgrading with WALs

From: Chris Bovitz <Christopher(dot)Bovitz(at)noaa(dot)gov>
To: pgsql-admin(at)postgresql(dot)org
Subject: Upgrading with WALs
Date: 2008-07-29 21:03:54
Message-ID: 488F85BA.7030702@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

As I mentioned earlier, we are doing major upgrades to our database
servers from 8.1.3 which necessitates the use of pg_dumpall. But what
do we do with the WALs? Should we delete them? Or should we leave them
there, and the new version of PostgreSQL will pick up where they left
off? Should we turn off WAL archiving while rebuilding the database
with the pg_dumpall output?

Thanks again.

Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2008-07-29 21:07:06 Re: Upgrading with WALs
Previous Message Tom Lane 2008-07-29 19:08:38 Re: Privileges & roles