HowTo – Postgres

Postgres 9.3 Installation

This entry was posted in How To's HowTo - Postgres Howto - Ubuntu on by

Super basic installation of Postgres for development. This installation assumes latest Ubuntu LTS as of October 2014 which is Trusty 14.04. Install Postgres 9.3 through apt-get: apt-get install postgresql-9.3 Set postgress password on operating system as root using passwd cmd and then su to postgres and change in database schema: […]

PostGis and pgRouting

This entry was posted in How To's HowTo - Postgres Howto - Ubuntu on by

PostGIS is a spatial database extender for the PostgreSQL Open Source Object-Relational database management system. pgRouting extends the PostGIS/PostgreSQL geospatial database to provide geo-spatial routing and other network analysis functionality. We use these alot as the backend for any web or mobile application. This installation assumes latest Ubuntu LTS as […]