Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5D3439FB898 for ; Fri, 18 May 2007 07:36:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 25238-04 for ; Fri, 18 May 2007 07:36:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.183]) by postgresql.org (Postfix) with ESMTP id 6E52E9FB7C2 for ; Fri, 18 May 2007 07:36:38 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d32so609013pye for ; Fri, 18 May 2007 03:36:36 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=A50WJbceNw1cNFSuKkcRvdezZwODIGXGhOE/jJ8HUwEvwnu4liS9htBtSi62CEfVmau2U0bO+4fkS6gqw75QZh4zIs71ozEx5RzDjpG6/r3zwBQSyo2dK/gP/pGrAqdvoiKltP7GoTtDWGrzx2+AaNxJ7QUB2Bv7btptqlcu/Qs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=otlPLVOqVrR93ad7Pr5dDcgpMS1bwcaXUD2ehxXX1bsKoqQiS8xZh0UBwGZn0jwyxTzqyoA5JsJRHsMBa20FBR2DsItK7+oA2ePG0cqS8SloWotx79XYG3sghCDBrPl/D69+CJCnLcCArroWRShLgT4VXo/0kFUTE/z1p1AVXEE= Received: by 10.35.19.6 with SMTP id w6mr2545251pyi.1179484596816; Fri, 18 May 2007 03:36:36 -0700 (PDT) Received: by 10.35.123.18 with HTTP; Fri, 18 May 2007 03:36:36 -0700 (PDT) Message-ID: Date: Fri, 18 May 2007 13:36:36 +0300 From: "telman shahbazov" To: pgsql-cygwin@postgresql.org Subject: Installation problem / cygwin/postgresql/windows MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_26001_28574263.1179484596759" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/1 X-Sequence-Number: 4375 ------=_Part_26001_28574263.1179484596759 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, I am new in cygwin and postgresql. Could you please advice how to solve the following problem? I follow the instructions presented in * http://www.postgresql.org/docs/faqs.FAQ_CYGWIN.html* During the installation I have a problem with initdb -D -W -E LATIN1 The /usr/local/pgsql/data is created but by the end of process it is removed SERVER SIDE: Your group name is currently "mkgroup_l_d". This indicates that not all domain users and groups are listed in the /etc/passwd and /etc/group files. See the man pages for mkpasswd and mkgroup then, for example, run mkpasswd -l -d > /etc/passwd mkgroup -l -d > /etc/group This message is only displayed once (unless you recreate /etc/group) and can be safely ignored. tsahbaz@T-SAHBAZOGLU ~ *$ /usr/sbin/cygserver & *[1] 2956 tsahbaz@T-SAHBAZOGLU ~ $ cygserver: Initialization complete. Waiting for requests. Another window on the same comp: tsahbaz@T-SAHBAZOGLU ~ *$ /usr/sbin/initdb -D /usr/local/pgsql/data -W -E LATIN1* The files belonging to this database system will be owned by user "tsahbaz". This user must also own the server process. The database cluster will be initialized with locale C. creating directory /usr/local/pgsql/data ... ok creating directory /usr/local/pgsql/data/global ... ok creating directory /usr/local/pgsql/data/pg_xlog ... ok creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok creating directory /usr/local/pgsql/data/pg_clog ... ok creating directory /usr/local/pgsql/data/pg_subtrans ... ok creating directory /usr/local/pgsql/data/base ... ok creating directory /usr/local/pgsql/data/base/1 ... ok creating directory /usr/local/pgsql/data/pg_tblspc ... ok selecting default max_connections ... sh: line 1: 260 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: 2696 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: 3804 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: 3856 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: 2588 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: 2668 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: 2532 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: 2228 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: 2192 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: 1760 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: 3160 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: 3828 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: 836 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: 2488 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: 2396 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: 3488 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: 1880 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/local/pgsql/data/base/1 ... child process wa s terminated by signal 12 *initdb: removing data directory "/usr/local/pgsql/data"* tsahbaz@T-SAHBAZOGLU ~ $ Regards, Telman Shahbazov ------=_Part_26001_28574263.1179484596759 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

Hi,

I am new in cygwin and postgresql.
Could you please advice how to solve the following problem?

I follow the instructions presented in

http://www.postgresql.org/docs/faqs.FAQ_CYGWIN.html

During the installation I have a problem with

initdb -D -W -E LATIN1
The
/usr/local/pgsql/data is created but by the end of process it is removed
 
SERVER SIDE:

Your group name is currently "mkgroup_l_d". This indicates that not
all domain users and groups are listed in the /etc/passwd and
/etc/group files.
See the man pages for mkpasswd and mkgroup then, for example, run
mkpasswd -l -d > /etc/passwd
mkgroup  -l -d > /etc/group

This message is only displayed once (unless you recreate /etc/group)
and can be safely ignored.

tsahbaz@T-SAHBAZOGLU ~
$ /usr/sbin/cygserver &
[1] 2956

tsahbaz@T-SAHBAZOGLU ~
$ cygserver: Initialization complete.  Waiting for requests.

 

 

 

Another window on the same comp:

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

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... sh: line 1:   260 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:  2696 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:  3804 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:  3856 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:  2588 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:  2668 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:  2532 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:  2228 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:  2192 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:  1760 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:  3160 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:  3828 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:   836 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:  2488 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:  2396 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:  3488 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:  1880 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/local/pgsql/data/base/1 ... child process wa
s terminated by signal 12
initdb: removing data directory "/usr/local/pgsql/data"

tsahbaz@T-SAHBAZOGLU ~
$

Regards,

Telman Shahbazov

 

------=_Part_26001_28574263.1179484596759--