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

Not sure how to check the server-log? Please help.

New to Postgres & Linux!


On Mon, Mar 15, 2010 at 5:48 PM, Major Services
<services.major@gmail.com> wrote:
> 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
>>>
>>
>