Re: Grabing and applying a dump

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.

Best regards,
Marc