Connect to a cloned database
If you have for some reason cloned a database in the console, you need to do some manually changes on the new database to be allowed to connect to it with your.
- Log in to the database with the old username and password
- Run
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "cloned-user";, to give the new cloned user access to all the old tables. If you have objects outside of tables those also needs to be changed. - Delete the
google-sql-appname-secret from the cluster (if it exists). This allow Naiserator to generate new secrets for the cloned database. - Update your
nais.yaml-file to use the instance name of the cloned database instead of the old ones. - Delete the old database when you are finished.