PostgreSQL

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

Add a PostgreSQL database to your application

To add a dedicated PostgreSQL instance to your existing application, simply add these lines to your configuration file:

.qovery.yml
application:
...
databases:
- type: postgresql
version: 12
name: my-postgresql
  • name: select a name for your database
  • version: choose the version of the database
  • type: the database engine (postgresql in this case)

Supported versions

Here are the PostgreSQL versions supported by Qovery.

VersionSupported
12Yes
11Yes
10Yes

Qovery does not support a new version of PostgreSQL yet? Contact us

Get access to your PostgreSQL database

To get the connection information of your database, you can use the CLI:

qovery application env list -c
OUTPUT
$ qovery application env list -c
SCOPE | KEY | VALUE
--------------+---------------------------------------------------------------+-----------
BUILT_IN | QOVERY_BRANCH_NAME | master
BUILT_IN | QOVERY_IS_PRODUCTION | true
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_NAME | my-postgresql
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_TYPE | postgresql
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_VERSION | 12
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_CONNECTION_URI | <hidden>
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_CONNECTION_URI_WITHOUT_CREDENTIALS | <hidden>
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_HOST | <hidden>
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_FQDN | <hidden>
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_PORT | <hidden>
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_USERNAME | <hidden>
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_PASSWORD | <hidden>
BUILT_IN | QOVERY_DATABASE_MY_POSTGRESQL_DATABASE | postgresql

In the output, you get all data you need to use the database. Those environment variables are available in the runtime of your application.

Show PostgreSQL database status

To know more about your database status, run:

qovery status -c
OUTPUT
DATABASE NAME | STATUS | TYPE | VERSION | ENDPOINT | PORT | USERNAME | PASSWORD | APPLICATIONS
----------------+---------+---------+---------+----------+----------+----------+----------+-----------------
my-mongo | running | postgresql | 12 | <hidden> | <hidden> | <hidden> | <hidden> | simple-example

Delete your PostgreSQL database

To delete a database, you have to:

  • Remove it from the configuration file, commit and push.
  • Delete it manually (for security purpose) through the Qovery web interface.

PostgreSQL backup

Daily backups for your PostgreSQL database are automatically done for Production environments.