Migrate whole cluster to utf8

From: NTPT <NTPT(at)seznam(dot)cz>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Migrate whole cluster to utf8
Date: 2015-10-22 01:34:43
Message-ID: 7ha.DfPd.1CY3Sr8esTW.1MA3qp@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I have a db cluster (around 50GB of data ) in LATIN2  encoding. Now I need
to dump whole cluster because of upgrade to newer  version of pstgresql. But
I need to  have new cluster created with utf8 encoding  And databases in
that clusters tooo (with cs_CZ locale)

what is the best /safe practice ?

thanx for help

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dane Foster 2015-10-22 01:48:12 A question about PL/pgSQL DECLAREd variable behavior
Previous Message Adrian Klaver 2015-10-21 23:00:27 Re: temporary indexes?