Postgres - create a separate user with privileges for back up and restore

How it works
1

I want to create a separate user for back up and restore. This needs to be a read only user. What privileges and type of user is needed for sqlbackupandftp to work? Is there a ready script that I can use to do this?

2

Hi Nikhil_Ramabhadra,

Please give us some time to check the issue, we’ll keep you updated.

Sorry for the inconvenience.

3

Hi Nikhil_Ramabhadra,

Thank you for waiting.

To create a backup, you need read permissions. Also, for the correct work of the application, you have to have all the permissions for the postgres database. This is required to execute a query for the list of databases:

SELECT datname FROM pg_database.

Sorry for the inconvenience.