--database does not work

[BFJonk]

-d // --database does not work properly

My connect fails, see error below:

pgperms --dump --database **warehouse** -U warehouse -h dev1.datawarehouse.network -W <<password>> > pgperms_dev1.yaml

2025/06/03 10:21:05 Failed to dump privileges to a config file: failed to connect to host=dev1.datawarehouse.network user=warehouse database=rdsadmin: server error (FATAL: pg_hba.conf rejects connection for host "<<IP adress>>", user "warehouse", database "**rdsadmin**", SSL encryption (SQLSTATE 28000))

[Jille]

The --database flag only specifies the initial database pgperms connects to. From there it discovers all other databases and connects to them as well to dump their privilegs.

That is counter intuitive, I agree. Changing it would break backwards compatibility, so it is hard to fix. We could add a flag that restricts it to a single database, that would unblock you.

Groeten uit Nijmegen :)

[BFJonk]

Hi Jille,

I guess we will need that, since the database that is currently blocking the code is rdsadmin which seems to be a proprietary AWS database for PostgreSQL RDS databases, that only AWS has access to.

groeten uit Groningen, :-)