Mailing-List: contact cygwin-help AT sourceware DOT cygnus DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT sources DOT redhat DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT sources DOT redhat DOT com>
List-Help: <mailto:cygwin-help AT sources DOT redhat DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT sources DOT redhat DOT com
Delivered-To: mailing list cygwin AT sources DOT redhat DOT com
From: Markus Hoenicka <Markus DOT Hoenicka AT uth DOT tmc DOT edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <15208.8759.467000.79427@gargle.gargle.HOWL>
Date: Wed, 1 Aug 2001 15:37:27 +0000
To: cygwin AT cygwin DOT com
Subject: postgres connection problem
X-Mailer: VM 6.94 under Emacs 20.6.1

On the road to perfection I stumbled over one (the last, hopefully)
roadblock: It appears that I cannot use a socket-based connection from
any user account but the one that postgres runs under.

I created an account "postgres" to run the cygipc and postgres
services. "markus" is my regular user account. I created the postgres
user "markus". The following happens:

[log in as postgres]

postgres AT WUTZ ~
$ psql -U markus template1
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=# \q

[log out, log in as markus]

markus AT WUTZ ~
$ psql template1
psql: connectDBStart() -- connect() failed: Connection refused
        Is the postmaster running locally
        and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?

markus AT WUTZ ~
$ psql -h 127.0.0.1 template1
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=# \q

So from the "postgres" account I can connect as user "markus" just
fine. From my "markus" account this results in a refused connection
unless I use a TCP/IP based connection by providing a
hostname/IP-address.

Is this the expected behaviour?

regards,
Markus

-- 
Markus Hoenicka, PhD
UT Houston Medical School
Dept. of Integrative Biology and Pharmacology
6431 Fannin MSB4.114
Houston, TX 77030
(713) 500-6313, -7477
(713) 500-7444 (fax)
Markus DOT Hoenicka AT uth DOT tmc DOT edu
http://ourworld.compuserve.com/homepages/hoenicka_markus/


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/