| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2009-02-03 14:14:08 | Re: Dropping Old Databases |
| Previous Message | Rich Shepard | 2009-02-03 14:00:55 | Re: Next: Encoding Issue |