Gostaria de confirmar se para criar um usuário específico para o script de pg_dump só preciso de permissões nas tabelas e sequencias como o exemplo que peguei na internet: CREATE USER backup_user WITH ENCRYPTED PASSWORD 'password'; GRANT CONNECT ON DATABASE production to backup_user; \c production GRANT USAGE ON SCHEMA public to backup_user; /*thanks Dominic!*/ GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO backup_user; GRANT SELECT ON ALL TABLES IN SCHEMA public TO backup_user;
Atenciosamente, Alessandro Lima email [email protected]
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
