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

Re: Dumping/Restoring with constraints?

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Dumping/Restoring with constraints?
Date: 2008-08-29 15:18:02
Message-ID: 20080829151802.GF29678@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
On Fri, Aug 29, 2008 at 11:12:35PM +0800, Phoenix Kiula wrote:
> 
> How should I check for the locale?

As the user that you issue the pg_dump with on the machine you
generated it, and as the user you're trying to use to restore the
data, at the command line type

 $ locale

You end up with something like this:

stovepipe:~ ajs$ locale
LANG="en_CA.UTF-8"
LC_COLLATE="en_CA.UTF-8"
LC_CTYPE="en_CA.UTF-8"
LC_MESSAGES="en_CA.UTF-8"
LC_MONETARY="en_CA.UTF-8"
LC_NUMERIC="en_CA.UTF-8"
LC_TIME="en_CA.UTF-8"
LC_ALL=

I can't remember whether the client encoding is going to be affected
by this during dump and restore, and whether in these versions that is
captured in the dump file.  

A

-- 
Andrew Sullivan
ajs(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

pgsql-admin by date

Next:From: Adrian KlaverDate: 2008-08-29 15:24:45
Subject: Re: Dumping/Restoring with constraints?
Previous:From: Phoenix KiulaDate: 2008-08-29 15:12:35
Subject: Re: Dumping/Restoring with constraints?

pgsql-general by date

Next:From: Raymond O'DonnellDate: 2008-08-29 15:18:55
Subject: Re: MySQL LAST_INSERT_ID() to Postgres
Previous:From: Phoenix KiulaDate: 2008-08-29 15:12:35
Subject: Re: Dumping/Restoring with constraints?

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