From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Disabling triggers with psql (gforge 7.4 to 8.2 migration)
Date: Wed, 10 Feb 2010 17:59:33 +0100
Message-ID: <1265821173.6369.32.camel@coyote> (raw)
In-Reply-To: <20100210162104.GE4922@alvh.no-ip.org>
References: <99024f5f1002071922j5b14c350mb1612313690f16ec@mail.gmail.com>
<87k4umg0c3.fsf@hi-media-techno.com>
<1265794218.3714.12.camel@coyote>
<20100210162104.GE4922@alvh.no-ip.org>
Hmm...
No, I've not tried it. Does pg_dump perform some kind of truncating over
bad chars? If yes, my problem would be solved!
When actual test finish, I will try again with pg_dump from 8.2
Thank you, Alvaro.
-----Original Message-----
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Disabling triggers with psql (gforge 7.4 to 8.2
migration)
Date: Wed, 10 Feb 2010 13:21:04 -0300
Iñigo Martinez Lasala wrote:
> Third one, and we haven't been able to fix it, is we cannot restore data
> dump via psql due to psql does not have an option to disable triggers.
> So, when restoring data, it fails. So... is there any way to disable in
> a psql session all triggers same way like with pg_restore
> --disable-triggers? Or can we convert plain text dump to be processed
> by pg_restore? Perhaps a table by table trigger disabling script?
Have you tried using 8.2's pg_dump instead of the old one?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
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-admin@postgresql.org
Cc: imartinez@vectorsf.com, alvherre@commandprompt.com
Subject: Re: Disabling triggers with psql (gforge 7.4 to 8.2 migration)
In-Reply-To: <1265821173.6369.32.camel@coyote>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox