Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 832E064FD40
	for <pgsql-general-postgresql.org@postgresql.org>;
	Fri, 29 Aug 2008 13:05:06 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 64958-02 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Fri, 29 Aug 2008 13:05:02 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from QMTA08.emeryville.ca.mail.comcast.net
	(qmta08.emeryville.ca.mail.comcast.net [76.96.30.80])
	by postgresql.org (Postfix) with ESMTP id 912F964FCF0
	for <pgsql-general@postgresql.org>;
	Fri, 29 Aug 2008 13:05:02 -0300 (ADT)
Received: from OMTA05.emeryville.ca.mail.comcast.net ([76.96.30.43])
	by QMTA08.emeryville.ca.mail.comcast.net with comcast
	id 8Dgk1a05K0vp7WLA8G519N; Fri, 29 Aug 2008 16:05:01 +0000
Received: from tucker.local ([67.160.97.168])
	by OMTA05.emeryville.ca.mail.comcast.net with comcast
	id 8G501a00Q3dyZyT8RG51cK; Fri, 29 Aug 2008 16:05:01 +0000
X-Authority-Analysis: v=1.0 c=1 a=QmdFd5s5F0IA:10 a=SVE-NqTGKtEA:10
	a=raGLB5yhZlVc9ouvt_0A:9 a=-xZloog5ogtkDu7KdGu-hMj8DvMA:4
	a=si9q_4b84H0A:10 a=LY0hPdMaydYA:10
From: Adrian Klaver <aklaver@comcast.net>
To: pgsql-general@postgresql.org
Subject: Re: Dumping/Restoring with constraints?
Date: Fri, 29 Aug 2008 09:05:01 -0700
User-Agent: KMail/1.9.10
Cc: "Phoenix Kiula" <phoenix.kiula@gmail.com>,
	"Andrew Sullivan" <ajs@commandprompt.com>
References: <e373d31e0808270619uba31c8eodc2c85662b85140a@mail.gmail.com>
	<200808290824.45721.aklaver@comcast.net>
	<e373d31e0808290829v47d4ffe9k5fd24c7183fc19c3@mail.gmail.com>
In-Reply-To: <e373d31e0808290829v47d4ffe9k5fd24c7183fc19c3@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200808290905.01881.aklaver@comcast.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200808/1121
X-Sequence-Number: 136951

On Friday 29 August 2008 8:29:55 am Phoenix Kiula wrote:
> Thanks so much! I think we may be on to something:
>
>
> On the pg_dump machine:
>
> LANG=en_US.UTF-8
> LC_CTYPE="en_US.UTF-8"
> LC_NUMERIC="en_US.UTF-8"
> LC_TIME="en_US.UTF-8"
> LC_COLLATE="en_US.UTF-8"
> LC_MONETARY="en_US.UTF-8"
> LC_MESSAGES="en_US.UTF-8"
> LC_PAPER="en_US.UTF-8"
> LC_NAME="en_US.UTF-8"
> LC_ADDRESS="en_US.UTF-8"
> LC_TELEPHONE="en_US.UTF-8"
> LC_MEASUREMENT="en_US.UTF-8"
> LC_IDENTIFICATION="en_US.UTF-8"
> LC_ALL=
>
>
>
> On the pg_restore machine:
>
>
> LANG=
> LC_COLLATE="C"
> LC_CTYPE="UTF-8"
> LC_MESSAGES="C"
> LC_MONETARY="C"
> LC_NUMERIC="C"
> LC_TIME="C"
> LC_ALL=
>
>
>
> So how can I change the locale on my local OSX machine? This could be
> it. Thanks!

Might also be useful to do SHOW ALL from within the database cluster you have 
on your restore machine. Will show what choices initdb made.

test=# SHOW all;
<Snip>
 lc_collate                      | en_US.UTF-8 
 lc_ctype                        | en_US.UTF-8                                                      
 lc_messages                     | en_US.UTF-8                                                      
 lc_monetary                     | en_US.UTF-8                                                    
 lc_numeric                      | en_US.UTF-8                                                      
 lc_time                         | en_US.UTF-8 
<Snip>
-- 
Adrian Klaver
aklaver@comcast.net