Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , 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 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit 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/