From: Adrian Klaver <aklaver@comcast.net>
To: pgsql-general@postgresql.org
Cc: Phoenix Kiula <phoenix.kiula@gmail.com>
Cc: Andrew Sullivan <ajs@commandprompt.com>
Subject: Re: Dumping/Restoring with constraints?
Date: Fri, 29 Aug 2008 09:05:01 -0700
Message-ID: <200808290905.01881.aklaver@comcast.net> (raw)
In-Reply-To: <e373d31e0808290829v47d4ffe9k5fd24c7183fc19c3@mail.gmail.com>
References: <e373d31e0808270619uba31c8eodc2c85662b85140a@mail.gmail.com>
<200808290824.45721.aklaver@comcast.net>
<e373d31e0808290829v47d4ffe9k5fd24c7183fc19c3@mail.gmail.com>
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
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: aklaver@comcast.net, pgsql-general@postgresql.org, phoenix.kiula@gmail.com, ajs@commandprompt.com
Subject: Re: Dumping/Restoring with constraints?
In-Reply-To: <200808290905.01881.aklaver@comcast.net>
* 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