Feature request #3522

Postgis provider: support for PostgreSQL service connection parameter

Added by Andreas Neumann over 9 years ago. Updated over 9 years ago.

Status:Closed
Priority:Low
Assignee:nobody -
Category:Data Provider
Pull Request or Patch supplied: Resolution:fixed
Easy fix?:No Copied to github as #:13582

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.

History

#1 Updated by Andreas Neumann over 9 years ago

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

#2 Updated by Jürgen Fischer over 9 years ago

implemented in cdc9ae7c (SVN r15259).

#3 Updated by Jürgen Fischer over 9 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

Also available in: Atom PDF