Re: pg_dump problems - Mailing list pgsql-general

From Vick Khera
Subject Re: pg_dump problems
Date
Msg-id AANLkTi=aUNEsaacooaTcXV1YEY8G_ATmrTJGG1u5Uk74@mail.gmail.com
Whole thread Raw
In response to pg_dump problems  (Martín Marqués <martin.marques@gmail.com>)
Responses Re: pg_dump problems  (Martín Marqués <martin.marques@gmail.com>)
List pgsql-general
2011/3/23 Martín Marqués <martin.marques@gmail.com>:
> The scenario is like this. I tried today to dump a DB from our
> production server to load on our development server and got some
> errors, which I show below.


Try using the pg_dump from the 8.4 install to create your dump file.

Also make sure your 8.3 installation doesn't have a non-default bytea
encoding setting (not sure when that setting was introduced, so there
may not even be such a setting).

pgsql-general by date:

Previous
From: Martín Marqués
Date:
Subject: pg_dump problems
Next
From: Disc Magnet
Date:
Subject: PostgreSQL documentation specifies 2-element array for float8_accum but 3-element array expected