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

Error message is "Server call failed for unknown reason"

The software doc does not mention whether trying to establish a
connection via UNIX-Sockets or
via TCP/IP?



On Mon, Mar 15, 2010 at 5:43 PM, Major Services
<services.major@gmail.com> wrote:
> ---------- Forwarded message ----------
> From: Major Services <services.major@gmail.com>
> 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: rod@iol.ie
>
>
> 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 <rod@iol.ie> 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
>> rod@iol.ie
>>
>