Problem in start up postgres in Cygwin

From: Xiaogang <xiaogangz(at)acm(dot)org>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Problem in start up postgres in Cygwin
Date: 2006-02-27 02:11:33
Message-ID: 44025FD5.3060600@acm.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Reini Urban 2006-02-27 07:18:11 Re: Problem in start up postgres in Cygwin
Previous Message John Xiaogang Zhang 2006-02-24 10:22:22 Problem in initdb