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

Поиск
Список
Период
Сортировка
От Major Services
Тема Re: Unable to connect to Postgres database from email marketing software on the same host
Дата
Msg-id 375c2da1003150518x5dd82297vb8aa2701b0c24034@mail.gmail.com
обсуждение исходный текст
Ответ на Fwd: Unable to connect to Postgres database from email marketing software on the same host  (Major Services <services.major@gmail.com>)
Ответы Re: Unable to connect to Postgres database from email marketing software on the same host  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Unable to connect to Postgres database from email marketing software on the same host  (Major Services <services.major@gmail.com>)
Список pgsql-general
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
>>
>

В списке pgsql-general по дате отправления:

Предыдущее
От: Major Services
Дата:
Сообщение: Fwd: Unable to connect to Postgres database from email marketing software on the same host
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Unable to connect to Postgres database from email marketing software on the same host