Problem in start up postgres in Cygwin

Поиск
Список
Период
Сортировка
От Xiaogang
Тема Problem in start up postgres in Cygwin
Дата
Msg-id 44025FD5.3060600@acm.org
обсуждение исходный текст
Ответы Re: Problem in start up postgres in Cygwin  (Reini Urban <rurban@x-ray.at>)
Список 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@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@XGZNB ~
$ cygserver  &
[1] 1416

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

В списке pgsql-cygwin по дате отправления:

Предыдущее
От: "Eric Chapdelaine"
Дата:
Сообщение: Unhandled Exception - Executing Samples
Следующее
От: Reini Urban
Дата:
Сообщение: Re: Problem in start up postgres in Cygwin