pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Antje.Stejskal@ppimedia.de
Cc: pgsql-admin@postgresql.org
Subject: Re: Recovery/Rollback question
Date: Mon, 26 Feb 2007 13:44:46 -0600
Message-ID: <1172519086.20651.24.camel@state.g2switchworks.com> (raw)
In-Reply-To: <6D48B8403D926449BDE8440EC7EEC46D02AF14B6@max.ppinet.de>
References: <6D48B8403D926449BDE8440EC7EEC46D02AF14B6@max.ppinet.de>

On Mon, 2007-02-26 at 07:57, Antje.Stejskal@ppimedia.de wrote:
> Hi,
> 
> I am new to the list and want to say "hello" first.
> We are migrating to Postgres and therefore my question might be simple for
> you.
> We run several application databases under one db server. Now we are looking
> for a mechanism to rollback unwanted user command without impact for other
> databases. Is there a posiibilty to use something like WAL on tablespaces or
> databases not only on db servers?
> Does Postgres provide other utilities for this? Which strategies to you use?
> Scenatio running databases a and b under the server.
> It is now 10 o 'clock, user made a mistake at 8 o'clock  in database a, so
> we need to roll database a back to 8 o'clock, database b keeps current data
> status.
> How do you solve this under Postgres?  Any links to useful docu chapters ?

You can solve it with PITR (point in time recovery) but note that it
will roll back the whole cluster, not just one db in it.  However, PITR
is generally run on a secondary server, so that's ok.  If you're not set
up for PITR, you've asked a little late (i.e. after the fact is too
late) as it needs to be setup ahead of time normally.  You might want to
set up your machine to do PITR, but you need an image of your database
files from before the pebcak* incident.

Your users need to learn how to use transactions.  You can run some
pretty big transactions and roll them back if you don't like the
changes.  Once you commit though, you can't roll it back without using
disaster recovery techniques like PITR.

Look up PITR in the docs, it's a useful piece of kit.

*pebcak:  Problem exist(s|ed) between chair and keyboard.



view thread (4+ messages)  latest in thread

Message-ID: <1172519086.20651.24.camel@state.g2switchworks.com>
Permalink:  ../1172519086.20651.24.camel@state.g2switchworks.com/
Also on:    postgresql.org/message-id/1172519086.20651.24.camel@state.g2switchworks.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-admin@postgresql.org
  Cc: smarlowe@g2switchworks.com, Antje.Stejskal@ppimedia.de
  Subject: Re: Recovery/Rollback question
  In-Reply-To: <1172519086.20651.24.camel@state.g2switchworks.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