pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Howard Cole <howardnews@selestial.com>
To: Reuven M. Lerner <reuven@lerner.co.il>
To: PgSql General <pgsql-general@postgresql.org>
Subject: Re: [PERFORM] Backup strategies
Date: Tue, 21 Oct 2008 16:28:51 +0100
Message-ID: <48FDF533.1020400@selestial.com> (raw)
In-Reply-To: <48F4D693.9000304@lerner.co.il>
References: <48F4D693.9000304@lerner.co.il>

Reuven M. Lerner wrote:
> I'm running a medium-traffic Web site that has been running for a few 
> years, and which uses about four PostgreSQL databases on a regular 
> basis.  I'm currently running 8.2, although I'm planning to upgrade to 
> 8.3 in the coming week or two, in part because of the problems that 
> I'm having.  The databases consume a combined total of 35 GB.  Like a 
> good boy, I've been backing the system up overnight, when we have less 
> traffic, since the site began to run.  I use pg_dump to back up, 
> saving both schemas and data for a full restore in case of  failure.  
> pg_dump typically executes from another machine on a local network; if 
> it would help to run pg_dump locally, then I'm certainly open to doing 
> that.
>
One point to note with continuous archiving, if your four databases are 
in the same cluster, then restoring the archive will restore all your 
databases to the same point in time. So you cannot, as far as I am 
aware, restore just one of the four databases.

Howard.



view thread (16+ messages)

Message-ID: <48FDF533.1020400@selestial.com>
Permalink:  ../48FDF533.1020400@selestial.com/
Also on:    postgresql.org/message-id/48FDF533.1020400@selestial.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: howardnews@selestial.com, reuven@lerner.co.il, pgsql-general@postgresql.org
  Subject: Re: [PERFORM] Backup strategies
  In-Reply-To: <48FDF533.1020400@selestial.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox