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

[Jorge Gustavo Rocha]

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>> 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
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> 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
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor