Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump new version

pg_dump new version

From
Oliver Kohll - Mailing Lists
Date:
Hello,

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. 

I've never done this simply because it's not clear from the docs how to - perhaps it's platform dependant. The upgrade
doc
http://www.postgresql.org/docs/8.4/interactive/install-upgrading.html
is a very clear step by step procedure to follow with the exception of

'To make the backup, you can use the pg_dumpall command from the version you are currently running. For best results,
however,try to use the pg_dumpall command fromPostgreSQL 8.4.2, since this version contains bug fixes and improvements
overolder versions. While this advice might seem idiosyncratic since you haven't installed the new version yet, it is
advisableto follow it if you plan to install the new version in parallel with the old version'. 

So for someone using RPM packages to install Postgres, what's the recommended sequence to do this?

Regards
Oliver Kohll
www.agilebase.co.uk

Re: pg_dump new version

From
Alban Hertroys
Date:
On 23 Feb 2010, at 10:45, Oliver Kohll - Mailing Lists wrote:

> Hello,
>
> 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. 
>
> I've never done this simply because it's not clear from the docs how to - perhaps it's platform dependant. The
upgradedoc 
> http://www.postgresql.org/docs/8.4/interactive/install-upgrading.html
> is a very clear step by step procedure to follow with the exception of
>
> 'To make the backup, you can use the pg_dumpall command from the version you are currently running. For best results,
however,try to use the pg_dumpall command fromPostgreSQL 8.4.2, since this version contains bug fixes and improvements
overolder versions. While this advice might seem idiosyncratic since you haven't installed the new version yet, it is
advisableto follow it if you plan to install the new version in parallel with the old version'. 
>
> So for someone using RPM packages to install Postgres, what's the recommended sequence to do this?


I'm not familiar with RPM packages (or any other Linux package manager), but don't they have a separate package with
theclient applications? My OS of choice does. 

Alban Hertroys

--
Screwing up is the best way to attach something to the ceiling.


!DSPAM:737,4b83c85910441343920892!

Re: pg_dump new version

From
Tom Lane
Date:
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

Re: pg_dump new version

From
"Wang, Mary Y"
Date:
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
worthyour trouble to try to figure out a workaround".  Did you mean that it's OK to use the old version of pg_dump when
youare doing a major version upgrade when working with a RPM package?   

Thanks
Mary


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

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),
becauseyou can't concurrently install different versions.  In practice the old pg_dump should work fine for this
purposein 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@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general