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@xxxxxxxxx> 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@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
