[postgis-users] Any way of assigning a name alias to the system "postgres" database?

[Basques, Bob (CI-StPaul)]

Hi Jorge,

I found the info on the pg_service.conf file, and it works as described for a local connection.  I need to connect from a remote location.  Also looked at pgBouncer, but not sure how stable that is.

Trying to connect ESRI client to Postgres on the “postgres” database, which ESRI outlaws for some odd reason saying it’s a system table.  We have been using the “postgres” DB for quite a long time, and across many of our automated systems which are connected to it that would need to be changed to use a different name.

bobb




On May 21, 2019, at 5:36 PM, Jorge Gustavo Rocha <jgr at di.uminho.pt<mailto:jgr at di.uminho.pt>> wrote:

Think Before You Click: This email originated outside our organization.


Hi Bob,

In which context you want to use an alias?

If it is just for connecting to the database, check pg_services.conf
[1]. It allows you to use a name that will be resolved by the local
pg_service.conf file.

You can also use a client pool manager, like pgBouncer. It allows you to
use a local name, different from the database name.

I hope it helps.

Regards,

Jorge Gustavo

[1] https://www.postgresql.org/docs/11/libpq-pgservice.html
[2] https://pgbouncer.github.io/

Às 20:19 de 21/05/19, Basques, Bob (CI-StPaul) escreveu:
All (trying PostGIS users first),

I have a need to call it by another name, but also to leave it named as
is for legacy stuff.

Anyone know of a way to do this?

Thanks

bobb





Those who believe in telekinetics, raise my hand.
—Kurt Vonnegut


_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users


J. Gustavo
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480<tel:+351%20253604480>
Fax: +351 253604471<tel:+351%20253604471>
Móvel: +351 910333888<tel:+351%20910333888>
skype: nabocudnosor
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users



"Glory is fleeting, but obscurity is forever."
- Napoleon Bonaparte



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190522/458159e6/attachment.html>