Re: pg_dump new version - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump new version
Date
Msg-id 22144.1266940049@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump new version  (Oliver Kohll - Mailing Lists <oliver.lists@gtwm.co.uk>)
Responses Re: pg_dump new version  ("Wang, Mary Y" <mary.y.wang@boeing.com>)
List pgsql-general
Oliver Kohll - Mailing Lists <oliver.lists@gtwm.co.uk> writes:
> May I take a lull between PG releases to ask an upgrade Q? Documentation and people often recommend that when doing a
majorversion upgrade, to dump data from the old server with the new version of pg_dump, since the new pg_dump may have
bugfixesnot available to the old. 
> ...
> So for someone using RPM packages to install Postgres, what's the recommended sequence to do this?

There isn't any especially good way to do it with the RPM packages
(at least not the ones from Red Hat or PGDG), because you can't
concurrently install different versions.  In practice the old pg_dump
should work fine for this purpose in practically all cases, so it's
not worth your trouble to try to figure out a workaround.

(I am hoping that in 9.0 we have a better upgrade path for RPM
installations.)

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: SET Role doesn't work from Security Definer Function...
Next
From: Tom Lane
Date:
Subject: Re: Minor systax error but not able to resolve it...