On Wed, Aug 20, 2008 at 11:38 AM, Matthew Pettis
<matthew(dot)pettis(at)gmail(dot)com> wrote:
> Hi Craig,
>
> Ok, I changed my pg_hba.conf from the commented line to the following
> line to try to open things up for now (I know I will need more
> security, but I'm trying to open things up wide to find the problem):
>
> --- pg_hba.conf --------------------
> # IPv4 local connections:
> #host all all 127.0.0.1/32 md5
> host all all 127.0.0.1/32 trust
> -------------------------------------------
>
> and made the following change to postgresql.conf (the line was
> previously commented out):
> --- postgresql.conf ----------------
> listen_addresses = 'localhost'
> -------------------------------------------
>
> I still am getting the same error from my application (which I believe
> is passing on some postgresql error info:
>
> --- App error ----------------------------------------
> Error reported was 'FATAL: Ident authentication failed for user
> "postgres"
> '.
You need to restart the postgresql service for the listen_addresses to
take effect, and either restarting or reloading will make the changes
you made in pg_hba.conf take effect.