| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(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-22 22:35:13 |
| Message-ID: | df7b7a12-0eaf-ccad-ea95-bd79ff0faa34@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1/22/18 16:18, 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?
pg_lsclusters
pg_dropcluster VERSION NAME
pg_createcluster VERSION NAME --locale=xx_XX
where xx_XX is chosen by you. You previous cluster probably had a
locale of xx_XX.utf8, so it had the UTF8 encoding.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Krüger | 2018-01-22 22:47:15 | Re: Slow alter sequence with PG10.1 |
| Previous Message | Petr Jelinek | 2018-01-22 22:18:20 | Re: [PATCH] Logical decoding of TRUNCATE |