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.

jm60
  • 315
  • 1
  • 2
  • 7
  • 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

1 Answers1

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.

Andre Silva
  • 10,259
  • 12
  • 54
  • 106
MappaGnosis
  • 33,857
  • 2
  • 66
  • 129
  • 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