We here are very big fans of Postgres as a database and believe it is often the best database for the job. For many though, working with and maintaining Postgres involves a steep learning curve. This guide is designed as an aid for beginners and experienced users to find specific tips and explore tools available within Postgres.
If you want to take the quick & painless approach instead, there are great services available such as Heroku Postgres.
Note
This still is still under rapid development. Please send any suggestions (or requests) to craig.kerstiens@gmail.com. If you’re interested in helping to maintain this document please hop over to github and contribute. To follow updates to the site check out our twitter account PostgresGuide.
Postgres has gotten much more attention in recent years. It has accelerated its pace, meanwhile other RDMS’s have slowed in releases. Though Postgre SQL/PostgreSQL/Postgres has a very long history in databases, with its very name coming from one of the earliest databases Ingres (Post ingres = Postgres) and its own implementation beginning in 1986.
Guide:
Postgres Guide is intended to highlight best practices and great features that exist within Postgres. If new to databases or specifically Postgres hopefully you find content useful.