upgrading and pg_restore versions

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

Responses

Browse pgsql-general by date

  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" ?