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 <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> 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 [email protected]<mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users "Glory is fleeting, but obscurity is forever." - Napoleon Bonaparte
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
