Opened 15 years ago

Closed 15 years ago

#404 closed task (fixed)

Ensure datistemplate is true for template_postgis

Reported by: pramsey Owned by: robe
Priority: medium Milestone: PostGIS 1.5.0
Component: postgis Version: 1.5.X
Keywords: windows Cc: Mike Pumphrey <mike@…>

Description

For the template_postgis created by the Windows installer, it's important that the datistemplate flag is set so that non-superusers can clone the template.

http://postgis.refractions.net/pipermail/postgis-devel/2009-June/006059.html

Change History (2)

comment:1 by pramsey, 15 years ago

update pg_database set datistemplate = true 
  where datname = 'template_postgis';

comment:2 by robe, 15 years ago

Resolution: fixed
Status: newclosed
Version: trunk1.5.X

The logic was in the script. Took us a while to figure out why it wasn't working. Was exiting at the createlang step so never did the update template step since the newer versions of PostgreSQL I guess already have plpgsql installed in the base template.

We also added in packaging of the shp2pgsqlgui loader and a prompt to overwrite the plugins.ini. It really doesn't do much on PostgreSQL 8.3 since the PgAdmin III packaged with 8.3 doesn't support the plugins architecture. Please check and see if this makes logical sense to everyone.

Anyrate if you want to give it a try before we officially upload to stackbuilder and link on site.

http://www.postgis.org/download/windows/pg84/postgis-pg84-setup-1.5.0-1.exe http://www.postgis.org/download/windows/pg83/postgis-pg83-setup-1.5.0-1.exe

We still plan to test on a couple other machines before we officially deploy.

Thanks, Regina and Leo

Note: See TracTickets for help on using tickets.