PostgreSQL add-on

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.4 or 11.1

PostgreSQL plans

PostgreSQL pricing plans
Name Logs DB size Conn. limit Memory Type VCPUS Price /mo
DEV no 256 MB 5 Shared Shared Shared Free
XS Small Space yes 5 GB 75 1 GB Dedicated 1 17.50 €
XS Medium Space yes 10 GB 75 1 GB Dedicated 1 20.00 €
XS Big Space yes 15 GB 75 1 GB Dedicated 1 30.00 €
S Small Space yes 10 GB 125 2 GB Dedicated 2 35.00 €
S Medium Space yes 15 GB 125 2 GB Dedicated 2 37.50 €
S Big Space yes 20 GB 125 2 GB Dedicated 2 40.00 €
M Small Space yes 20 GB 250 4 GB Dedicated 4 82.00 €
M Medium Space yes 40 GB 250 4 GB Dedicated 4 92.00 €
M Big Space yes 80 GB 250 4 GB Dedicated 4 112.00 €
L Small Space yes 40 GB 500 8 GB Dedicated 6 164.00 €
L Medium Space yes 80 GB 500 8 GB Dedicated 6 184.00 €
L Big Space yes 120 GB 500 8 GB Dedicated 6 204.00 €
XL Small Space yes 80 GB 750 16 GB Dedicated 8 328.00 €
XL Medium Space yes 160 GB 750 16 GB Dedicated 8 368.00 €
XL Big Space yes 320 GB 750 16 GB Dedicated 8 448.00 €
XXL Small Space yes 160 GB 900 32 GB Dedicated 10 796.00 €
XXL Medium Space yes 320 GB 900 32 GB Dedicated 10 892.00 €
XXL Big Space yes 640 GB 900 32 GB Dedicated 10 1084.00 €
XXL Huge Space yes 960 GB 900 32 GB Dedicated 10 1276.00 €

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 mananged 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

PostgreSQL dedicated addons can be encrypted using LUKS with aes-xts.

The passphrase is encrypted in our database using Cipher and Nonce as bytes arrays.

To enable it, you need to ask to our support then we will perform invoicing configuration (more informations about pricing are available through support) and enable the encryption for your addon. Once it's done, you will need to migrate your addon then the encryption at rest will be up.

Edit me on GitHub