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.

Create a PostgreSQL database

  1. Navigate to Console

  2. Select your project and environment

  3. Click Add Database button

    Database

  4. Select database type, name and version

    Database

  5. Deploy the database using Action deploy button

    Database

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.

Versions

Qovery supports the following PostgreSQL versions.

Cloud providerVersionContainer supportedManaged supported
AWS13YesYes
AWS12YesYes
AWS11YesYes
AWS10YesYes
AWS9YesYes
Digital Ocean13YesSoon
Digital Ocean12YesSoon
Digital Ocean11YesSoon
Digital Ocean10YesSoon
Digital Ocean9YesSoon
Scaleway13YesYes
Scaleway12YesYes
Scaleway11YesYes
Scaleway10YesYes
Scaleway9YesNo

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

Database Version

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:

Database Accessibility

Resources

CPU

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

Database CPU

Memory

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

Database Memory

Storage

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

Database Storage

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

  1. Navigate to Console

  2. Select your environment and database

  3. In database overview, click on Action remove button

    Database Remove