Difference between revisions of "Talk:Spatial data management using PostGIS"

From CUOSGwiki
Jump to navigationJump to search
Line 11: Line 11:
 
== PostGIS version problem ==
 
== PostGIS version problem ==
   
I tried to follow along your tutorial on an Ubunto 10.0.04 system that has been just minimally configured. I ran into troubles trying to execute the SQL files you reference
+
I tried to follow along your tutorial on an Ubunto 10.0.04 system that has been just minimally configured. I ran into troubles trying to execute the SQL GRANT steps you reference in section 4.2. I found that I do not have a directory .../contrib/postgis-1.5
  +
* I do have the contrib directory
  +
* the SQL file names you refer to are in the contrib directory, but it appears they belong to postgis-1.4
  +
* I have tried updating the system, but it seems that 1.4 is the current default postgis version for this version of ubuntu... ?
  +
* as a result, the geography_columns relation does not exist, so I gave up following along at that step.

Revision as of 15:33, 15 December 2010

Re: the "synaptic package manager"

Actually, when you use the apt-get program on the command line, technically I believe you are using the "Debian packaging system", which created the apt-__ commands. This predates the synaptic software, which I'm pretty sure is the GUI that went on top of the pre-existing packaging system.

In other words, when the tutorial says that it is using the "command line version" of synaptic, that isn't quite true. But close enough that I'm leaving it alone for now.

Postgresql installation and initialization of superuser in the database

I edited the wording (see history) to more accurately describe what's happening with these commands.

PostGIS version problem

I tried to follow along your tutorial on an Ubunto 10.0.04 system that has been just minimally configured. I ran into troubles trying to execute the SQL GRANT steps you reference in section 4.2. I found that I do not have a directory .../contrib/postgis-1.5

  • I do have the contrib directory
  • the SQL file names you refer to are in the contrib directory, but it appears they belong to postgis-1.4
  • I have tried updating the system, but it seems that 1.4 is the current default postgis version for this version of ubuntu... ?
  • as a result, the geography_columns relation does not exist, so I gave up following along at that step.