Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C6E0C9FB30F for ; Mon, 26 Feb 2007 09:57:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 01445-02 for ; Mon, 26 Feb 2007 09:57:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lucy.ppimedia.de (lucy.ppimedia.de [194.180.18.131]) by postgresql.org (Postfix) with ESMTP id 4E7099FB2FF for ; Mon, 26 Feb 2007 09:57:30 -0400 (AST) Received: by lucy.ppimedia.de (Postfix, from userid 501) id D6B1A4640E0; Mon, 26 Feb 2007 14:57:27 +0100 (CET) Received: from max.ppinet.de (max.ppinet.de [172.31.43.64]) by lucy.ppimedia.de (Postfix) with ESMTP id BC6B84640DC for ; Mon, 26 Feb 2007 14:57:27 +0100 (CET) Received: by max.ppinet.de with Internet Mail Service (5.5.2653.19) id ; Mon, 26 Feb 2007 14:57:27 +0100 Message-ID: <6D48B8403D926449BDE8440EC7EEC46D02AF14B6@max.ppinet.de> From: Antje.Stejskal@ppimedia.de To: pgsql-admin@postgresql.org Subject: Recovery/Rollback question Date: Mon, 26 Feb 2007 14:57:16 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.12 tagged_above=0 required=5 tests=AWL, BAYES_50, NO_REAL_NAME X-Spam-Level: ** X-Archive-Number: 200702/320 X-Sequence-Number: 24785 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