X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4C7D9D1B500 for ; Fri, 19 Sep 2003 14:50:40 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 57329-05 for ; Fri, 19 Sep 2003 11:50:33 -0300 (ADT) Received: from dyatel.antar.bryansk.ru (unknown [195.239.214.85]) by svr1.postgresql.org (Postfix) with ESMTP id E13ECD1B4E8 for ; Fri, 19 Sep 2003 11:50:28 -0300 (ADT) Received: from fduch by dyatel.antar.bryansk.ru with local (Exim 4.22) id 1A0Mae-000NuR-Rg; Fri, 19 Sep 2003 18:50:32 +0400 Date: Fri, 19 Sep 2003 18:50:32 +0400 From: "Alexander M. Pravking" To: Andreas Joseph Krogh Cc: pgsql-sql@postgresql.org Subject: Re: Backup of multiple tables Message-ID: <20030919145032.GB71229@dyatel.antar.bryansk.ru> References: <200309191354.06071.andreak@officenet.no> <20030919141917.GA71229@dyatel.antar.bryansk.ru> <200309191630.57532.andreak@officenet.no> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <200309191630.57532.andreak@officenet.no> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/200 X-Sequence-Number: 15178 On Fri, Sep 19, 2003 at 04:30:57PM +0200, Andreas Joseph Krogh wrote: > > Here's a perl script I used to dump all the tables separately. > > I'm not sure most of options do work there, I didn't test ;-) > > It won't be hard to make it dump certain tables, I think. > > Thanks for your suggestion, but the problem with it is that I may end up with > inconsistencies if data is inserted/updated or deleted in one of the tables > during the backup, so I would miss the "snapshot"-effect. You can try to explicitly lock all tables being dumped from the script before and release them after dump is complete... But there could be dead-lock conditions. What will gurus say? -- Fduch M. Pravking