PostgreSQL

Before you begin, this documentation assumes the following:

You have created an Environment.

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.

Check out this video guide to create and deploy your first database

Create a PostgreSQL database

1. Navigate to Console

2. Select your project and environment

3. Click Add Database button

   

4. Select database type, name and version

   

5. Deploy the database using Action deploy button

   

How was it? Did this tutorial work?  Yes  No

Configuration

General

Modes

Databases can operate in two modes:

• Managed
• Container

Managed databases are perfect for production - they are provided and managed by major cloud providers like AWS to make sure your production data is well managed.

Container databases are managed by Qovery as Docker containers with attached persistent storage. They are perfect for development and testing, as they are significantly cheaper than services provided by cloud providers.

Managed databases are supported only in [paid plans][urls.qovery_pricing], it's not available in the `Community` version.

Versions

Qovery supports the following PostgreSQL versions.

Cloud provider	Version	Container supported	Managed supported
AWS	12	Yes	Yes
AWS	11	Yes	Yes
AWS	10	Yes	Yes
AWS	9	Yes	Yes
Digital Ocean	12	Yes	Soon
Digital Ocean	11	Yes	Soon
Digital Ocean	10	Yes	Soon
Digital Ocean	9	Yes	Soon
Scaleway	12	Yes	No
Scaleway	11	Yes	No
Scaleway	10	Yes	No
Scaleway	9	Yes	No

You can adjust the version of your database in General section of database settings:

Accessibility

To make your database secure, you may decide not to expose it publicly.

• Public access will make your database accessible via the public network
• Private access will make your database accessible only by applications in your environment

You can configure the accessibility settings in General section of database settings:

Resources

CPU

To tweak CPU configuration of your database, navigate to Resource section in database settings:

Memory

To tweak RAM configuration of your database, navigate to Resource section in database settings:

Storage

To tweak the disk space assigned to your database, navigate to Resource section in the database settings:

Credentials

To access your database in your application, link it to your database. Qovery will inject all environment variables and secrets you need to connect your app to your database. To see all the secrets injected for your application, see database secrets section.

Delete your PostgreSQL instance

Delete action drops the service and its data!

1. Navigate to Console

2. Select your environment and database

3. In database overview, click on Action remove button

   

How was it? Did this tutorial work?  Yes  No