Re: initdb failure - Mailing list pgsql-cygwin

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@vozdux <mailto:postgres@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@vozdux <mailto:postgres@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/