Re: Grabing and applying a dump

Am 07.08.2014 21:58, schrieb Michael Wood:
> Hi
>
> On 07 Aug 2014 11:36 AM, "Marc Richter" <richter_marc(at)gmx(dot)net
> <mailto:richter_marc(at)gmx(dot)net>> wrote:
> >
> >
> > Am 05.08.2014 19:33, schrieb David G Johnston:
> >
> >> Kevin Grittner-5 wrote:
> >>>>
> >>>> 1) create a dump from a source server using pg_dumpall with
> >>>> 'column-inserts' option.
> >>>> 2) Applying that dump into another server using psql.
> >>>>
> >>> NOREPLICATION would not be included in pg_dumpall output unless you
> >>> are using executables from 9.1 or later. Try running pg_dumpall
> >>> --version and see what it says.
> >>
> >> Marc,
> >>
> >> You need to be more precise on the different servers and versions. Note
> >> that you should not use the dump/restore tools from a version more
> recent
> >> than the version you are restoring into. It sounds like you may be
> trying
> >> to restore into a 8.2 server but using a newer toolset.
> >>
> >> David J.
> >>
> >
> > Hi David and Kevin, thank you for your helpful input!
> >
> > You are right: Some of my tests to apply the dump to a fresh 8.2.5
> instance were done using recent tools. I thought this is not a problem
> or even: the better choice, since the official Postgres Docs seems to
> suggest this:
> >
> > http://www.postgresql.org/docs/9.1/static/upgrading.html:
> >
> > """
> > It is recommended that you use thepg_dumpandpg_dumpallprograms from
> the newer version ofPostgreSQL, to take advantage of enhancements that
> might have been made in these programs. Current releases of the dump
> programs can read data from any server version back to 7.0.
> > """
> >
> > But you are right: When I use only 8.2.5 tools, these kind of issues
> do not happen! Thank you.
>
> What that means is that when you are upgrading from an older version to
> a newer version you should use the pg_dumpall from the newer version
> (that you are upgrading to). It does not mean you should use pg_dumpall
> from a version newer than the version of Postgres that you are upgrading to.
>

I've read it like "if you have a newer version of client tools
available, use it for all purposes, since they are fully backwards
compatible anyway". I know this isn't what's written there. I just say
what I have read it like.

Best regards,
Marc