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

would the 'ident sameuser' entry qualify as a 'some non-functional
authentication method'?

On Wed, Aug 20, 2008 at 3:48 PM, Adrian Klaver <aklaver(at)comcast(dot)net> wrote:
>
> -------------- Original message ----------------------
> From: aklaver(at)comcast(dot)net (Adrian Klaver)
>> -------------- Original message ----------------------
>> From: "Matthew Pettis" <matthew(dot)pettis(at)gmail(dot)com>
>> > 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
>> >
>> Is the Linux app running on the Postgres server machine?
>> If so I hazard a guess that you have a line like:
>>
>> local all all trust
>
> Should have been:
>
> local all all some non-functional authentication method
>
> this would cause the connection to the socket to fail assuming the authentication method selected did not work.
>
>>
>> before your host line in pg_hba.
>>
>> The app connecting from the same machine would try the local socket (local)
>> before the localhost(tcp/ip), unless localhost was specified in the connection
>> string.
>>
>>
>>
>> --
>> Adrian Klaver
>> aklaver(at)comcast(dot)net
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
> --
> Adrian Klaver
> aklaver(at)comcast(dot)net
>
>

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