# Connect to a Database To connect to your DB instance, you need to retrieve your credentials: ```bash exo dbaas -z de-fra-1 show test-pg --uri ``` Output: ```bash postgres://avnadmin:AVNS_SbyJOj29FaxJHa4XJEj@test-pg-exoscale-980a712f-5c76-4ec4-a3bc-4e4e442deef2.aivencloud.com:21699/defaultdb?sslmode=require ``` The status of your DB instance should have changed from **rebuilding** after the `create` command to **running**. To check: ```bash exo dbaas show test-pg -z de-fra-1 ``` Output: ```bash ┼───────────────────────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼ │ DATABASE SERVICE │ │ ┼───────────────────────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼ │ Zone │ de-fra-1 │ │ Name │ test-pg │ │ Type │ pg │ │ Plan │ hobbyist-2 │ │ Disk Size │ 8.0 GiB │ │ State │ rebuilding │ │ Creation Date │ 2022-06-09 08:26:13 +0000 UTC │ │ Update Date │ 2022-06-09 08:27:25 +0000 UTC │ │ Nodes │ 1 │ │ Node CPUs │ 2 │ │ Node Memory │ 2.0 GiB │ │ Termination Protected │ true │ │ Maintenance │ sunday (11:52:43) │ │ Version │ 14 │ │ Backup Schedule │ 08:19 │ │ URI │ postgres://avnadmin:xxxxx@test-pg-exoscale-980a712f-5c76-4ec4-a3bc-4e4e442deef2.aivencloud.com:21699/defaultdb?sslmode=require │ │ IP Filter │ 1.2.3.4/32 │ │ Components │ │ │ │ pg test-pg-exoscale-980a712f-5c76-4ec4-a3bc-4e4e442deef2.aivencloud.com:21699 route:dynamic usage:primary │ │ │ pgbouncer test-pg-exoscale-980a712f-5c76-4ec4-a3bc-4e4e442deef2.aivencloud.com:21700 route:dynamic usage:primary │ │ │ │ │ Users │ n/a │ ┼───────────────────────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼ ``` You can now connect to the database engine: ```bash psql ``` Output: ```bash postgres://avnadmin:AVNS_SbyJOj29FaxJHa4XJEj@test-pg-exoscale-980a712f-5c76-4ec4-a3bc-4e4e442deef2.aivencloud.com:21699/defaultdb?sslmode=require psql (9.2.24, server 14.3) WARNING: psql version 9.2, server version 14.0. Some psql features might not work. SSL connection (cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256) Type "help" for help. defaultdb=> \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- _aiven | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =T/postgres + | | | | | postgres=CTc/postgres defaultdb | avnadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (4 rows) defaultdb=> ``` #### Other Commands In addition to the creation commands listed above, you will find: - List: `exo dbaas list` - Delete: `exo dbaas delete test-pg -z de-fra-1` The update command will enable you to adjust parameters of a DB instance. ##### Disable Termination Protection ```bash exo dbaas update test-pg -z de-fra-1 --termination-protection=false ``` Output: ```bash Updating Database Service "test-pg"... ┼───────────────────────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼ │ DATABASE SERVICE │ │ ┼───────────────────────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼ │ Zone │ de-fra-1 │ │ Name │ test-pg │ │ Type │ pg │ │ Plan │ hobbyist-2 │ │ Disk Size │ 8.0 GiB │ │ State │ running │ │ Creation Date │ 2022-06-09 08:26:13 +0000 UTC │ │ Update Date │ 2022-06-09 08:40:16 +0000 UTC │ │ Nodes │ 1 │ │ Node CPUs │ 2 │ │ Node Memory │ 2.0 GiB │ │ Termination Protected │ false │ │ Maintenance │ sunday (11:52:43) │ │ Version │ 14.3 │ │ Backup Schedule │ 08:19 │ │ URI │ postgres://avnadmin:xxxxx@test-pg-exoscale-980a712f-5c76-4ec4-a3bc-4e4e442deef2.aivencloud.com:21699/defaultdb?sslmode=require │ │ IP Filter │ 1.2.3.4/32 │ │ Components │ │ │ │ pg test-pg-exoscale-980a712f-5c76-4ec4-a3bc-4e4e442deef2.aivencloud.com:21699 route:dynamic usage:primary │ │ │ pgbouncer test-pg-exoscale-980a712f-5c76-4ec4-a3bc-4e4e442deef2.aivencloud.com:21700 route:dynamic usage:primary │ │ │ │ │ Users │ avnadmin (primary) │ ┼───────────────────────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼ ``` It is now possible to delete the instance: ```bash exo dbaas -z de-fra-1 delete test-pg ``` Output: ```bash [+] Are you sure you want to delete Database Service "test-pg"? [yN]: y ✔ Deleting Database Service "test-pg"... 0s ``` Otherwise, you will get the following error: ```bash exo dbaas -z de-fra-1 delete test-pg ``` Output: ```bash [+] Are you sure you want to delete Database Service "test-pg"? [yN]: y ✔ Deleting Database Service "test-pg"... 0s error: Delete "https://api-de-fra-1.exoscale.com/v2/dbaas-service/test-pg": invalid request: The service is protected against termination and shutdown. Remove termination protection first. ``` Other global parameters currently supported include: - Maintenance day of the week - Maintenance time slot