Re: pg_service.conf and client support

On 6/13/20 10:03 PM, Niels Jespersen wrote:
> Hello all
> 
> I just found out about the pg service file. 
> https://www.postgresql.org/docs/current/libpq-pgservice.html
> 
> I don’t know why it took me so long finding this. I have been looking 
> for ways to abstract physical details of data location away for clients 
> (much like Oracle’s tnsnames).
> 
> Want to move a cluster to a new host. Sure, move it, edit 
> pg_service.conf and clients will not know the difference.
> 
> It works great for at least psql and psycopg2.
> 
> But I cannot find anything on pg_service.conf and the Postgres ODBC 
> driver and Npgsql for .Net
> 
> I know pg_service.conf support is implemented through libpq and support 
> for rivers not using libpq is not a given thing.
> 
> But I think the need for the abstraction of connection details is a 
> general one.
> 
> Can anyone shed som light on the ubiquitousness of support for 
> pg_service.conf?
> 
> Are there any other mechanisms with broader support, that can be used 
> instead of pg_service.conf (if support is scarce beyond what builds on 
> libpq)?

Only thing I know of is something like 
pgbouncer(http://www.pgbouncer.org/) where you keep a constant 
connection setting for the pooler and then change the settings for the 
database(s) it connects to.

> 
> Thank you.
> 
> Regards Niels Jespersen
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com