Re: Grabing and applying a dump

Hi

On 07 Aug 2014 11:36 AM, "Marc Richter" <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.