Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > initdb in 8.3
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 14 Topic 15364 of 17602
Post > Topic >>

initdb in 8.3

by timtas@[EMAIL PROTECTED] (Tim Tassonis) Apr 23, 2008 at 11:46 AM

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 
reim****ting 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



-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 14 Posts in Topic:
initdb in 8.3
timtas@[EMAIL PROTECTED]   2008-04-23 11:46:35 
Re: initdb in 8.3
dev@[EMAIL PROTECTED] (R  2008-04-23 11:42:10 
Re: initdb in 8.3
Zdenek.Kotala@[EMAIL PROT  2008-04-25 12:41:42 
Re: initdb in 8.3
peter_e@[EMAIL PROTECTED]  2008-04-23 13:15:08 
Re: initdb in 8.3
timtas@[EMAIL PROTECTED]   2008-04-23 16:35:04 
Re: initdb in 8.3
kleptog@[EMAIL PROTECTED]  2008-04-23 18:00:20 
Re: initdb in 8.3
timtas@[EMAIL PROTECTED]   2008-04-23 18:22:10 
Re: initdb in 8.3
condit@[EMAIL PROTECTED]   2008-04-23 10:57:55 
Re: initdb in 8.3
craig@[EMAIL PROTECTED]   2008-04-24 13:19:38 
Re: initdb in 8.3
condit@[EMAIL PROTECTED]   2008-04-24 06:51:30 
Re: initdb in 8.3
tgl@[EMAIL PROTECTED] (T  2008-04-24 10:02:16 
Re: initdb in 8.3
peter_e@[EMAIL PROTECTED]  2008-04-23 18:03:24 
Re: initdb in 8.3
Karsten.Hilbert@[EMAIL PR  2008-04-23 20:12:11 
Re: initdb in 8.3
timtas@[EMAIL PROTECTED]   2008-04-24 00:59:57 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:54:20 CST 2008.