Nilesh Govindarajan wrote: > I can prevent the changes to the database when the > backup is going on, but how do I grant the permissions ? I don't > want to key in the password for the superuser in the script. There are so many ways to deal with that that it's hard to make a suggestion without knowing more. You could just use CREATE USER and GRANT to set things up, you could use trust authentication in the pg_hba.conf to grant a database superuser permission from a secure machine, or you could use a pgpass file. (Check the documentation for details.) If I got creative I could probably come up with more, but I'm shooting in the dark here. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
