Re: Backups

On Sat, Feb 20, 2010 at 10:11 AM, Nilesh Govindarajan <lists@itech7.com> wrote:
> I want a script to backup all databases table by table in different .sql
> files.

Why?  It may be that pg_dump / pg_restore already provide the
functionality you are looking for.

> How to do this ?

pg_dump -t tablename dbname

rinse repeat

> 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 ?

Can they just be a superuser?  Or can you grant them the role that has
ownership of the tables?