Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
> ---------- Forwarded message ----------
> From: Major Services <services.major@xxxxxxxxx>
> Date: Mon, Mar 15, 2010 at 5:36 PM
> Subject: Re:  Unable to connect to Postgres database from
> email marketing software on the same host
> To: rod@xxxxxx
>
>
> 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@xxxxxx> 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@xxxxxx
>>
>

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux