[mapserver-users] Same database connection across multiple layers

[Richard Greenwood]

Yep.

On Fri, May 13, 2022 at 9:52 AM Atlanta Geek <atlantageek at gmail.com> wrote:

> So I would put the INCLUDE in all the layers, correct?
>
> On Fri, May 13, 2022 at 11:05 AM Richard Greenwood <
> richard.greenwood at gmail.com> wrote:
>
>> Use INCLUDE 'pgconn.map'
>>
>> With pgconn.map looking like:
>>
>> CONNECTIONTYPE postgis
>> CONNECTION "user=USER password=PASSWORD dbname=DATABASE host=127.0.0.1
>> port=5432"
>> PROCESSING "CLOSE_CONNECTION=DEFER"
>>
>>
>> On Fri, May 13, 2022 at 7:14 AM Atlanta Geek <atlantageek at gmail.com>
>> wrote:
>>
>>> Is there a way to set the db connection only once for multiple layers.
>>> We have a very dynamic mapfile with lots of layers and its a pain to
>>> replace the db name when doing development or changing for a customer.  We
>>> are running ms4w as well.
>>>
>>>
>>> In addition to this is it possible to set the connection string outside
>>> the mapfile.  Maybe as an option to the cgi script or something.
>>>
>>> --
>>> http://www.atlantageek.com
>>> _______________________________________________
>>> MapServer-users mailing list
>>> MapServer-users at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>
>>
>>
>> --
>> Richard W. Greenwood
>> www.greenwoodmap.com
>>
>
>
> --
> http://www.atlantageek.com
>


-- 
Richard W. Greenwood
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20220513/db28501d/attachment.htm>