Re: Grabing and applying a dump

Kevin Grittner-5 wrote
> Marc Richter <

> richter_marc@

> > 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.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Grabing-and-applying-a-dump-tp5813794p5813810.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.