Problem in initdb

John Xiaogang Zhang <[email protected]> Fri, 24 Feb 2006 21:22:22 +1100
Newsgroups gmane.comp.db.postgresql.cygwin
Organization Tilefile
Message-ID <[email protected]>
Dear Sir/Madam,

I have just installed Cydwin with Postgresql (8.0.4), and followed the 
page http://www.postgresql.org/docs/faqs.FAQ_CYGWIN.html to create new 
database cluster using initdb, but got the following messages, so what 
should I do?  Thanks in advance.

Best regards

Xiaogang Zhang



$ /usr/sbin/cygserver &

$ cygserver: Initialization complete.  Waiting for requests.

$ /usr/sbin/initdb -D /usr/local/pgsql/data -W -E LATIN1
The files belonging to this database system will be owned by user "xzhang".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... sh: line 1:  4788 Bad system call
"/usr/sbin/postgres.exe" -boot -x0 -F -c shared_buffers=500 -c 
max_connections=1
00 template1 <"/dev/null" >"/dev/null" 2>&1
sh: line 1:  4880 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:  5276 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:  4556 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:  5348 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:  4848 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:  4120 Bad system 
call         "
/usr/sbin/postgres.exe" -boot -x0 -F -c shared_buffers=1000 -c 
max_connections=1
0 template1 <"/dev/null" >"/dev/null" 2>&1
sh: line 1:  1892 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:  5608 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:  5048 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:  5192 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:  4512 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:  5220 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:  4540 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:  6024 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:  6096 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:  4784 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/local/pgsql/data/base/1 ... child 
process wa
s terminated by signal 12
initdb: removing data directory "/usr/local/pgsql/data"

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend