Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 765B76331E8 for ; Sat, 20 Feb 2010 13:18:38 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 31657-06 for ; Sat, 20 Feb 2010 17:18:26 +0000 (UTC) X-Greylist: delayed 00:06:48.932966 by SQLgrey-1.7.6 Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.25]) by mail.postgresql.org (Postfix) with ESMTP id CFD2A632F45 for ; Sat, 20 Feb 2010 13:18:27 -0400 (AST) Received: by qw-out-2122.google.com with SMTP id 3so192090qwe.61 for ; Sat, 20 Feb 2010 09:18:27 -0800 (PST) Received: by 10.224.65.36 with SMTP id g36mr4439773qai.92.1266685894317; Sat, 20 Feb 2010 09:11:34 -0800 (PST) Received: from ?192.168.1.254? ([121.246.205.20]) by mx.google.com with ESMTPS id 20sm960663qyk.1.2010.02.20.09.11.31 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sat, 20 Feb 2010 09:11:33 -0800 (PST) Message-ID: <4B8017C0.8070101@itech7.com> Date: Sat, 20 Feb 2010 22:41:28 +0530 From: Nilesh Govindarajan User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.7) Gecko/20100120 Shredder/3.0.1 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Backups Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201002/152 X-Sequence-Number: 33755 I want a script to backup all databases table by table in different .sql files. How to do this ? Also since it is a script, there has to be some role having read access to all tables on all databases. How to grant that ? -- Nilesh Govindarajan Site & Server Adminstrator www.itech7.com