Re: How do I create a Backup Operator account ?

2019-07-30 Thread Marcos Aurelio Nobre
I've also been thinking about this possibility. Create a Linux (S.O.) user account that has the ability to run pg_dump and pg_restore and enable this user account to be able to connect to a database - I believe this is possible through PG_HBA.CONF But I don't know how to implement this on Linux, n

How do I create a Backup Operator account ?

2019-07-29 Thread Marcos Aurelio Nobre
Hi all. I need to create a PostgreSQL account , that only do a Backup and Restore operations over a PGSQL Database . My main difficulty is to only assign Backup and Restore capability to one user account, unlike the ability to perform DQL and DML operations for ordinary user accounts. In POSTGRE