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 , 13 years ago
comment:3 by , 13 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
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