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.

4
  • 5
    yes you can use pgadmin and postgres simultaneously. – neogeomat Nov 20 '13 at 10:44
  • Use pgadmin. On many platforms (eg windows) it is even part of the default postgresql install. – johanvdw Nov 20 '13 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 Nov 20 '13 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 Nov 20 '13 at 20:09
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.

1
  • 1
    I work with QGIS but I was not aware of the PostGIS functions. Thanks for the advice & have a good day. – jm60 Nov 20 '13 at 11:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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