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
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
X-IsSubscribed:	yes
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
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

- Raw text -