Postgres Pro
Downloads
Home   >   mailing lists

Thread: problems creating database cluster with cigwyn

problems creating database cluster with cigwyn

From
"Alessia Moretti"
Date:
Dear PostgreSQL Cigwyn staff,
I can't create the cluster of the database
I' ve followed the instructions found in your web site
(http://www.postgresql.org/docs/faqs.FAQ_CYGWIN.html )

This is the output of the Cigwyn when I attempt to create the cluster
Every help will be highly appreciated
My system runs WindowXP on fat32 partitions
Best regards
Alessia

follows the output of the Cigwyn shell comand "$ /usr/sbin/initdb -D /usr/local/pgsql/data -W -E LATIN1"

>>
Alessia@nome-ae81ed18aa /usr/local/pgsql/data
$ /usr/sbin/initdb -D /usr/local/pgsql/data -W -E LATIN1
The files belonging to this database system will be owned by user "Alessia".
This user must also own the server process.

The database cluster will be initialized with locale C.

modifica dei permessi sulla directory esistente /usr/local/pgsql/data ... ok
creazione directory /usr/local/pgsql/data/global ... ok
creazione directory /usr/local/pgsql/data/pg_xlog ... ok
creazione directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creazione directory /usr/local/pgsql/data/pg_clog ... ok
creazione directory /usr/local/pgsql/data/pg_subtrans ... ok
creazione directory /usr/local/pgsql/data/base ... ok
creazione directory /usr/local/pgsql/data/base/1 ... ok
creazione directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... sh: line 1:  3576 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:  3796 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:  2580 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:  3092 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:  1028 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:  1616 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:  1416 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:  2492 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:   612 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:  1756 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:  3656 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:  2156 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:  2084 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:  1572 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:  2352 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:  3664 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:   424 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
creazione dei file di configurazione ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... child process wa
s terminated by signal 12
initdb: rimozione dei contenuti della data directory "/usr/local/pgsql/data"

___________________________________________________________
>>


Re: problems creating database cluster with cigwyn

From
Reini Urban
Date:
Alessia Moretti schrieb:
> Dear PostgreSQL Cigwyn staff,
> I can't create the cluster of the database
> I' ve followed the instructions found in your web site
> (http://www.postgresql.org/docs/faqs.FAQ_CYGWIN.html

You didn't follow the instructions completely.
You have to setup and runs cygserver before.

> creazione directory /usr/local/pgsql/data/pg_tblspc ... ok
> selecting default max_connections ... sh: line 1:  3576 Bad system call
> "/usr/sbin/postgres.exe" -boot -x0 -F -c shared_buffers=500 -c
> max_connections=1

Besides that we don't know which 7.x version you are trying.
Older versions required ipc-server

Why don't you just use the cygwin version from
http://cygwin.com/setup.exe and follow
/usr/share/doc/Cygwin/postgresql-8.0.7.README