Skip to content

Options when using AWS RDS? #167

Description

@dnmvisser

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions