X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 11EEE9FA5D2 for ; Tue, 23 May 2006 12:51:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 89961-05 for ; Tue, 23 May 2006 12:50:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 3C3979FB213 for ; Tue, 23 May 2006 12:48:32 -0300 (ADT) Received: from ls405.htnet.hr (unknown [195.29.150.135]) by svr4.postgresql.org (Postfix) with ESMTP id 7AC475B5DD9 for ; Tue, 23 May 2006 15:48:09 +0000 (GMT) Received: from ls401.t-com.hr (ls401.t-com.hr [195.29.150.236]) by ls405.htnet.hr (Postfix) with ESMTP id 5D178144318 for ; Tue, 23 May 2006 17:47:36 +0200 (CEST) Received: from ls401.t-com.hr (localhost.localdomain [127.0.0.1]) by ls401.t-com.hr (Qmlai) with ESMTP id 42AD6E38E3 for ; Tue, 23 May 2006 17:47:36 +0200 (CEST) X-Envelope-Sender: mario.splivalo@mobart.hr Received: from 83-131-35-163.adsl.net.t-com.hr (83-131-35-163.adsl.net.t-com.hr [83.131.35.163])by ls401.t-com.hr (Qmali) with ESMTP id C9ECE38009for ; Tue, 23 May 2006 17:47:35 +0200 (CEST) Subject: Getting UPDATEs/INSERTs/DELETEs from transaction log? From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: Mob-Art Date: Tue, 23 May 2006 17:47:31 +0200 Message-Id: <1148399251.23161.12.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-imss-version: 2.040 X-imss-result: Passed X-imss-scores: Clean:29.27977 C:2 M:4 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/317 X-Sequence-Number: 21849 I'm doing backup on a second, spare server, by backing up WAL files. I'm using that server for analysis queries and reporting. Every 15 minutes I need to shut down that server, place in new WAL files, and restart server. That is ok, except that I need to backup whole database cluster. That wasnt't a problem before, but recently another database is in the cluster, and it's also backed up, although I dont' need it there. Is there a way (even if it means a hard way?) to somehow extract DML (except SELECTs, of course, but those aren't ih the log files, right?) from the WALs, so I can 'replay' it where ever I find it useful? Mike