From: Antje.Stejskal@ppimedia.de
To: pgsql-admin@postgresql.org
Subject: Recovery/Rollback question
Date: Mon, 26 Feb 2007 14:57:16 +0100
Message-ID: <6D48B8403D926449BDE8440EC7EEC46D02AF14B6@max.ppinet.de> (raw)
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 ?
Regards,
A.Stejskal
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: Antje.Stejskal@ppimedia.de
Subject: Re: Recovery/Rollback question
In-Reply-To: <6D48B8403D926449BDE8440EC7EEC46D02AF14B6@max.ppinet.de>
* 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