Re: Upgrading using pg_dumpall

On 09/04/2016 12:55 PM, Rich Shepard wrote:
> On Sun, 4 Sep 2016, Adrian Klaver wrote:
>
>> Another thing that came to mind is compatibility with existing
>> applications/clients. You say you have been running using trust and I am
>> betting your client connection parameters reflect that. Now for
>> connections methods that can 'see' the .pgpass file and use libpq as the
>> their underlying Postgres library then things should work. Otherwise your
>> applications may not be able to connect until you supply the correct
>> password in some manner.
>
> That's a concern. My business financial software uses postgres as the
> backend and a browser UI and I enter my username and password on the login
> page. It works with auth method trust. I've no idea exactly how it connects
> to the database. Since it ain't broke I won't futz with it and possibly

It is using its own authentication method and tables, independent of
Postgres, that restrict access to its own data, not the cluster as whole.

> break it. I've other things with higher priorities.
>
> Rich
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com