Re: [postgis-users] where is postgis.sql?

[Mike Toews]

On 2 October 2012 13:53, Vince Miller  wrote:
> 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".

Both GEOS and PostGIS 2.0 needs to be installed from source. Follow
the instructions here:
http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204src

Hope it works out!

-Mike
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [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  wrote:

> From: Mike Toews 
> Subject: Re: [postgis-users] where is postgis.sql?
> To: "PostGIS Users Discussion" 
> 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 
> 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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] where is postgis.sql?

[Mike Toews]

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  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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] where is postGIS.sql?

[Jeff Lake]

For Ubunto ..not sure if there is an 'apt' package or not


*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
On 9/29/2012 14:27, Vince Miller wrote:
Yes, thanks Jeff. I got this. This seems to be the "build it yourself 
from source" option. Is this the only way?


--- On *Sat, 9/29/12, Jeff Lake //* wrote:


    From: Jeff Lake 
    Subject: Re: [postgis-users] where is postGIS.sql?
To: "PostGIS Users Discussion" 
Date: Saturday, September 29, 2012, 11:19 AM

http://postgis.refractions.net/download/




*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
On 9/29/2012 14:15, Vince Miller wrote:

By "it" you mean? Ubuntu 12.04: yes, postgresql 9.1 yes, postgis:
is there something I need to to to install it? like, compile it
from source?

Vince

--- On *Sat, 9/29/12, Jeff Lake /
    /* wrote:


    From: Jeff Lake 

Subject: Re: [postgis-users] where is postGIS.sql?
To: "PostGIS Users Discussion"


Date: Saturday, September 29, 2012, 10:56 AM

Just because I gotta know ..
you didn't mention it but I assume you installed it ??


*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
On 9/29/2012 13:48, Vince Miller wrote:

Sorry, I meant Ubuntu 12.04.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




-Inline Attachment Follows-

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net  

http://postgis.refractions.net/mailman/listinfo/postgis-users



-Inline Attachment Follows-

___
postgis-users mailing list
postgis-users@postgis.refractions.net

http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] where is postGIS.sql?

[Vince Miller]

Yes, thanks Jeff. I got this. This seems to be the "build it yourself from 
source" option. Is this the only way?

--- On Sat, 9/29/12, Jeff Lake  wrote:

From: Jeff Lake 
Subject: Re: [postgis-users] where is postGIS.sql?
To: "PostGIS Users Discussion" 
Date: Saturday, September 29, 2012, 11:19 AM


  


  
  
http://postgis.refractions.net/download/

  

  

  

  

  Jeff Lake

MichiganWxSystem

AllisonHouse

GRLevelXStuff
  On 9/29/2012 14:15, Vince Miller wrote:



  

  
By "it" you mean?
  Ubuntu 12.04: yes, postgresql 9.1 yes, postgis: is there
  something I need to to to install it? like, compile it
  from source?

  

  Vince

  

  --- On Sat, 9/29/12, Jeff Lake 
  wrote:

  

From: Jeff Lake 

        Subject: Re: [postgis-users] where is postGIS.sql?

To: "PostGIS Users Discussion"


Date: Saturday, September 29, 2012, 10:56 AM




  
Just
  because I gotta know ..

  you didn't mention it but I assume you installed
  it ??

  

  

  Jeff
  Lake

MichiganWxSystem

AllisonHouse

GRLevelXStuff
  On 9/29/2012 13:48, Vince Miller wrote:



  Sorry, I meant Ubuntu 12.04.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





  



-Inline Attachment Follows-



___

  postgis-users mailing list

  postgis-users@postgis.refractions.net

  http://postgis.refractions.net/mailman/listinfo/postgis-users


  

  

  
  

  
  

  ___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




  


-Inline Attachment Follows-

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] where is postGIS.sql?

[Mr. Puneet Kishor]

On Sep 29, 2012, at 11:15 AM, Vince Miller  wrote:

> By "it" you mean? Ubuntu 12.04: yes, postgresql 9.1 yes, postgis: is there 
> something I need to to to install it? like, compile it from source?



Yes, you do need to install PostGIS (it is not a part of Postgres). How you 
install it depends on your OS. You well might have to download the source code 
and compile it for your machine.

Once you install PostGIS successfully, then you can ask more questions here. 
Check out the Postgis website for the download and installation instructions.



--
Puneet Kishor
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] where is postGIS.sql?

[Jeff Lake]

http://postgis.refractions.net/download/




*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
On 9/29/2012 14:15, Vince Miller wrote:
By "it" you mean? Ubuntu 12.04: yes, postgresql 9.1 yes, postgis: is 
there something I need to to to install it? like, compile it from source?


Vince

--- On *Sat, 9/29/12, Jeff Lake //* wrote:


From: Jeff Lake 
    Subject: Re: [postgis-users] where is postGIS.sql?
To: "PostGIS Users Discussion" 
Date: Saturday, September 29, 2012, 10:56 AM

Just because I gotta know ..
you didn't mention it but I assume you installed it ??


*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
On 9/29/2012 13:48, Vince Miller wrote:

Sorry, I meant Ubuntu 12.04.
___
postgis-users mailing list
postgis-users@postgis.refractions.net  

http://postgis.refractions.net/mailman/listinfo/postgis-users




-Inline Attachment Follows-

___
postgis-users mailing list
postgis-users@postgis.refractions.net

http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] where is postGIS.sql?

[Vince Miller]

By "it" you mean? Ubuntu 12.04: yes, postgresql 9.1 yes, postgis: is there 
something I need to to to install it? like, compile it from source?

Vince

--- On Sat, 9/29/12, Jeff Lake  wrote:

From: Jeff Lake 
Subject: Re: [postgis-users] where is postGIS.sql?
To: "PostGIS Users Discussion" 
Date: Saturday, September 29, 2012, 10:56 AM


  


  
  
Just because I gotta know ..

  you didn't mention it but I assume you installed it ??

  

  

  Jeff Lake

MichiganWxSystem

AllisonHouse

GRLevelXStuff
  On 9/29/2012 13:48, Vince Miller wrote:



  Sorry, I meant Ubuntu 12.04.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





  


-Inline Attachment Follows-

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] where is postGIS.sql?

[Jeff Lake]

Just because I gotta know ..
you didn't mention it but I assume you installed it ??


*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 9/29/2012 13:48, Vince Miller wrote:

Sorry, I meant Ubuntu 12.04.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] where is postGIS.sql?

[Vince Miller]

Sorry, I meant Ubuntu 12.04.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] where is postgis.sql?

[Vince Miller]

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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users