initdb failure

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

initdb failure

said samadli
hi,
i have just installed latest cygwin windows on 2000 and i have a problem with initdb,
it says
 
[hidden email] /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"
[hidden email] /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?
Reply | Threaded
Open this post in threaded view
|

Re: initdb failure

Reini Urban
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/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings