Skip site navigation (1) Skip section navigation (2)

Re: Dumping/Restoring with constraints?

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>, "Andrew Sullivan" <ajs(at)commandprompt(dot)com>
Subject: Re: Dumping/Restoring with constraints?
Date: 2008-08-29 16:05:01
Message-ID: 200808290905.01881.aklaver@comcast.net (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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(at)comcast(dot)net

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-08-29 16:06:38
Subject: Re: compat-postgresql-libs not in the repo?
Previous:From: slamp slampDate: 2008-08-29 16:03:18
Subject: Re: compat-postgresql-libs not in the repo?

pgsql-general by date

Next:From: Phoenix KiulaDate: 2008-08-29 16:07:25
Subject: Re: Dumping/Restoring with constraints?
Previous:From: btoberDate: 2008-08-29 15:45:37
Subject: Re: pg_dumpall problem when roles have default schemas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group