Re: Changing locale/charset

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
dumpof the DB). 
 
> 
> To ensure I get it right, what is the correct way to create a cluster with LATIN1 encoding, how to remove the
existingcluster 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