| From: | Tim Tassonis <timtas(at)cubic(dot)ch> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | initdb in 8.3 |
| Date: | 2008-04-23 09:46:35 |
| Message-ID: | 480F057B.6060801@cubic.ch |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
I just recently compiled and installed 8.3.1 on a System that has UTF-8
as the default characterset in the environment. Copied the binaries, run
initdb without parameters, the usual stuff.
As you probably are all aware of, this results now in a cluster that
will only allow you to create UTF-8 databases. I have read some posts
regarding this topic where it is explained that allowing LATIN1 on a
cluster initialized with UTF-8 will give you problems anyway etc and you
have to use locale=C to be able to create databases with different
charactersets.
My question is: Why then is --locale=C not the default for initdb, as I
do regard it as a rather big annoyance that a default installation on
probably almost any modern linux distribution results in a UTF-8 only
cluster, fixable only by dropping all databases, rerun initdb and the
reimporting them again.
Apart from that I'd of course like to restate that postgresql is a
wonderful software which I like very much.
Bye
Tim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Deolasee | 2008-04-23 09:48:41 | Re: Need to update all my 60 million rows at once without transactional integrity |
| Previous Message | Ivan Sergio Borgonovo | 2008-04-23 09:45:49 | Debian etch, backport postgresql 8.3 experiences? |