I'm using AWS RDS, which means you don't get to be the real postgres super user:
admin@trixie:~$ pg_back -d "service=admin" -b ./backups --without-role-passwords
2026/08/11 07:49:03 INFO: connection user is not superuser, some information will not be dumped
2026/08/11 07:49:03 INFO: dumping globals without role passwords
2026/08/11 07:49:03 INFO: dumping instance configuration
2026/08/11 07:49:03 WARN: current user is not superuser, not dumping configuration
2026/08/11 07:49:03 INFO: waiting for postprocessing to complete
2026/08/11 07:49:03 FATAL: could not dump configuration files: could not query file contents from settings: ERROR: permission denied for function pg_read_file (SQLSTATE 42501)
I'm looking for a way to backup the things that are possible. I realise that this is a limitation of RDS, but I thinking I'm not the only one that is looking for this. Are there maybe tips/hints?
I'm using AWS RDS, which means you don't get to be the real postgres super user:
I'm looking for a way to backup the things that are possible. I realise that this is a limitation of RDS, but I thinking I'm not the only one that is looking for this. Are there maybe tips/hints?