Subject: Re: Postgres and CYGWIN environment variable
From: "Gary ." <[email-masked]>
To: [email-masked]
Date: Fri, 9 Apr 2010 16:23:33 +0200
List-Id: <cygwin.cygwin.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