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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: initdb failure


  • From: Reini Urban <rurban(at)x-ray(dot)at>
  • To: said samadli <saidsamadli(at)yahoo(dot)com>
  • Cc: pgsql-cygwin(at)postgresql(dot)org
  • Subject: Re: initdb failure
  • Date: Sun, 28 Jan 2007 00:40:45 +0100
  • Message-id: <45BBE2FD.5050502@x-ray.at> <text/plain>

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/



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group