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: <4127643C.8020106@x-ray.at> Date: Sat, 21 Aug 2004 17:03:24 +0200 From: Reini Urban User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8a2) Gecko/20040714 MIME-Version: 1.0 To: cygwin Subject: Re: initdb and postgres both no longer work... References: <1093099707 DOT 412760bb808f4 AT imp DOT webmail DOT hku DOT hk> In-Reply-To: <1093099707.412760bb808f4@imp.webmail.hku.hk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-IsSubscribed: yes tsfu AT graduate DOT hku DOT hk schrieb: > 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" I believe only the LATIN1 charset is supported on cygwin. $ initdb -D data2/db1 -E LATIN1 -- Reini Urban http://xarch.tu-graz.ac.at/home/rurban/ -- 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/