From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Moshe Ben-Shoham <mosheb(at)nexperience(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Encoding problem using pg_dumpall |
Date: | 2009-01-29 17:45:25 |
Message-ID: | 4981EB35.5060106@hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Tom Lane wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
>> Tom Lane wrote:
>>> (Hmm, actually it looks like pg_dumpall hasn't got a -E switch,
>>> which seems like an oversight. So you need to fix your locale,
>>> or else use pg_dump directly.)
>
>> IIRC, you can't set the windows console to be UTF8.
>
> Ugh. That seems to raise the priority of having a -E switch quite
> a lot. I'm surprised no one has complained of this before.
Most people use pg_dump. I know I recommend everbody to use pg_dump to
dump the database, because you can use -Fc. Then just use pg_dumpall to
dump the globals, and they normally don't have any non-ascii in them.
> I think it should be possible to work around it by setting
> PGCLIENTENCODING in the environment, but I dunno how to do that
> on Windows.
That's a simple
set PGCLIENTENCODING=UTF8
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Monnerie | 2009-01-29 19:14:28 | Re: [GENERAL] Encoding problem using pg_dumpall |
Previous Message | Tom Lane | 2009-01-29 17:39:54 | Re: [GENERAL] Encoding problem using pg_dumpall |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-01-29 17:47:55 | Re: Full backup - pg_dumpall sufficient? |
Previous Message | Richard Huxton | 2009-01-29 17:43:42 | Re: Pet Peeves? |