[postgis-users] Creating a template for postgis-enabled databases?

[Sebastien ARBOGAST]

I still have one problem with this procedure. The owner of
template_postgis is the user with which I created it, in this case
postgres. And when I create a new database based on this template,
both geometry_columns and spatial_ref_sys have their owner set to
postgres instead of the owner of the new database.

Is it normal? Is there a way to change that?

2007/12/16, Sebastien ARBOGAST <sebastien.arbogast at gmail.com>:
> Yes! That worked great. Thanks to both of you.
>
> 2007/12/16, LuVar <varga.lubomir at orangemail.sk>:
> > Jop. I get also the same. Just try to disconnect in pgAdmin and
> > reconnect. Than click ONLY on that database, in which you want to do
> > somethink. Dont open "template_postgis" table. You must have an red
> > cross iccon on "template_postgis" database.
> >
> > Try, and good luck.
> >
> > Sunday, December 16, 2007, 3:25:11 PM, you wrote:
> >
> > > I just did that and I can't create a database based on template_postgis.
> >
> > > When I try to do it via pgAdmin, I get a message saying that "Source
> > > database "template_postgis" is being accessed by other users
> >
> > > When I try to run the command in terminal, I get the following message:
> >
> > > createdb: could not connect to database template1: could not translate
> > > host name "tagspot_local" to address: nodename nor servname provided,
> > > or not known
> >
> >
> >
> > > 2007/12/16, Shoaib Burq <shoaib at nomad-labs.com>:
> > >> Sebastian, please see:
> > >> http://geospatial.nomad-labs.com/2007/12/16/template-postgis-database/
> > >> shoaib
> > >>
> > >>
> > >>  On Dec 16, 2007 10:15 AM, Sebastien ARBOGAST <sebastien.arbogast at gmail.com>
> > >> wrote:
> > >> >
> > >> > Hi,
> > >> >
> > >> > I've just installed postgresql 8.2.5 and postgis 1.3.2 on my mac and
> > >> > everything works great so far. Now I'm just looking for a way to
> > >> > simplify the creation of postgis-enabled databases in pgAdmin.
> > >> > I saw that in the Windows distribution, there is a template to do so,
> > >> > but there is no such template in my installation. Knowing that it's
> > >> > the first time that I use postgresql and postgis, is there a way to
> > >> > create such a template?
> > >> >
> > >> >
> > >> > --
> > >> > Sébastien Arbogast
> > >> >
> > >> > http://www.sebastien-arbogast.com
> > >> > _______________________________________________
> > >> > postgis-users mailing list
> > >> > postgis-users at postgis.refractions.net
> > >> >
> > >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> > >> >
> > >>
> > >>
> >
> >
> >
> >
> > --
> > Best regards,
> >  LuVar                            mailto:varga.lubomir at orangemail.sk
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
> --
> Sébastien Arbogast
>
> http://www.sebastien-arbogast.com
>


-- 
Sébastien Arbogast

http://www.sebastien-arbogast.com