Re: INSTALLING POSTGRESQL 7.4.2

From: Andrew Hammond <ahammond(at)ca(dot)afilias(dot)info>
To: pgsql-novice(at)postgresql(dot)org
Cc: Philippe VERSCHOOTEN <ph(dot)verschooten(at)pi(dot)be>
Subject: Re: INSTALLING POSTGRESQL 7.4.2
Date: 2004-05-17 20:11:32
Message-ID: 40A91C74.3070807@ca.afilias.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Philippe Verschooten 2004-05-18 07:30:24 Installing Postgresql 7.4.2
Previous Message Philippe VERSCHOOTEN 2004-05-17 18:48:24 INSTALLING POSTGRESQL 7.4.2