From: | "Angva" <angvaw(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | upgrading and pg_restore versions |
Date: | 2007-01-04 20:42:48 |
Message-ID: | 1167943368.047235.163000@11g2000cwr.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Postgres gurus,
I come seeking advice on upgrading my 8.1.2 databases to 8.2. My
environment in a nutshell: I have a master database on one server that
is used to process large amounts of data. This data is replicated daily
to several destination databases, each on a separate server. There are
so many destinations that I fear I won't be able to upgrade them all in
one evening.
Does anyone know if it would be safe to upgrade a subset of the
databases per night? I am concerned with version mismatches between dmp
files, pg_restore, and destination database versions. Should the
pg_restore still work ok? And if that is ok, should the master database
be upgraded in any particular order (before or after the destinations)?
I would greatly appreciate any advice that can be offered.
Thanks!
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Wes | 2007-01-04 22:23:45 | Re: Index vacuum improvements in 8.2 |
Previous Message | John McCawley | 2007-01-04 20:39:14 | Re: Any form of connection-level "session variable" ? |