X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7ED5832A0A0 for ; Mon, 4 Oct 2004 21:57:36 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55800-09 for ; Mon, 4 Oct 2004 20:57:31 +0000 (GMT) Received: from mail.kwasar.biz (s142-179-54-133.bc.hsia.telus.net [142.179.54.133]) by svr1.postgresql.org (Postfix) with ESMTP id 98B00329FAF for ; Mon, 4 Oct 2004 21:57:31 +0100 (BST) Received: from [192.168.1.102] (geotivity.net [204.191.12.220] (may be forged)) (authenticated bits=0) by mail.kwasar.biz (8.12.10/8.12.10) with ESMTP id i94KvT0u022694 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 4 Oct 2004 13:57:30 -0700 Subject: Enabling --log-update From: Dan Hrabarchuk To: pgsql-admin@postgresql.org Content-Type: text/plain Message-Id: <1096923449.6150.11.camel@dan.geotivity.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Mon, 04 Oct 2004 13:57:29 -0700 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/86 X-Sequence-Number: 15079 I need to track changes to my database while I'm doing a pg_dump. I've found a reference to do this http://www.arkeia.com/hotbackup/postgresql/ (see the second method). It states that I need to put my database in the "mode --log-update" I've tried to do this, but I keep getting an error saying that --log-update needs an argument. I can't find any documentation on this switch. Please help! If I can't get this working my next alternative is to use either http://gborg.postgresql.org/project/tablelog/projdisplay.php or http://gborg.postgresql.org/project/audittrail/projdisplay.php I need to have the database available while the dump is done. Thanks is advance Dan Hrabarchuk