Thoughts from Mads Sülau Jørgensen

Various articles about programming and systems administration.

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • Licence
  • About

Monthly Archives: April 2010

Extracting a single database from a pg_dumpall PostgreSQL dump

Posted on April 9, 2010 by Mads Sülau Jørgensen
4

Some data got deleted from one of our databases, and we had to restore it from our backups.

To make sure we get everything from our PostgreSQL cluster’s, we use pg_dumpall to make a SQL dump. It’s in no way the most efficient way to do a backup of a PostgreSQL database cluster, but it is by far the most flexible.

Continue reading →

Posted in Uncategorized | 4 Replies

Recent Posts

  • Converting a south 0.7 migration back to 0.6
  • iptables throughput on Soekris net4801
  • How to resize ext3 partition on LVM
  • Extracting a single database from a pg_dumpall PostgreSQL dump
  • Figuring out largest/smallest/median filesizes

Recent Comments

  • Resize ext3 partition with LVM - Ext3 Ext4 Tutorial on How to resize ext3 partition on LVM
  • Mads Sülau Jørgensen on Django – sharing a memcached instance
  • Andrew Ash on Django – sharing a memcached instance
  • Mads Sülau Jørgensen on Asynchronous socket server in python
  • wildman on Asynchronous socket server in python

Archives

  • September 2010
  • July 2010
  • April 2010
  • February 2010
  • September 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • October 2008
  • July 2008
  • May 2008
  • March 2008
  • February 2008

Categories

  • Actionscript
  • Apache
  • Django
  • flash
  • fun
  • Insanity
  • Me
  • Programming
  • Python
  • Ramblings
  • Rants
  • Uncategorized
  • Work

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Proudly powered by WordPress