| 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: | e373d31e0808290907w757193a2r119492f07c6c7075@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Colombo | 2008-08-29 19:06:33 | Re: Dumping/Restoring with constraints? |
| Previous Message | Scott Marlowe | 2008-08-29 16:06:38 | Re: compat-postgresql-libs not in the repo? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joao Ferreira gmail | 2008-08-29 16:45:43 | autovacuum settings |
| Previous Message | Adrian Klaver | 2008-08-29 16:05:01 | Re: Dumping/Restoring with constraints? |