From graphcoloring@yahoo.com.cn Fri Jul 30 06:05:14 2004 X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 17C7CD1B211 for ; Fri, 30 Jul 2004 03:05:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44803-05 for ; Fri, 30 Jul 2004 06:04:49 +0000 (GMT) Received: from web15601.mail.cnb.yahoo.com (web15601.mail.cnb.yahoo.com [202.165.102.55]) by svr1.postgresql.org (Postfix) with SMTP id BEEEBD1B20D for ; Fri, 30 Jul 2004 03:04:45 -0300 (ADT) Message-ID: <20040730060444.30387.qmail@web15601.mail.cnb.yahoo.com> Received: from [61.141.168.174] by web15601.mail.cnb.yahoo.com via HTTP; Fri, 30 Jul 2004 14:04:44 CST Date: Fri, 30 Jul 2004 14:04:44 +0800 (CST) From: =?gb2312?q?Coloring=20Graph?= Subject: connect to 7.5 devel(win32) failed To: pgsql-hackers@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-290452039-1091167484=:25089" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_FONTCOLOR_BLUE, HTML_MESSAGE, RCVD_IN_RFCI, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/1358 X-Sequence-Number: 56919 --0-290452039-1091167484=:25089 Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: 8bit I am has some trouble when connect to 7.5 devel PostgreSQL server, see belows my setup: ======================= os=Windows2000 server version=the non-MSI snapshot at http://www.hagander.net/pgsql/win32snap/ has been "downgraded" to the latest known working snapshot path=c:\postgres\bin;c:\postgres\lib pgdata=c:\postgres\data TZ=CST note: ====================== I has NO modify the configure file generated by initdb, and has NO firewall installed in my server cmd to run postmaster(run as postgre user): ====================== postmaster -D "C:/postgres/data" result1: some lines of the log(postmaster) ======================= LOG: select() failed in statistics buffer: 在一个非套接字上尝试了一个操作 LOG: statistics collector process (PID 1876) was terminated by signal 1 result2: ======================= When I use pgAdmin III to connect the PostgreSQL server, a error is returned: could not receive server response to SSL negotiation packet: Connection reset by peer(0x00002746/10054) --------------------------------- Do You Yahoo!? 美女明星应有尽有,"一搜"搜遍美图、艳图和酷图 100兆邮箱够不够用?雅虎电邮自助扩容! --0-290452039-1091167484=:25089 Content-Type: text/html; charset=gb2312 Content-Transfer-Encoding: 8bit
I am has some trouble when connect to 7.5 devel PostgreSQL server,
see belows
 
my setup:
=======================
os=Windows2000
server version=the non-MSI snapshot at http://www.hagander.net/pgsql/win32snap/ has been "downgraded" to the latest known working snapshot
path=c:\postgres\bin;c:\postgres\lib
pgdata=c:\postgres\data
TZ=CST
 
note:
======================
I has NO modify the configure file generated by initdb,
and has NO firewall installed in my server
 
 
 
cmd to run postmaster(run as postgre user):
======================
postmaster -D "C:/postgres/data"
 

 
 
 
result1: some lines of the log(postmaster)
=======================
LOG: select() failed in statistics buffer: 在一个非套接字上尝试了一个操作
LOG: statistics collector process (PID 1876) was terminated by signal 1

result2:
=======================
When I use pgAdmin III to connect the PostgreSQL server,
a error is returned:
 
could not receive server response to SSL negotiation packet: Connection reset by peer(0x00002746/10054)
 



Do You Yahoo!?
美女明星应有尽有,"一搜"搜遍美图、艳图和酷图
100兆邮箱够不够用?雅虎电邮自助扩容! --0-290452039-1091167484=:25089-- From smarlowe@qwest.net Fri Jul 30 06:28:53 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 44F51D1B340 for ; Fri, 30 Jul 2004 03:28:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55185-03 for ; Fri, 30 Jul 2004 06:28:30 +0000 (GMT) Received: from mpls-qmqp-01.inet.qwest.net (mpls-qmqp-01.inet.qwest.net [63.231.195.112]) by svr1.postgresql.org (Postfix) with SMTP id 51B22D1B220 for ; Fri, 30 Jul 2004 03:28:27 -0300 (ADT) Received: (qmail 67606 invoked by uid 0); 30 Jul 2004 06:28:28 -0000 Received: from unknown (63.231.195.9) by mpls-qmqp-01.inet.qwest.net with QMQP; 30 Jul 2004 06:28:28 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-09.inet.qwest.net with SMTP; 30 Jul 2004 06:28:27 -0000 Date: Fri, 30 Jul 2004 00:29:40 -0600 Message-Id: <1091168980.27159.53.camel@localhost.localdomain> From: "Scott Marlowe" To: "Coloring Graph" Cc: pgsql-hackers@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [HACKERS] connect to 7.5 devel(win32) failed In-Reply-To: <20040730060444.30387.qmail@web15601.mail.cnb.yahoo.com> References: <20040730060444.30387.qmail@web15601.mail.cnb.yahoo.com> Content-Type: text/plain; charset=UTF-8 Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/321 X-Sequence-Number: 14389 Moving the -admin, please don't reply to -hackers on this. On Fri, 2004-07-30 at 00:04, Coloring Graph wrote: > I am has some trouble when connect to 7.5 devel PostgreSQL server, > see belows > > my setup: > ======================= > os=Windows2000 > server version=the non-MSI snapshot at > http://www.hagander.net/pgsql/win32snap/ has been "downgraded" to the > latest known working snapshot > path=c:\postgres\bin;c:\postgres\lib > pgdata=c:\postgres\data > TZ=CST > > > note: > ====================== > I has NO modify the configure file generated by initdb, > and has NO firewall installed in my server > > > > cmd to run postmaster(run as postgre user): > ====================== > postmaster -D "C:/postgres/data" > > > > > result1: some lines of the log(postmaster) > ======================= > LOG: select() failed in statistics buffer: 鍦ㄤ竴涓潪濂楁帴瀛椾笂灏濊瘯浜嗕竴涓搷浣� > LOG: statistics collector process (PID 1876) was terminated by signal > 1 > result2: > ======================= > When I use pgAdmin III to connect the PostgreSQL server, > a error is returned: Is pgadminIII using local domain sockets or TCP/IP sockets? Out of the box pgsql usually just answers local domain sockets, and I don't have a clue what windows supports in that way, etc... Since local domain sockets only work for processes on the same machine, this means that, after initial install, postgresql is not visible on anything other than the box it's installed on. You'll need to edit pg_hba.conf to give other machines permission to authenticate, as well as postgresql.conf to accept tcpip connections, then restart the server. Learning to admin on a pre-beta 1st port of windows could be a bit of work, so hang in there. These questions should probably go on -general or -admin first.