Re: initdb failure

said samadli schrieb:
> hi,
> i have just installed latest cygwin windows on 2000 and i have a problem
> with initdb,

That looks like an old cygwin portgresql 7.4
You need to start cygserver before. Best is to read the cygwin README
before and try out /etc/rc.d/init.d/postgresql in postgresql > 8.0

> it says
>
> postgres(at)vozdux <mailto:postgres(at)vozdux> /usr/share/postgresql
> $ initdb -D /usr/share/postgresql/data
> The files belonging to this database system will be owned by user
> "postgres".
> This user must also own the server process.
> The database cluster will be initialized with locale C.
> fixing permissions on existing 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/pg_twophase ... ok
> creating directory /usr/share/postgresql/data/pg_multixact/members ... ok
> creating directory /usr/share/postgresql/data/pg_multixact/offsets ... 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: 9184 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: 9180 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: 9200 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: 9192 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: 9252 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: 9224 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: 9236 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: 9216 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: 9244 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: 9312 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: 9284 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: 9296 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: 9276 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: 9368 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: 9272 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: 8676 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: 9364 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 proce
> ss was terminated by signal 12
> initdb: removing contents of data directory "/usr/share/postgresql/data"
> postgres(at)vozdux <mailto:postgres(at)vozdux> /usr/share/postgresql
> $
>
> this error s what could be the problem i have changed max_connection
> betwwen 100 and 5 it didn't work? thank you for the hep from now?

--
Reini Urban
http://phpwiki.org/ http://murbreak.at/
http://helsinki.at/ http://spacemovie.mur.at/