pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Upgrading with WALs 2+ messages / 2 participants [nested] [flat]
* Upgrading with WALs @ 2008-07-29 21:03 Chris Bovitz <Christopher.Bovitz@noaa.gov> 2008-07-29 21:07 ` Re: Upgrading with WALs Joshua D. Drake <jd@commandprompt.com> 0 siblings, 1 reply; 2+ messages in thread From: Chris Bovitz @ 2008-07-29 21:03 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Upgrading with WALs 2008-07-29 21:03 Upgrading with WALs Chris Bovitz <Christopher.Bovitz@noaa.gov> @ 2008-07-29 21:07 ` Joshua D. Drake <jd@commandprompt.com> 0 siblings, 0 replies; 2+ messages in thread From: Joshua D. Drake @ 2008-07-29 21:07 UTC (permalink / raw) To: Chris Bovitz <Christopher.Bovitz@noaa.gov>; +Cc: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-07-29 21:07 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-07-29 21:03 Upgrading with WALs Chris Bovitz <Christopher.Bovitz@noaa.gov> 2008-07-29 21:07 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox