pg_service.conf and client support

From: Niels Jespersen <NJN(at)dst(dot)dk>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pg_service.conf and client support
Date: 2020-06-14 05:03:05
Message-ID: c5b02f3be97c48159508bf5e85b3f11a@dst.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)?

Thank you.

Regards Niels Jespersen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-06-14 05:26:41 Re: pg_service.conf and client support
Previous Message Adrian Klaver 2020-06-14 02:28:24 Re: Fwd: not able to give usage access to public schema