How To Install and Use PostgreSQL on Ubuntu 14.04

Ok so you know the blah blah of how PostgreSQL is awesome relation database (RDBMS) and great for reliable transactions, good for so many things, lots of enterprise features and gives concurrency without read locks and stuffs. If you are not aware of this RDBMS, then I would recommend you search for advantages of using PostgreSQL and what is served in its plate. PostgreSQL is pronounced mostly as "post gray sequel" or "post ge are ee as que el" (I am sounding very dramatic here). Back to the post now, Fire up your Ubuntu 14.04 to start the installation. It would almost follow the same for most of the Ubuntu flavors out there. First step - you know the drill :) sudo apt-get update Next step: sudo apt-get install postgresql postgresql-contrib postgresql installs the core PostgreSQL engine and RDBMS around which everything else is build. The » Read more