permissions for database backup

grant-rsyncer-permissions.sh

#!/bin/sh

# these permissions only need to be run once, and then it allows rsyncer to backup the databases

SCHEMAS="auth base conflict custom log momomoto public release"
DATABASES="pentabarf_bsdcan pentabarf_pgcon"

for schema in ${SCHEMAS}
do
  for database in ${DATABASES}
  do
    echo echo \""grant usage on schema ${schema} to rsyncer;\"" \| psql ${database}
    echo "grant usage on schema ${schema} to rsyncer;" |psql ${database}

    echo echo \""grant select on all tables    in schema   ${schema} to rsyncer;\"" \| psql ${database}
    echo "grant select on all tables    in schema   ${schema} to rsyncer;" | psql ${database}

    echo echo \""grant select on all sequences in schema   ${schema} to rsyncer;\"" \| psql ${database}
    echo "grant select on all sequences in schema   ${schema} to rsyncer;" | psql ${database}
  done
done