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