Re: INSTALLING POSTGRESQL 7.4.2 - Mailing list pgsql-novice

From Andrew Hammond
Subject Re: INSTALLING POSTGRESQL 7.4.2
Date
Msg-id 40A91C74.3070807@ca.afilias.info
Whole thread Raw
In response to INSTALLING POSTGRESQL 7.4.2  (Philippe VERSCHOOTEN <ph.verschooten@pi.be>)
List pgsql-novice
-----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-----

pgsql-novice by date:

Previous
From: Philippe VERSCHOOTEN
Date:
Subject: INSTALLING POSTGRESQL 7.4.2
Next
From: "Philippe Verschooten"
Date:
Subject: Installing Postgresql 7.4.2