Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group