Re: Recommended approach for upgrading DBs with nonmatching encodings

From: Martin Pitt <martin(at)piware(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Recommended approach for upgrading DBs with nonmatching encodings
Date: 2008-03-30 20:39:38
Message-ID: 20080330203938.GO6486@piware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi again,
Martin Pitt [2008-03-30 20:40 +0200]:
> My current pg_upgradecluster uses pg_dumpall to copy the schema, and a
> per-db pg_dump to copy the DB table contents. Will calling pg_dump
> with --encoding=<encoding of 8.3 server's locale> always DTRT and is
> it meant to solve this problem?

One problem with this is that while pg_dump -E UTF8 works (with SQL
output), -E does not seem to have any effect when using -Fc. However,
-Fc is a must for a reasonably robust automatic upgrade script.

Thanks in advance,

Martin
--
Martin Pitt | http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-03-30 20:43:57 Re: Recommended approach for upgrading DBs with nonmatching encodings
Previous Message Martin Pitt 2008-03-30 18:40:50 Recommended approach for upgrading DBs with nonmatching encodings