Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E70079FB2C2 for ; Sat, 27 Jan 2007 19:40:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 53890-07 for ; Sat, 27 Jan 2007 19:40:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B3F5F9FB27A for ; Sat, 27 Jan 2007 19:40:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mx.inode.at (mx11.lb01.inode.at [62.99.145.13]) by svr4.postgresql.org (Postfix) with ESMTP id A3ABF5AFAC5 for ; Sat, 27 Jan 2007 23:40:41 +0000 (GMT) Received: from [62.99.252.218] (port=11077 helo=[192.168.1.7]) by smartmx-11.inode.at with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA:32) (Exim 4.50) id 1HAx9y-0004eU-Nu; Sun, 28 Jan 2007 00:40:39 +0100 Message-ID: <45BBE2FD.5050502@x-ray.at> Date: Sun, 28 Jan 2007 00:40:45 +0100 From: Reini Urban User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-AT; rv:1.8.1) Gecko/20061101 SeaMonkey/1.1b MIME-Version: 1.0 To: said samadli Cc: pgsql-cygwin@postgresql.org Subject: Re: initdb failure References: <575427.94923.qm@web39711.mail.mud.yahoo.com> In-Reply-To: <575427.94923.qm@web39711.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200701/5 X-Sequence-Number: 4363 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@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@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/