X-Recipient: archive-cygwin AT delorie DOT com
X-SWARE-Spam-Status: No, hits=1.8 required=5.0 	tests=BAYES_50,SARE_MSGID_LONG45,TW_TD
X-Spam-Check-By: sourceware.org
MIME-Version: 1.0
In-Reply-To: <l2keb3a2d501004090706x6c25c3a9l77493ce878884737@mail.gmail.com>
References: <l2keb3a2d501004090706x6c25c3a9l77493ce878884737 AT mail DOT gmail DOT com>
Date: Fri, 9 Apr 2010 16:23:33 +0200
Received: by 10.140.247.19 with SMTP id u19mr157929rvh.226.1270823013226; Fri,  	09 Apr 2010 07:23:33 -0700 (PDT)
Message-ID: <p2teb3a2d501004090723ra9d5682bhcb00690c19fb6e4f@mail.gmail.com>
Subject: Re: Postgres and CYGWIN environment variable
From: "Gary ." <cygwin AT garydjones DOT name>
To: cygwin AT cygwin DOT com
Content-Type: text/plain; charset=ISO-8859-1
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Precedence: bulk
List-Id: <cygwin.cygwin.com>
List-Unsubscribe: <mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT com>
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

/usr/share/doc/Cygwin/postgresql-8.2.11.README also says
"cygrunsrv is not required anymore, pg_ctl has now the service functions
included.
cygserver must run as service"

Then at the end
"For the impatient: install as user (easy)
    cygrunsrv -S cygserver
    initdb -D /usr/share/postgresql/data
..."
So.. is that cygrunsrv required, or not?

I ask, because I can't do this
  $ /usr/sbin/initdb -D /usr/share/postgresql/data
because:
 The files belonging to this database system will be owned by user "jg".
 This user must also own the server process.

 The database cluster will be initialized with locales
   COLLATE:  de_CH.ISO-8859-1
   CTYPE:    de_CH.ISO-8859-1
   MESSAGES: en_US.ISO-8859-1
   MONETARY: de_CH.ISO-8859-1
   NUMERIC:  de_CH.ISO-8859-1
   TIME:     de_CH.ISO-8859-1
 The default database encoding has accordingly been set to LATIN1.

 creating directory /usr/share/postgresql/data ... ok
 creating subdirectories ... ok
 selecting default max_connections ... sh: line 1:  2204 Bad system
call         "/usr/sbin/postgres.exe" --boot -x0 -F -c
max_connections=100 -c shared_buffers=1000 -c max_fsm_pages=20000
template1 < "/dev/null" > "/dev/null" 2>&1
 sh: line 1:  3364 Bad system call         "/usr/sbin/postgres.exe"
--boot -x0 -F -c max_connections=50 -c shared_buffers=500 -c
max_fsm_pages=20000 template1 < "/dev/null" > "/dev/null" 2>&1

(doing that after the cygrunsrv works just fine.)

-- 
Gary
Non-kook (allegedly)

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