Nambi Sankaran schrieb:
Hi Reini
using the release notes I am trying to start postgresql server in my
cygwin area.
(
http://xarch.tu-graz.ac.at/home/rurban/software/cygwin/release/postgresql/README
)
but the initdb process fails due to some errors. please see the log below.
please advice.
The first advice is to use the recommended support email address which
is [EMAIL PROTECTED]
cygserver and therefore ipc is working okay. just the console output is
annoying, better is to log to a file or the eventlog.
your template db could not be created, probably due to file permission
problems at base/1
did you try to install this as service, initdb it as service and then
initdb it as user? This will not work.
You'd need to check your perms for the database user to read/write to
$PGDATA
/etc/rc.d/init.d/postgresql install
pg_ctl start -l /var/log/posgresql.log
or
/etc/rc.d/init.d/postgresql initdb
is usually better than simple
/usr/sbin/initdb -D /usr/share/postgresql/data
The second advice is to look at your postmaster log and
post your problem as described in http://cygwin.com/problems.html
snambi:/etc/rc.d/init.d>
$echo $CYGWIN
CYGWIN_NT-5.1_server
snambi:/etc/rc.d/init.d>
$cygserver &
[2] 2032
snambi:/etc/rc.d/init.d>
$cygserver: Initialization complete. Waiting for requests.
snambi:/etc/rc.d/init.d>
$/usr/sbin/initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user
"namsanka".
This user must also own the server process.
The database cluster will be initialized with locale C.
creating directory /usr/share/postgresql/data ... ok
creating directory /usr/share/postgresql/data/global ... ok
creating directory /usr/share/postgresql/data/pg_xlog ... ok
creating directory /usr/share/postgresql/data/pg_xlog/archive_status ... ok
creating directory /usr/share/postgresql/data/pg_clog ... ok
creating directory /usr/share/postgresql/data/pg_subtrans ... ok
creating directory /usr/share/postgresql/data/base ... ok
creating directory /usr/share/postgresql/data/base/1 ... ok
creating directory /usr/share/postgresql/data/pg_tblspc ... ok
selecting default max_connections ... sh: line 1: 4016 Bad system
call "/usr/sbin/postgres.exe" -boot -x0 -F -c shared_buffers=500
-c max_connections=100 template1 <"/dev/null" >"/dev/null" 2>&1
sh: line 1: 2888 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: 2976 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: 2296 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: 3800 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: 2172 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: 3984 Bad system
call "/usr/sbin/postgres.exe" -boot -x0 -F -c
shared_buffers=1000 -c max_connections=10 template1 <"/dev/null"
>"/dev/null" 2>&1
sh: line 1: 2004 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: 2572 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: 2568 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: 2656 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: 3724 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: 2040 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: 4068 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: 4028 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: 3828 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: 3464 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/share/postgresql/data/base/1 ...
child process was terminated by signal 12
initdb: removing data directory "/usr/share/postgresql/data"
snambi:/etc/rc.d/init.d>
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
http://phpwiki.org/
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Problem reports: http://cygwin.com/problems.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
