I'm still new to PostgreSQL and reading as I go, but so far haven't found exactly what I'm looking for (though there are similar things and maybe I'm lacking on the terminology).
We have an RDS instance in AWS (PostgreSQL), the data is encrypted using the AWS KMS. I want to create a new RDS instance, which I want to encrypt using a new custom key, then migrate all the data from the old instance to the new one.
The problem is that the way AWS works, the private key is stored away and hidden from me, so I can't decrypt the data and then move it to the new instance, the solution I'm thinking about is use some sort of database client, maybe write a query or a dump of the data and then push it to the new instance.
Has anyone dealt with such an issue before? In PostgreSQL terms, how can I get all the data using a client or something and then push it to the new instance?
I'm going to install pgadmin and see if that helps, any suggestions would be most welcomed.