Hi Bob, The goal is to use pg_services on the client side, ie, to configure the ESRI client. Does ESRI clients work with pg_services? (I don't know!). It's implemented in the Postgresql library, so clients rely on the library to do the connection.
I used pgBouncer for several years and it worked quite well. It is stable. Good luck, Jorge Às 16:00 de 22/05/19, Basques, Bob (CI-StPaul) escreveu: > 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 > J. Gustavo -- Jorge Gustavo Rocha Departamento de Informática Universidade do Minho 4710-057 Braga Tel: +351 253604480 Fax: +351 253604471 Móvel: +351 910333888 skype: nabocudnosor _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
