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

Re: Dumping/Restoring with constraints?

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Adrian Klaver" <aklaver(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, "Andrew Sullivan" <ajs(at)commandprompt(dot)com>
Subject: Re: Dumping/Restoring with constraints?
Date: 2008-08-29 16:07:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-general
On 8/30/08, Adrian Klaver <aklaver(at)comcast(dot)net> wrote:
> 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>

Thanks. I did this and LC_COLLATE etc have the values "C". How can I
change this to UTF8?

In response to

pgsql-admin by date

Next:From: Marco ColomboDate: 2008-08-29 19:06:33
Subject: Re: Dumping/Restoring with constraints?
Previous:From: Scott MarloweDate: 2008-08-29 16:06:38
Subject: Re: compat-postgresql-libs not in the repo?

pgsql-general by date

Next:From: Joao Ferreira gmailDate: 2008-08-29 16:45:43
Subject: autovacuum settings
Previous:From: Adrian KlaverDate: 2008-08-29 16:05:01
Subject: Re: Dumping/Restoring with constraints?

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