Re: Fwd: Restarting with pg_ctl, users, and passwords.

SOLVED.

Yep, Restart was done.

The issue turned out not to be with Postgresql config, but the app
config. In the app, I define a connection string, which has user,
password, and databasename. When I had this same configuration on
WinXP, I did not need to specify a fourth parameter, the host, which
explicitly told the app to use host=localhost. When I added the host
param to the connection string, it all went through.

On the bright side, I learned a lot about how to restart the service
and the config files...

Curious: Any ideas why I can leave the host off my connection string
in WinXP, but not Linux? It it an idiosyncracy of my app, or of
PostgreSQL?

Thanks for all the help,
Matt

On Wed, Aug 20, 2008 at 1:27 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> 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 &#39;FATAL: Ident authentication failed for user
>> &quot;postgres&quot;
>> &#39;.
>
> 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.
>

--
It is from the wellspring of our despair and the places that we are
broken that we come to repair the world.
-- Murray Waas