On Thu, Dec 12, 2013 at 8:01 AM, Andrea Aime
<[email protected]>wrote:
> On Thu, Dec 12, 2013 at 3:50 PM, Justin Deoliveira <
> [email protected]> wrote:
>
>> Hmm... one thing I worry about is common typing mistakes when typing in a
>> database name... although I imagine the create option would be disabled by
>> default. I do kind of question how generally useful this would be though
>> outside of a dev environment, most production databases i have seen don't
>> use an account with administrative privileges for normal geoserver usage.
>> And I would assume this would only work if the user has access to create
>> new databases.
>>
>
> Yes and no, you just need to give a GRANT to that use
>
>
>>
>> Also, one thing to keep in mind is that creating postgis databases with
>> templates is no longer the recommended way to do this, instead the
>> extension mechanism is used. So I guess some sort of "initialization" sql
>> would be needed in that case.
>>
>
> Hmm... while I know about the extension mechanism (create extension
> postgis) I was not aware that templates
> went out of fashion?
> Templates do more than just containing an extension, for example, it
> allows to setup defaults for charsets,
> collation, provide an initial content too I believe.
>
> I've searched for "postgresql template deprecated", found nothing.. I
> would expected this kind of change
> to meet with much clamor on the internet?
>
Sorry, i should have been more clear. For postgis specifically the old
workflow of:
1. creating a new empty database called template_postgis
2. running the sql scripts to enable postgis in it
3. creating new databases from that template database
Is no longer the recommended way postgis recommends to spatially enable a
database. Instead they recommend:
1. create a new empty database
2. run the sql command "create extension postgis" on it
That said I am not sure if the template approach is explicitly
deprecated... I would have to ask Paul (cc'd) here.
And I don't believe the postgresql template database support itself is
going anywhere.
Cheers
> Andrea
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>
--
*Justin Deoliveira*
Vice President, Engineering | Boundless
[email protected]
@j_deolive <https://twitter.com/j_deolive>
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
