Upgrading with WALs - Mailing list pgsql-admin

From Chris Bovitz
Subject Upgrading with WALs
Date
Msg-id 488F85BA.7030702@noaa.gov
Whole thread Raw
Responses Re: Upgrading with WALs  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Privileges & roles
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Upgrading with WALs