Ticket #3522 (closed enhancement: fixed)

Opened 2 years ago

Last modified 2 years ago

Postgis provider: support for PostgreSQL service connection parameter

Reported by: neumann Owned by: nobody
Priority: minor: annoyance Milestone: Version 1.7.0
Component: Data Provider Version:
Keywords: Cc:
Platform Version: Platform: All
Must Fix for Release: No Awaiting user input: no

Description

It would be nice if the PostgreSQL provider would accept the service parameter alternatively to hostname/port (and potentially database)

This would allow an easier change the underlying postgresql server (e.g. in case of a crash or new server installation) since one would connect to the service rather than a hostname and port.

This is also important in case of a db-replication and switchover.

The provider connection dialogue should offer an additional line named "service" and, if the service value is present, it would have precedence over host and port.

Change History

Changed 2 years ago by neumann

see also  http://www.postgresql.org/docs/current/static/libpq-pgservice.html

example pg_service.conf:

#zeigt auf den jeweils aktiven master server, bzw. webserver #bei switchover hostname anpassen [pg_uster] host=srv138 port=5432 dbname=uster

Changed 2 years ago by jef

implemented in r15258.

Changed 2 years ago by jef

  • status changed from new to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.