Seeking Installation Instructions for Postgresql on Cygwin

[Public Mailing Lists]

Hi,

I'm trying to setup a Postgresql server on Windows-XP/Cygwin. I've done 
this a couple of times on Linux, and I'm experiencing some difficulties 
on Windows.

I have installed the packages postgresql (version 8.0.7-1) and 
cygrunserv (version 1.17-1), and I have syslog and init running.

If I'm trying to run /etc/rc.d/init.d/postgresql initdb, and I'm getting 
the following error messages:
The files belonging to this database system will be owned by user "SYSTEM".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /usr/share/postgresql/data ... ok
creating directory /usr/share/postgresql/data/global ... ok
creating directory /usr/share/postgresql/data/pg_xlog ... ok
creating directory /usr/share/postgresql/data/pg_xlog/archive_status ... ok
creating directory /usr/share/postgresql/data/pg_clog ... ok
creating directory /usr/share/postgresql/data/pg_subtrans ... ok
creating directory /usr/share/postgresql/data/base ... ok
creating directory /usr/share/postgresql/data/base/1 ... ok
creating directory /usr/share/postgresql/data/pg_tblspc ... ok
selecting default max_connections ... sh: line 1:   720 Bad system 
call         "/usr/sbin/postgres.exe" -boot -x0 -F -c shared_buffers=500 
-c max_connections=100 template1 < "/dev/null" > "/dev/null" 2>&1
sh: line 1:   528 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=250 -c max_connections=50 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:   232 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=200 -c max_connections=40 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  3216 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=150 -c max_connections=30 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  2864 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=100 -c max_connections=20 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  2652 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=50 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
10
selecting default shared_buffers ... sh: line 1:  3580 Bad system 
call         "/usr/sbin/postgres.exe" -boot -x0 -F -c 
shared_buffers=1000 -c max_connections=10 template1 < "/dev/null" > 
"/dev/null" 2>&1
sh: line 1:  2452 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=900 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:   920 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=800 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  3572 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=700 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  3528 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=600 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  4080 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=500 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  3204 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=400 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  3672 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=300 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  3928 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=200 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  1500 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=100 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
sh: line 1:  2116 Bad system call         "/usr/sbin/postgres.exe" -boot 
-x0 -F -c shared_buffers=50 -c max_connections=10 template1 < 
"/dev/null" > "/dev/null" 2>&1
50
creating configuration files ... ok
creating template1 database in /usr/share/postgresql/data/base/1 ... 
child process was terminated by signal 12
initdb: removing contents of data directory "/usr/share/postgresql/data"

What is wrong with it? Are there a simple, step-by-step instructions how 
to set up Postgresql out of the box on Cygwin?

Thanks for your help,
Gordon


--
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/