From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Chris Bovitz <Christopher(dot)Bovitz(at)noaa(dot)gov> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Upgrading with WALs |
Date: | 2008-07-29 21:07:06 |
Message-ID: | 1217365626.24458.21.camel@jd-laptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jesper Krogh | 2008-07-30 18:41:38 | PITR backup & recovery. |
Previous Message | Chris Bovitz | 2008-07-29 21:03:54 | Upgrading with WALs |