Re: Unable to connect to Postgres database from email marketing software on the same host

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Major Services <services(dot)major(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to connect to Postgres database from email marketing software on the same host
Date: 2010-03-15 11:55:33
Message-ID: 4B9E2035.2070109@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
rod(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2010-03-15 11:56:32 Re: Postgres 8.4 Segfault on xpath
Previous Message A. Kretschmer 2010-03-15 11:51:06 Re: Unable to connect to Postgres database from email marketing software on the same host