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.