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 9046B52831 for ; Sat, 25 Jun 2005 14:58:57 -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 55880-01 for ; Sat, 25 Jun 2005 17:58:53 +0000 (GMT) Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by svr1.postgresql.org (Postfix) with ESMTP id E878E52862 for ; Sat, 25 Jun 2005 14:58:50 -0300 (ADT) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0IIN00001JA286@asu.edu> for pgsql-admin@postgresql.org; Sat, 25 Jun 2005 10:58:50 -0700 (MST) Received: from smtp.asu.edu (smtp.asu.edu [129.219.110.107]) by asu.edu (PMDF V6.1-1X6 #30769) with ESMTP id <0IIN00IF2JA26P@asu.edu> for pgsql-admin@postgresql.org; Sat, 25 Jun 2005 10:58:50 -0700 (MST) Received: from teancum.pp.asu.edu (teancum.pp.asu.edu [129.219.69.212]) by smtp.asu.edu (8.12.10/8.12.10/asu_smtp_relay, nullclient, tcp_wrapped) with ESMTP id j5PHwmj5022142 for ; Sat, 25 Jun 2005 10:58:48 -0700 (MST) Received: by teancum.pp.asu.edu (Postfix, from userid 1000) id 07723A21; Sat, 25 Jun 2005 10:58:49 -0700 (MST) Date: Sat, 25 Jun 2005 10:58:49 -0700 From: David Bear Subject: listening on tcp socket instead of unix domain To: pgsql-admin@postgresql.org Reply-To: David.Bear@asu.edu Message-id: <20050625175849.GA18646@asu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200506/214 X-Sequence-Number: 17969 Hoping to get postgresql to listen on a tcp socket I made the following change to postgresql.conf: #listen_addresses = 'localhost' # what IP interface(s) to listen on; listen_addresses = 'localhost' # what IP interface(s) to listen on; # defaults to localhost, '*' = any #port = 5432 port = 5432 I understand this to mean, listen on localhost, ie 127.0.0.1. However, a netstat -l tells me: netstat -l | grep 5432 unix 2 [ ACC ] STREAM LISTENING 732094 /tmp/.s.PGSQL.5432 netstat -l | grep postg tcp 0 0 localhost:postgresql *:* LISTEN tcp 0 0 localhost:postgresql *:* LISTEN This doesn't look right. Moreover, when attempting to create an ssh tunnel to connect to postgres from a windows box, the connection fails. Is postgres really listening on a socket that is 'connect-able' through ssh tunneling? If so, then would using ssh command ssh -L 5432:remotehost:5432 user@remotehost be sufficient to connect to the postgres running on remote host? This fails when running psql on the machine with message: > psql -p 5432 psql: could not connect to server: No such file or directory ... So, I don't think something is quite working. Please advise. -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"