1

After the installation of the opengeo suite; everything seems to work fine, except for the postgis extension of postgresql. In the dashboard all the postgis options are greyed out.

The system is running Ubuntu 12.04 (Precise) LTS Bare OS.

Is there a way to install postgis afterwards with the templates from opengeo?

Improve this question
2
  • workshops.opengeo.org/postgis-spatialdbtips/installation.html is the old manual way with a few linux tips
    – Mapperz ♦
    Jan 22, 2013 at 14:51
  • I don't know why all the documentation on the web excludes the -h parameter but loading psql won't work without it for me? I instantly get the peer authentication error. For example, psql -d medford -h localhost -p 5432 -U opengeo -c "SELECT postgis_full_version();"
    – Shmuck Jones
    Jan 27, 2014 at 12:06

2 Answers 2

Reset to default
2

Actually on Linux installations the postgis specific functionality on the dashboard is explicitly disabled since it's not running as a native app. So unless you saw some installation errors it is probably fine. You can verify by logging into the database from the terminal. Try this.

psql -U opengeo medford select postgis_version();

If that all works everything should be fine.

Improve this answer
3
  • That is not working: psql: FATAL: Peer authentication failed for user "opengeo". I don't know if the installation produced errors, it started it and went off.
    – stUrb
    Jan 22, 2013 at 19:54
  • Actually I had to do some authentication first; and then I opened up remote configuration.... stil not working completely but I'm getting there! Thank you.
    – stUrb
    Jan 23, 2013 at 23:27
  • 1
    @jdeolive: your terminal command generated an error: bash: syntax error near unexpected token `('. I tried this command: psql -U opengeo medford -c"select postgis_version();" and it runs fine.
    – Cao Minh Tu
    Apr 3, 2013 at 9:15
0

I was in the same situation as yours (installed Opengeo suite on a clean Ubuntu 12.04 OS - found greyed out items for PostGIS in Opengeo Dashboard) - with some errors in the opengeo suite installation process:

Error in `/usr/share/doc-base/pgadmin3-enus', line 8: all `Format' sections are invalid.
Note: `install-docs --verbose --check file_name' may give more details about the above error.

And

psql: FATAL:  database "template_postgis" does not exist
psql: FATAL:  database "medford" does not exist
psql:/usr/share/opengeo-postgis/medford_taxlots_schema.sql:9: ERROR:  schema "opengeo" already exists
psql:/usr/share/opengeo-postgis/medford_taxlots_schema.sql:13: ERROR:  index "medford_taxlots_gix" does not exist
psql:/usr/share/opengeo-postgis/medford_taxlots_schema.sql:14: ERROR:  relation "public.medford_taxlots" does not exist
psql:/usr/share/opengeo-postgis/medford_taxlots_schema.sql:15: ERROR:  table "medford_taxlots" does not exist
psql: FATAL:  database "geoserver" does not exist

But when I opened pgAdmin3 and log in, PostGIS and some pre-installed database were there.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.