Thread: Upgrading with WALs

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

On Tue, 2008-07-29 at 16:03 -0500, Chris Bovitz wrote:
> 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?

You can not use one cluster on top of the other. Once you have the new
PostgreSQL installation upgraded you would remove your old one. E.g;
this will be an outage, you can not do it online (without something like
SlonY0.

Sincerely,

Joshua D. Drake


>
> Thanks again.
>
>
> Chris
>
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate