Re: cygwin postgres installation

[Reini Urban <rurban at x-ray dot at>]

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@cygwin.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/