Don’t forget the globals!

pg_dump is a great tool.  You can get a consistent database backup from a live database without impacting your running traffic. Many people don't realize however that a pg_dump isn't actually a complete backup... pg_dump pg_dump operates on a single database in a postgres cluster.  You provide it with the name of a database and [by [...]

By | October 27th, 2016|Categories: Scott PostgreSQL|Tags: , , , |4 Comments

HDFS for PostgreSQL Backups

On several occasions, I've been talking with groups of PostgreSQL users and the question comes up, "If I use PostgreSQL, why would I want to use Hadoop?" There are many answers and the question is usually asked when people don't really understand the details about Hadoop, but let's just focus on a single use case. [...]

By | July 11th, 2013|Categories: Jim PostgreSQL|Tags: , , , |Comments Off on HDFS for PostgreSQL Backups