On this page

PostgreSQL

PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and on standards-compliance.

PostgreSQL version

The version currently installed by the add-on is :

  • on shared plans (DEV) : PostgreSQL 11.1
  • on newly created dedicated databases (plans XS Small Space and above) : PostgreSQL 9.6, 10, 11, 12, 13

PostgreSQL plans

PostgreSQL pricing plans
NameLogsDB sizeConn. limitMemoryTypeVCPUSPrice /mo
DEVno256 MB5SharedSharedSharedFree
XXS Small Spaceyes1 GB45512 MBDedicated15.25 €
XXS Medium Spaceyes2 GB45512 MBDedicated16.80 €
XXS Big Spaceyes3 GB45512 MBDedicated17.70 €
XS Tiny Spaceyes2 GB751 GBDedicated113.00 €
XS Small Spaceyes5 GB751 GBDedicated117.50 €
XS Medium Spaceyes10 GB751 GBDedicated120.00 €
XS Big Spaceyes15 GB751 GBDedicated130.00 €
S Small Spaceyes10 GB1252 GBDedicated235.00 €
S Medium Spaceyes15 GB1252 GBDedicated237.50 €
S Big Spaceyes20 GB1252 GBDedicated240.00 €
S Huge Spaceyes50 GB1252 GBDedicated255.00 €
M Small Spaceyes20 GB2504 GBDedicated482.00 €
M Medium Spaceyes40 GB2504 GBDedicated492.00 €
M Big Spaceyes80 GB2504 GBDedicated4112.00 €
L Small Spaceyes40 GB5008 GBDedicated6164.00 €
L Medium Spaceyes80 GB5008 GBDedicated6184.00 €
L Big Spaceyes120 GB5008 GBDedicated6204.00 €
XL Small Spaceyes80 GB75016 GBDedicated8328.00 €
XL Medium Spaceyes160 GB75016 GBDedicated8368.00 €
XL Big Spaceyes320 GB75016 GBDedicated8448.00 €
XXL Small Spaceyes160 GB90032 GBDedicated10796.00 €
XXL Medium Spaceyes320 GB90032 GBDedicated10892.00 €
XXL Big Spaceyes640 GB90032 GBDedicated101084.00 €
XXL Huge Spaceyes960 GB90032 GBDedicated101276.00 €
XXXL Small Spaceyes640 GB120064 GBDedicated121598.00 €
XXXL Medium Spaceyes960 GB120064 GBDedicated121822.00 €
XXXL Big Spaceyes1200 GB120064 GBDedicated121990.00 €

Database Daily Backup and Retention

By default, Clever Cloud performs a free backup every day, with a retention of seven days. Retention and frequency can be customized for Premium customers. Each backup can be found in the add-on dashboard in the web console, along with the credentials.

Migrating from an old database

Some applications require a populated database to run properly. If you want to import your SQL dump, you can use several methods:

  1. Our WebGUI (Adminer).
  2. Command line tool for PostgreSQL administration like psql.
  3. Any PostgreSQL client such as pgAdmin.

Direct access

All our dedicated PostgreSQL databases are served via a proxy. To reduce the latency you can bypass this proxy by generating direct hostname and port for the addon. You can do it by clicking the “Generate direct hostname and port” on the addon dashboard.

This action will add new environment variables to reach the addon without any proxy.

Keep in mind that usage of direct access is a trade-off: when you migrate your addon, you will need to to generate hostname and port again so your application must update these environment while proxy usage changes nothing.

Default extensions

Every PostgreSQL database managed by Clever Cloud comes with the following default extensions: adminpack, autoinc, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, file_fdw, fuzzystrmatch, hstore, insert_username, intagg, intarray, isn, lo, ltree, moddatetime, pageinspect, pg_buffercache, pgcrypto, pg_freespacemap, pgrowlocks, pg_stat_statements, pgstattuple, pg_trgm, plcoffee, plls, plv8, postgis, postgis_tiger_geocoder, postgis_topology postgres_fdw, refint, seg, sslinfo, tablefunc, tcn, timetravel, unaccent, "uuid-ossp", xml2

Encryption at rest

Encryption at rest is available on PostgreSQL. You can have more information on the dedicated page

Automatic vacuuming

Autovacuum is automatically enabled on PostgreSQL add-ons.
The autovacuum will proceed when a given percentage of rows of a table will be updated/inserted/deleted.
Usually this threshold is set to 20%.