[postgis-users] where is postgis.sql?

[Vince Miller]

Thanks Mike, but your method produces the following message:

ERROR:  could not open extension control file "/usr/share/postgresql/9.1/extension/postgis.control": No such file or directory.

My OS is Ubuntu server 12.04, which includes with postgresql 9.1, which installs simply with "apt-get install postgresql".

I don't know if this install includes the "server headers" that postGIS requires, and I don't know how to find out if it does.

Other respondents to my initial query have left the impression that postgis is NOT included in the ubuntu distro, that there is no simple "apt-get" for it, and that I must download and build it from source separately. To do this I evidently must also apt-get gcc and make, and download and build several other packages (gdal, Geos, Proj, libxml2, and json-c). I have done this but, in the postgis-2.0.1 directory, the command 

./configure --with-raster --with-topology --with-xml2config=/home/vince/geos/libxml2-2.7.8/xml2-config

fails with the follwing message:

configure: error: could not find headers include related to libxml2

What am I missing here?

--- On Sat, 9/29/12, Mike Toews <mwtoews at gmail.com> wrote:

> From: Mike Toews <mwtoews at gmail.com>
> Subject: Re: [postgis-users] where is postgis.sql?
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Saturday, September 29, 2012, 2:32 PM
> Hi Vince,
> 
> What operation system? What method did you install? If you
> have
> pg_config installed (part of the development package of
> postgres), you
> can find the share and contrib directory:
> 
> $ ls `pg_config --sharedir`/contrib
> 
> But, since you are using 9.1, you should use the extension
> method of
> attaching postgis. From psql/pgAdmin in your target
> database, use the
> DDL command:
> 
> CREATE EXTENSION postgis;
> 
> -Mike
> 
> On 30 September 2012 06:28, Vince Miller <vincentpmiller at yahoo.com>
> wrote:
> > Newby question: I want to attach postgis to my new db.
> Postgresql 9.1 seemed to install fine, but I can't find
> postgis.sql. Where is it? It's not in /usr/share/.../contrib
> as I'm given to expect. I don't want to compile from source
> to get it, if I don't have to. What's its relationship to
> postgis.sql.in.c?
> >
> > Thanks for your help.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>