| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Martin Moore <martin(dot)moore(at)avbrief(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Changing locale/charset |
| Date: | 2018-01-23 14:03:37 |
| Message-ID: | cdb62e19-17e1-263a-1e0d-0486f7971130@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 01/22/2018 01:18 PM, Martin Moore wrote:
> I created a 10.1 cluster on Debian using UTF8.
> I’d like to convert it to LATIN1, but am having various issues. So, it’s probably easiest to start again (I have a dump of the DB).
>
> To ensure I get it right, what is the correct way to create a cluster with LATIN1 encoding, how to remove the existing cluster and how to ensure I have the right settings for LOCALE etc. in the OS?
Assuming you are using the Debian pg_ctlcluster command see 'Changing
Debian default installation' in below:
https://wiki.debian.org/PostgreSql
>
>
> Cheers.
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Nenciarini | 2018-01-23 14:38:45 | Re: [PATCH] Logical decoding of TRUNCATE |
| Previous Message | Olleg Samoylov | 2018-01-23 10:15:41 | Re: Using random() in update produces same random value for all |