agora inbox for pgsql-general@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@gmail.com>
To: pgsql-general@postgresql.org
Cc: Martín Marqués <martin.marques@gmail.com>
Cc: Vick Khera <vivek@khera.org>
Subject: Re: pg_dump problems
Date: Wed, 23 Mar 2011 07:18:39 -0700
Message-ID: <201103230718.40361.adrian.klaver@gmail.com> (raw)
In-Reply-To: <AANLkTi=cRUPnFT4Jb-o1MpU+7SomrPtbR=jxSy4=x_SA@mail.gmail.com>
References: <AANLkTinjOO5_6xupQ=UakBdUnU2NKcgJG8b_YzuoZejS@mail.gmail.com>
<AANLkTi=aUNEsaacooaTcXV1YEY8G_ATmrTJGG1u5Uk74@mail.gmail.com>
<AANLkTi=cRUPnFT4Jb-o1MpU+7SomrPtbR=jxSy4=x_SA@mail.gmail.com>
On Wednesday, March 23, 2011 6:57:35 am Martín Marqués wrote:
> Now I'm getting weirder things. I did a pg_dump with -d option and the
> dump adds strange caracters:
As previously stated try using the 8.4 version of pg_dump to dump the 8.3
database. FYI in 8.4+ there is no -d option anymore, it has become --inserts to
reduce confusion with other commands where -d specified the database.
>
> ERROR: error de sintaxis en o cerca de «I»
> LÍNEA 1: I^NSERT INTO objeto_datos_rep VALUES (1172339, 387943, 'Wilde...
>
> Could it be binary corruption (pg_dump for example)?
>
> 2011/3/23 Vick Khera <vivek@khera.org>:
> > 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.
>
> I'll try this.
>
> > 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).
>
> bytea has encoding? I thought it was plain binary data.
I think he was talking about bytea_output, which appeared in 9.0.
In any event you may want to verify that the encodings/locales for the two
databases are the same.
--
Adrian Klaver
adrian.klaver@gmail.com
view thread (20+ messages) latest in thread
Message-ID: <201103230718.40361.adrian.klaver@gmail.com>
Permalink: ../201103230718.40361.adrian.klaver@gmail.com/
Also on: postgresql.org/message-id/201103230718.40361.adrian.klaver@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: adrian.klaver@gmail.com, martin.marques@gmail.com, vivek@khera.org
Subject: Re: pg_dump problems
In-Reply-To: <201103230718.40361.adrian.klaver@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox