Postgres Pro
Downloads
Home   >   mailing lists

Migrate whole cluster to utf8 - Mailing list pgsql-general

From NTPT
Subject Migrate whole cluster to utf8
Date
Msg-id 7ha.DfPd.1CY3Sr8esTW.1MA3qp@seznam.cz
Whole thread Raw
Responses Re: Migrate whole cluster to utf8  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: temporary indexes?
Next
From: Dane Foster
Date:
Subject: A question about PL/pgSQL DECLAREd variable behavior