This is the mail archive of the cygwin mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Seeking Installation Instructions for Postgresql on Cygwin


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/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]