This is the mail archive of the cygwin mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

initdb and postgres both no longer work...


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

=======================================================================
postgres@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@Mars
$ ls
Backup	North Wind  data  data2  jakarta-tomcat-5.0.25	logfile

postgres@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@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@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/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]