pg.ddx.io  pgsql-cygwin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
problems creating database cluster with cigwyn
2+ messages / 2 participants
[nested] [flat]

* problems creating database cluster with cigwyn
@ 2007-03-23 21:11 Alessia Moretti <alemim@gmail.com>
  2007-03-28 17:56 ` Re: problems creating database cluster with cigwyn Reini Urban <rurban@x-ray.at>
  0 siblings, 1 reply; 2+ messages in thread

From: Alessia Moretti @ 2007-03-23 21:11 UTC (permalink / raw)
  To: pgsql-cygwin@postgresql.org.

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"

___________________________________________________________
>>

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: problems creating database cluster with cigwyn
  2007-03-23 21:11 problems creating database cluster with cigwyn Alessia Moretti <alemim@gmail.com>
@ 2007-03-28 17:56 ` Reini Urban <rurban@x-ray.at>
  0 siblings, 0 replies; 2+ messages in thread

From: Reini Urban @ 2007-03-28 17:56 UTC (permalink / raw)
  To: Alessia Moretti <alemim@gmail.com>; +Cc: pgsql-cygwin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-03-28 17:56 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-23 21:11 problems creating database cluster with cigwyn Alessia Moretti <alemim@gmail.com>
2007-03-28 17:56 ` Reini Urban <rurban@x-ray.at>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox