---------- Forwarded message ---------- From: Major Services <[email protected]> Date: Mon, Mar 15, 2010 at 5:36 PM Subject: Re: [GENERAL] Unable to connect to Postgres database from email marketing software on the same host To: [email protected]
I have the following: host all dbadmin 0.0.0.0/0 trust Do I need to change it to host all dbadmin 127.0.0.1/32 trust There are other (JAVA) applications connecting to the server with user dbadmin remotely. Hope any change does not affect that. Thanks On Mon, Mar 15, 2010 at 5:25 PM, Raymond O'Donnell <[email protected]> wrote: > On 15/03/2010 11:24, Major Services wrote: > >> I have an email marketing software installed on the same server as >> PostgresSQL database. >> Am unable to connect to the database from this application. The >> database owner is dbadmin. >> >> My pg_hba.conf has one entry as: >> >> local all dbadmin trust >> >> What other setup is required for this? > > If the application is connecting via TCP/IP, I think you need a "host" > rule for that: > > host all dbadmin 127.0.0.1/32 trust > > Ray. > > -- > Raymond O'Donnell :: Galway :: Ireland > [email protected] > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
