Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Message-ID:	<1093099707.412760bb808f4@imp.webmail.hku.hk>
Date:	Sat, 21 Aug 2004 22:48:27 +0800
From:	tsfu AT graduate DOT hku DOT hk
To:	cygwin AT cygwin DOT com
Subject:	initdb and postgres both no longer work...
MIME-Version:	1.0
User-Agent:	Internet Messaging Program (IMP) 3.2.2
X-Originating-IP:	218.190.210.32
X-HKU-MailScanner:	0

I had no problem in using PostgreSQL before and both initdb and postgres do not
work anymore as shown below:

=======================================================================
postgres AT Mars
$ initdb -D data2/db1
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.

fixing permissions on existing directory data2/db1... ok
creating directory data2/db1/base... ok
creating directory data2/db1/global... ok
creating directory data2/db1/pg_xlog... ok
creating directory data2/db1/pg_clog... ok
selecting default max_connections... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
10
selecting default shared_buffers... Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
Signal 12
50
creating configuration files... ok
creating template1 database in data2/db1/base/1... FATAL:  invalid value for
parameter "lc_messages": "en_US"

initdb: failed

postgres AT Mars
$ ls
Backup	North Wind  data  data2  jakarta-tomcat-5.0.25	logfile

postgres AT Mars
$ ls -la data2/
total 0
drwxr-xr-x+   3 postgres None            0 Aug 21 22:26 .
drwxrwxrwx+   8 postgres None            0 Aug 21 22:23 ..
drwx------+   6 postgres None            0 Aug 21 22:28 db1

postgres AT Mars
$ ls -la data2/db1/
total 16
drwx------+   6 postgres None            0 Aug 21 22:28 .
drwxr-xr-x+   3 postgres None            0 Aug 21 22:26 ..
-rw-------    1 postgres None            4 Aug 21 22:28 PG_VERSION
drwx------+   3 postgres None            0 Aug 21 22:28 base
drwx------+   2 postgres None            0 Aug 21 22:28 global
drwx------+   2 postgres None            0 Aug 21 22:28 pg_clog
-rw-------    1 postgres None         3289 Aug 21 22:28 pg_hba.conf
-rw-------    1 postgres None         1441 Aug 21 22:28 pg_ident.conf
drwx------+   2 postgres None            0 Aug 21 22:28 pg_xlog
-rw-------    1 postgres None         7794 Aug 21 22:28 postgresql.conf
-rw-------    1 postgres None           31 Aug 21 22:28 postmaster.pid

postgres AT Mars
$ postmaster -i -D data
FATAL:  postmaster: could not locate postgres executable

=======================================================================

Please help...


Thanks.

Regards,

Jason Fu


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -