Opened 13 years ago

Closed 13 years ago

#3522 closed enhancement (fixed)

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:
Must Fix for Release: No Platform: All
Platform Version: 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 (3)

comment:1 by neumann, 13 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

comment:2 by jef, 13 years ago

implemented in r15258.

comment:3 by jef, 13 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.