Re: pg_dump new version

I'm not clear when you said that "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". Did you mean that it's OK to use the old version of pg_dump when you are doing a major version upgrade when working with a RPM package?

Thanks
Mary

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Tuesday, February 23, 2010 7:47 AM
To: Oliver Kohll - Mailing Lists
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] pg_dump new version

Oliver Kohll - Mailing Lists <oliver(dot)lists(at)gtwm(dot)co(dot)uk> writes:
> May I take a lull between PG releases to ask an upgrade Q? Documentation and people often recommend that when doing a major version upgrade, to dump data from the old server with the new version of pg_dump, since the new pg_dump may have bugfixes not 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

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general