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

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 (view raw or flat)
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

pgsql-cygwin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group