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

Wed May 22 08:48:49 PDT 2019

Jorge,

Researching that right now.

These two links indicate that there is a local location for setting up conection files, but I’m not sure if they are ESRI specific or not.  I tried saving a connection configuration to look at, but the files are all binary that ERSI apps produce for the connections, which makes some sense with regards to security (I suppose).

https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-postgresql/connect-postgresql.htm

https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-postgresql/preconfigure-connection-files.htm

I’ll need to experiment some more.  But the thing to try and figure out is if "service=<SomNonPostgresName>” can somehow be sent with the connection request.

bobb

On May 22, 2019, at 10:11 AM, 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,

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 <jgr at di.uminho.pt<mailto: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> <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> <tel:+351%20253604480>
Fax: +351 253604471<tel:+351%20253604471> <tel:+351%20253604471>
Móvel: +351 910333888<tel:+351%20910333888> <tel:+351%20910333888>
skype: nabocudnosor
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto: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

_______________________________________________
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

"When someone shows you who they are, believe them the first time. “
- Maya Angelou

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