Scalingo for PostgreSQL® Overview

PostgreSQL®

PostgreSQL® is a free, open-source, community-managed object-relational database management system focusing on SQL compliance and extensibility. It is well-known for its performances, reliability and robustness, making it a very powerful database, able to hanlde small to huge workloads.

Besides the core features (ACID transactions, views, triggers, foreign keys, …) PostgreSQL® also offers solutions for more specialized usages, such as object storage with the native jsonb format, or for specific dataset kinds, such as geographic datasets with the PostGIS extension or for time-series datasets with TimescaleDB.

Scalingo for PostgreSQL®

Scalingo for PostgreSQL® is our official PostgreSQL® addon. We have several plans available, which you can chose of depending on your needs and budget. As always, a free plan is available for you to test our offer.

Features

All our plans are fully managed. They allow you to enable the available extensions, and allow you to scale your database to another plan.

They also include access to metrics and logs, allowing for quick and easy monitoring and auditing. For more information regarding this topic, please see our dedicated page.

From the security point of view, they all come with a TLS connection and encryption at rest.

In addition to the above, Starter plans include daily on-demand backups, as well as 7-days Point-in-time Recovery (PITR) backups. All backups are encrypted and stored externally. For more information regarding this topic, please see our dedicated page.

For the most demanding environments, our Business plans include a fully-managed cluster made of 2 PostgreSQL® nodes (one primary and one replica) and 2 HAProxy (one primary and one backup) as entrypoint to your cluster private network. The communication between the PostgreSQL® nodes is encrypted. Chosing such a plan drastically lowers the risk of unavailability, be it during a maintenance operation (database upgrade, for example) or because of a platform issue.

Available Version

The latest version of PostgreSQL® available is 14.10.0-1.

This is also the default version when attaching a PostgreSQL® addon to your application.

Available Extensions

Extension Version Description
address_standardizer 3.3.3 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us 3.3.3 Address Standardizer US dataset example
adminpack 2.1 administrative functions for PostgreSQL
amcheck 1.3 functions for verifying relation integrity
autoinc 1.0 functions for autoincrementing fields
bloom 1.0 bloom access method - signature file based index
btree_gin 1.3 support for indexing common datatypes in GIN
btree_gist 1.6 support for indexing common datatypes in GiST
citext 1.6 data type for case-insensitive character strings
cube 1.5 data type for multidimensional cubes
dblink 1.2 connect to other PostgreSQL databases from within a database
dict_int 1.0 text search dictionary template for integers
dict_xsyn 1.0 text search dictionary template for extended synonym processing
earthdistance 1.1 calculate great-circle distances on the surface of the Earth
file_fdw 1.0 foreign-data wrapper for flat file access
fuzzystrmatch 1.1 determine similarities and distance between strings
hstore 1.8 data type for storing sets of (key, value) pairs
insert_username 1.0 functions for tracking who changed a table
intagg 1.1 integer aggregator and enumerator (obsolete)
intarray 1.5 functions, operators, and index support for 1-D arrays of integers
isn 1.2 data types for international product numbering standards
lo 1.1 Large Object maintenance
ltree 1.2 data type for hierarchical tree-like structures
moddatetime 1.0 functions for tracking last modification time
old_snapshot 1.0 utilities in support of old_snapshot_threshold
pageinspect 1.9 inspect the contents of database pages at a low level
pg_buffercache 1.3 examine the shared buffer cache
pg_freespacemap 1.2 examine the free space map (FSM)
pg_prewarm 1.2 prewarm relation data
pg_repack 1.4.8 Reorganize tables in PostgreSQL databases with minimal locks
pg_stat_statements 1.9 track planning and execution statistics of all SQL statements executed
pg_surgery 1.0 extension to perform surgery on a damaged relation
pg_trgm 1.6 text similarity measurement and index searching based on trigrams
pg_visibility 1.2 examine the visibility map (VM) and page-level visibility info
pgcrypto 1.3 cryptographic functions
pgrowlocks 1.2 show row-level locking information
pgstattuple 1.5 show tuple-level statistics
plpgsql 1.0 PL/pgSQL procedural language
postgis 3.3.3 PostGIS geometry and geography spatial types and functions
postgis_raster 3.3.3 PostGIS raster types and functions
postgis_tiger_geocoder 3.3.3 PostGIS tiger geocoder and reverse geocoder
postgis_topology 3.3.3 PostGIS topology spatial types and functions
postgres_fdw 1.1 foreign-data wrapper for remote PostgreSQL servers
refint 1.0 functions for implementing referential integrity (obsolete)
seg 1.4 data type for representing line segments or floating-point intervals
sslinfo 1.2 information about SSL certificates
tablefunc 1.0 functions that manipulate whole tables, including crosstab
tcn 1.0 Triggered change notifications
timescaledb 2.11.1 Enables scalable inserts and complex queries for time-series data (Apache 2 Edition)
tsm_system_rows 1.0 TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time 1.0 TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent 1.1 text search dictionary that removes accents
uuid-ossp 1.1 generate universally unique identifiers (UUIDs)
xml2 1.1 XPath querying and XSLT

Billing

Billing of your PostgreSQL® addon is done on a minute basis.

If your database disk usage exceeds the threshold set on your plan, the over-quota is billed per GB-hour (see our FAQ further details).

The prices are detailed on our dedicated page.


Suggest edits

Scalingo for PostgreSQL® Overview

©2024 Scalingo