On Sat, Feb 20, 2010 at 10:11 AM, Nilesh Govindarajan <lists(at)itech7(dot)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?