Menu
I have restored a snapshot from an existing RDS PostgreSQL database. Now I want to rename that database but can't find how to do it anywhere in the AWS documentation.
Nor can I find how to use the master password (which I expect let's me do it).
584
Amazon RDS currently supports MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server, and Amazon Aurora database engines. When creating a DB instance, some database engines require that a database name be specified. A DB instance can host multiple databases, or a single Oracle database with multiple schemas.
In the upper-right corner of the Amazon RDS console, choose the AWS Region in which you want to create the DB instance. In the navigation pane, choose Databases. Choose Create database. In Choose a database creation method, select Standard Create.
With RDS for MySQL, the answer is no, the master username cannot be changed, presumably because permissions are tied to usernames, and changing the username would leave the database objects with that user as DEFINER stranded without a valid definer.
Logging in with postgres into template1 database and then ALTER DATABASE foo RENAME TO bar; worked
133
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
