We are newly moving to postgres database (yet to decide if it would be an on premise one or AWS aurora postgres). However , we want to understand what encryption / decryption techniques are available in the postgres database.
We may have some sensitive/"personal information" (like customer name, account number etc )stored in the database and thus we may need "data at rest encryption", what are the options available here?
Along with that, we want to understand, any other option to store the specific "data attribute" itself in the database by encrypting, so it won't be visible in clear text to anybody and decrypting the same while needed and what would be the performance overhead of those options?