Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 9.1 not connecting - Mailing list pgsql-novice

From Gerald Cheves
Subject Re: PostgreSQL 9.1 not connecting
Date
Msg-id 5357AA20.9040106@verizon.net
Whole thread Raw
In response to PostgreSQL 9.1 not connecting  (Michael Rowan <michael.rowan3@gmail.com>)
List pgsql-novice
Tree view

The full pg_hba.conf should be this:-

local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
host    all             all             0.0.0.0/0               md5


On 4/23/2014 12:29 AM, Michael Rowan wrote:
Hi
Utter novice would be glad of another hand here.

I have two Mac OSX 10.6.8 servers each with an iMac workstation OSX 10.6.8, so two seemingly identical setups.

Each server has an identical (as far as I can see) PG 9.1 installation and pgAdmin3 works fine on both with (copies of)  the same data.

Using an Omnis Studio client app, one workstation will connect (always has), the other will not (used to but not now). It gives no clue as to the problem.

I checked pg_hba.conf and postgresql.conf (listen_address = '*', port=5432)

Is there a way to get some debug feedback?  Glad to have any help.

Michael




-- 
siamo arrivati sani e salvi

pgsql-novice by date:

Previous
From: jagadishk
Date:
Subject: ALTER TABLE some table ADD PARTITION partition_name VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY')) ;
Next
From: Albe Laurenz
Date:
Subject: Re: ALTER TABLE some table ADD PARTITION partition_name VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY')) ;