Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing locale/charset - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Changing locale/charset
Date
Msg-id cdb62e19-17e1-263a-1e0d-0486f7971130@aklaver.com
Whole thread Raw
In response to Changing locale/charset  (Martin Moore <martin.moore@avbrief.com>)
List pgsql-general
Tree view 
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
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?
 

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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Olleg Samoylov
Date:
Subject: Re: Using random() in update produces same random value for all
Next
From: Martin Goodson
Date:
Subject: Re: FW: Setting up streaming replication problems