Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Problem in start up postgres in Cygwin



Hi All,

I have just installed the latest Cygwin, which has already included postgresql installed (version 8.0.4-1), but have problem to start the postgresql server: I got a "bad system call" on postgre.exe when initializing the database using initdb.

I have tried this on two WinXP boxes, one XP pro and one Home, the results is the same.

Can any one help? Thank you in advance.

Xiaogang


================
That's what I did:

xzhang(at)XGZNB ~
$ ps -ef
    UID     PID    PPID TTY     STIME COMMAND
 xzhang    1524       1 con  01:53:57 /usr/bin/bash
 xzhang    5872    1524 con  12:58:55 /usr/bin/ps

xzhang(at)XGZNB ~
$ cygserver  &
[1] 1416

xzhang(at)XGZNB ~
$ cygserver: Initialization complete.  Waiting for requests.
$ initdb -D /usr/lib/postgresql/data
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/lib/postgresql/data ... ok
creating directory /usr/lib/postgresql/data/global ... ok
creating directory /usr/lib/postgresql/data/pg_xlog ... ok
creating directory /usr/lib/postgresql/data/pg_xlog/archive_status ... ok
creating directory /usr/lib/postgresql/data/pg_clog ... ok
creating directory /usr/lib/postgresql/data/pg_subtrans ... ok
creating directory /usr/lib/postgresql/data/base ... ok
creating directory /usr/lib/postgresql/data/base/1 ... ok
creating directory /usr/lib/postgresql/data/pg_tblspc ... ok
selecting default max_connections ... sh: line 1:   404 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: 4560 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: 5372 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: 2120 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: 5144 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: 5576 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: 4672 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: 3916 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: 4636 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: 6072 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: 2584 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: 2028 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: 700 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: 2576 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: 3316 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: 5288 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: 2884 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/lib/postgresql/data/base/1 ... child process
was terminated by signal 12
initdb: removing data directory "/usr/lib/postgresql/data"

xzhang(at)XGZNB ~
$ ps -ef
    UID     PID    PPID TTY     STIME COMMAND
 xzhang    1524       1 con  01:53:57 /usr/bin/bash
 xzhang    1416    1524 con  12:59:01 /usr/sbin/cygserver
 xzhang    5240    1524 con  12:59:25 /usr/bin/ps



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group