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

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: 2007-01-27 23:40:45
Message-ID: 45BBE2FD.5050502@x-ray.at (view raw or flat)
Thread:
Lists: 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(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/

In response to

pgsql-cygwin by date

Next:From: gth668qDate: 2007-03-05 23:31:38
Subject: Postgresql insstallation problem
Previous:From: said samadliDate: 2007-01-24 01:29:29
Subject: initdb failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group