Обсуждение: INSTALLING POSTGRESQL 7.4.2

Hello,
I have been installing version 7.4.2 of postgresql through different
channels on my PowerBook G4 (OS X 10.2.8). The installation was each
time succesfull, but I am having problems to starting postgres.
At my latest attempt (after installation via darwinports), when I
wanted to run the initdb-command I'v got the following message:

–––––––––––––––––––––––
[PowerBook06:/opt/local/bin] postgres% ./initdb -D
/usr/local/pgsql/data/
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.

creating directory /usr/local/pgsql/data/... ok
creating directory /usr/local/pgsql/data//base... ok
creating directory /usr/local/pgsql/data//global... ok
creating directory /usr/local/pgsql/data//pg_xlog... ok
creating directory /usr/local/pgsql/data//pg_clog... ok
selecting default max_connections... 50
selecting default shared_buffers... 300
creating configuration files... ok
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/"
–––––––––––––––––––––––

It looks like all the other messages I have got after previous
installations.

I have been trying also with postgresql 7.3.6.
At that time I succeeded the initdb-command, but once I started the
database I got no prompt ?!
  If anyone could help me …
Thanks
Philippe

-----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-----