Skip to content

Instantly share code, notes, and snippets.

@mlevans
Last active October 11, 2015 05:17
Show Gist options
  • Save mlevans/3808891 to your computer and use it in GitHub Desktop.
Save mlevans/3808891 to your computer and use it in GitHub Desktop.
Postgres.app with PostGIS on MacOS X Lion
Running locally on MacOS X Lion
1. You may have postgres running locally on your machine on port 5432. We'll need to shut it down,
since we're going to use Postgres.app (postgresapp.com). I had previously downloaded PostgreSQL
from EnterpriseDB (http://enterprisedb.com/downloads/postgres-postgresql-downloads).
This was my process.
- `cd /Library/PostgreSQL/9.1/bin`
- Find out where postgres stores your data with `ps aux | grep postgres` (My data was in /Library/PostgreSQL/9.1/data)
- ` sudo su postgres`
- `./pg_ctl stop -D /Library/PostgreSQL/9.1/data`
- Note the message 'server stopped.'
2. Download and install Postgres.app from postgresapp.com.
3. Drag Postgres.app into your Applications folder.
… to be continued when shp2pgsql works
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment