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@gmx.net
> <mailto:richter_marc@gmx.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