Re: INSTALLING POSTGRESQL 7.4.2

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Philippe VERSCHOOTEN wrote:

| creating template1 database in /usr/local/pgsql/data//base/1... FATAL:
| invalid value for parameter "lc_time": "en_US"
|
| initdb: failed
| initdb: removing data directory "/usr/local/pgsql/data/"

Try setting your locale explicitly:

initdb --locale=C -D /usr/local/pgsql/data

However, if you will be using this database over time, I would strongly
suggest that you put the major version number as part of the cluster's
name. It can make upgrading over major versions a little easier. You'd
also be well advised to keep the binary install clear of the cluster.

IE:

initdb --locale=C -D /usr/local/pgdata/pgsql74

Drew
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFAqRxygfzn5SevSpoRAgJ1AKCBGipPfkgsyrFGqFZ/qQ2AEsbdrACg0Q+V
lUs27U48gC/4C6eRiA8cssQ=
=zmzP
-----END PGP SIGNATURE-----