Skip site navigation (1) Skip section navigation (2)

Re: Next: Encoding Issue

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: "pdxpug(at)postgresql(dot)org" <pdxpug(at)postgresql(dot)org>
Subject: Re: Next: Encoding Issue
Date: 2009-02-03 14:06:11
Message-ID: alpine.LNX.2.00.0902030604210.9977@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pdxpug
On Mon, 2 Feb 2009, Devin Ben-Hur wrote:

> You will likely want to reinitialize your database cluster with `initdb
> --locale=C --encoding=UTF-8 -D /where/ever/your/database/is`.  Once the
> locale for a cluster is set, it can not be changed (though alternate 
> compatible encodings can be specified per database) and it looks like the 
> Rich's was init'd with locale=en_US.LATIN1 which will not accommodate a UTF8 
> encoding.

Devin,

   Since /var/lib/pgsql/data exists as a cluster, what happens to all
existing data if I remove or empty it so it can be recreated?

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

In response to

pdxpug by date

Next:From: Rich ShepardDate: 2009-02-03 14:14:08
Subject: Re: Dropping Old Databases
Previous:From: Rich ShepardDate: 2009-02-03 14:00:55
Subject: Re: Next: Encoding Issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group