X-Spam-Check-By: sourceware.org
Message-ID: <438E1645.6000706@x-ray.at>
Date: Wed, 30 Nov 2005 22:14:45 +0100
From: Reini Urban <rurban AT x-ray DOT at>
Reply-To: cygwin AT cygwin DOT com
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8b) Gecko/20050217
MIME-Version: 1.0
To: Nambi Sankaran <snambi AT gmail DOT com>
CC: cygwin AT cygwin DOT com
Subject: Re: cygwin postgres installation
References: <d0a6cabf0511301008y6be69296y4242b45352ed989d AT mail DOT gmail DOT com>
In-Reply-To: <d0a6cabf0511301008y6be69296y4242b45352ed989d@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

Nambi Sankaran schrieb:
> Hi Reini
> 
> using the release notes I am trying to start postgresql server in my 
> cygwin area.
> ( 
> http://xarch.tu-graz.ac.at/home/rurban/software/cygwin/release/postgresql/README 
> )
> 
> but the initdb process fails due to some errors. please see the log below.
> please advice.

The first advice is to use the recommended support email address which 
is cygwin AT cygwin DOT com.

cygserver and therefore ipc is working okay. just the console output is 
annoying, better is to log to a file or the eventlog.

your template db could not be created, probably due to file permission 
problems at base/1
did you try to install this as service, initdb it as service and then 
initdb it as user? This will not work.
You'd need to check your perms for the database user to read/write to 
$PGDATA

   /etc/rc.d/init.d/postgresql install
   pg_ctl start -l /var/log/posgresql.log
or
   /etc/rc.d/init.d/postgresql initdb

is usually better than simple

   /usr/sbin/initdb  -D /usr/share/postgresql/data

The second advice is to look at your postmaster log and
post your problem as described in http://cygwin.com/problems.html

> snambi:/etc/rc.d/init.d>
> $echo $CYGWIN
> CYGWIN_NT-5.1_server
> snambi:/etc/rc.d/init.d>
> $cygserver &
> [2] 2032
> snambi:/etc/rc.d/init.d>
> $cygserver: Initialization complete.  Waiting for requests.
> 
> snambi:/etc/rc.d/init.d>
> $/usr/sbin/initdb  -D /usr/share/postgresql/data
> The files belonging to this database system will be owned by user 
> "namsanka".
> This user must also own the server process.
> 
> The database cluster will be initialized with locale C.
> 
> creating 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/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:  4016 Bad system 
> call         "/usr/sbin/postgres.exe" -boot -x0 -F -c shared_buffers=500 
> -c max_connections=100 template1 <"/dev/null" >"/dev/null" 2>&1
> sh: line 1:  2888 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:  2976 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:  2296 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:  3800 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:  2172 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:  3984 Bad system 
> call         "/usr/sbin/postgres.exe" -boot -x0 -F -c 
> shared_buffers=1000 -c max_connections=10 template1 <"/dev/null" 
>  >"/dev/null" 2>&1
> sh: line 1:  2004 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:  2572 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:  2568 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:  2656 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:  3724 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:  2040 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:  4068 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:  4028 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:  3828 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:  3464 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 process was terminated by signal 12
> initdb: removing data directory "/usr/share/postgresql/data"
> snambi:/etc/rc.d/init.d>

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
http://phpwiki.org/

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/