pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gregory S. Williamson <gsw@globexplorer.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Something like pg_dump for 7.4
Date: Fri, 17 Feb 2006 01:19:35 -0500
Message-ID: <5528.1140157175@sss.pgh.pa.us> (raw)
In-Reply-To: <71E37EF6B7DCC1499CEA0316A2568328024BBF9D@loki.wc.globexplorer.net>
References: <71E37EF6B7DCC1499CEA0316A2568328024BBF9D@loki.wc.globexplorer.net>

"Gregory S. Williamson" <gsw@globexplorer.com> writes:
> I am trying to migrate a modest sized database (the unload file is just under a gigabyte) which is moderately complex, using schemas and the like from 7.4 to 8.1
> Alas, pg_dump appears to incompatable with my needs as it keeps introducing invalid UTF-8 characters. 

It's quite unlikely that pg_dump is at fault.  Rather the data you are
dumping is probably wrong.  There were some errors in pre-8.1 versions
that caused them to accept byte sequences that are not actually legal
UTF8 strings.  8.1 has tightened up that code and so will reject data
that 7.4 thought was legal.

Check the archives for some previous discussions about reasonable ways
to fix bad data --- I seem to recall iconv being mentioned as one
possible filter for your dump file.

> Is there any way to do this ? I can't edit the resulting dump file by hand -- it's huge. And pg_dump on 7.4 does not know how to a table inside a schema -- it seems to be all or nothing.

You could use the 8.1 pg_dump against the 7.4 server if you need more
flexibility.

			regards, tom lane



view thread (6+ messages)  latest in thread

Message-ID: <5528.1140157175@sss.pgh.pa.us>
Permalink:  ../5528.1140157175@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/5528.1140157175@sss.pgh.pa.us

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, gsw@globexplorer.com
  Subject: Re: Something like pg_dump for 7.4
  In-Reply-To: <5528.1140157175@sss.pgh.pa.us>
  References: <71E37EF6B7DCC1499CEA0316A2568328024BBF9D@loki.wc.globexplorer.net> <5528.1140157175@sss.pgh.pa.us>

* 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