| From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Grabing and applying a dump |
| Date: | 2014-08-05 17:33:20 |
| Message-ID: | 1407260000182-5813810.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Richter | 2014-08-07 09:35:08 | Re: Grabing and applying a dump |
| Previous Message | Kevin Grittner | 2014-08-05 17:00:55 | Re: Grabing and applying a dump |