| 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: | Whole Thread | Raw Message | 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" ? |