18

as a cartographer I work with TileMill to visualize geodata. I installed a local PostgreSQL server with PostGIS and osm2pgsql. Everything works fine.

Anyhow, I am new to working with servers and the command line approach. So, in learning the basics of database management, some GUI tool would be of great help. Could I for example safely run the PgAdmin app next to the PostgrSQL installation (http://postgresapp.com/) on my Mac OS X Mavericks?

Any suggestions most welcome.

Improve this question
4
  • 5
    yes you can use pgadmin and postgres simultaneously.
    – neogeomat
    Commented Nov 20, 2013 at 10:44
  • Use pgadmin. On many platforms (eg windows) it is even part of the default postgresql install.
    – johanvdw
    Commented Nov 20, 2013 at 11:14
  • On the Mac it's just a little app to get the server running. And it provides a link to the command line.
    – jm60
    Commented Nov 20, 2013 at 11:19
  • 1
    I got pgAdmin running now alongside Postgres. It is a good couple: learning the database structure thru the GUI and practising the commands in the Terminal.
    – jm60
    Commented Nov 20, 2013 at 20:09

1 Answer 1

Reset to default
25

A great solution is to use QGIS as a GUI for PostGIS.

QGIS is a fully-functional GIS (I prefer to think of it actually as a meta-GIS given that it is built on many GIS packages). It has built-in support to connect to PostGIS and therefore gives you all the tools needed to view, edit and create maps from your data.

Improve this answer
1
  • 1
    I work with QGIS but I was not aware of the PostGIS functions. Thanks for the advice & have a good day.
    – jm60
    Commented Nov 20, 2013 at 11:03

Your Answer

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

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