Scaleway Elements Database


What is Scaleway Elements Database?

The Scaleway Elements Database service allows you to create managed database instances, enabling you to focus on development, configuration or fine-tuning of the database engine, rather than administration.


Which services does Scaleway Elements Database manage for me?

Scaleway Elements Database manages:

  • User permissions
  • Backup and restoration of databases
  • Automated backup
  • Event logs
  • Database management
  • Cloning
  • Node Scale-up
  • High-Availability of clusters
  • Custom configurations

Which relational database engines are supported by Scaleway Elements Database?

Scaleway Elements Database currently supports PostgreSQL 9.6, 10, and 11.

Support for MySQL will be available soon.

How can I access my database once it is provisioned?

On the details page of your instance, the IP address and your instance’s port are shown.

It is possible to connect to your instance from any application using this IP address and the login/password of any valid database user. This can be managed from the “users” tab.


Can I upgrade my database engine version?

You can upgrade your database engine version to the next minor release from the management console. A major version upgrade requires your instance’s migration. During the failover to the new version, a short downtime of the instance occurs.


Do I have access to my instance during the upgrade process?

Your instance will not be available during the upgrade to a new version.


Are automatic backups enabled or disabled by default?

Automatic backups are enabled by default. It is possible to disable them at any time in the backup settings of your instance:


How do I list my instances?

You can view a list of your Scaleway Elements Database Instances in the management console. Alternatively, you can use the API to retrieve a list of them.


How do I access my instance?

To access your Database instance, use the psql command-line tool with the following command:

psql -h $IP -p $PORT -U $YOUR_USER -d $DATABASE_NAME

You will have to enter your password to establish the connection. The default $DATABASE_NAME to be used is rdb.


How many Database Instances can I have?

You can have as many Database Instances as your quota allows. Quotas can be increased by contacting the assistance via support ticket.


Will my instance be available while being in maintenance?

Your Database Instance can be partially unavailable during the maintenance window.


Which postgreSQL extensions are available?

The following pg_extensions are available for Scaleway Elements Database:

Extension nameComment
chkpassdata type for auto-encrypted passwords
pgrowlocksshow row-level locking information
sslinfoinformation about SSL certificates
citextdata type for case-insensitive character strings
tablefuncfunctions that manipulate whole tables, including crosstab
uuid-osspgenerate universally unique identifiers (UUIDs)
pg_buffercacheexamine the shared buffer cache
intarrayfunctions, operators, and index support for 1-D arrays of integers
bloombloom access method - signature file based index
hstoredata type for storing sets of (key, value) pairs
isndata types for international product numbering standards
dict_inttext search dictionary template for integers
tsm_system_rowsTABLESAMPLE method which accepts number of rows as a limit
btree_ginsupport for indexing common datatypes in GIN
plpgsqlPL/pgSQL procedural language
tsm_system_timeTABLESAMPLE method which accepts time in milliseconds as a limit
unaccenttext search dictionary that removes accents
pgcryptocryptographic functions
intagginteger aggregator and enumerator (obsolete)
pg_freespacemapexamine the free space map (FSM)
pgstattupleshow tuple-level statistics
pg_trgmtext similarity measurement and index searching based on trigrams
cubedata type for multidimensional cubes
dblinkconnect to other PostgreSQL databases from within a database
fuzzystrmatchdetermine similarities and distance between strings
earthdistancecalculate great-circle distances on the surface of the Earth
dict_xsyntext search dictionary template for extended synonym processing
btree_gistsupport for indexing common datatypes in GiST
pg_visibilityexamine the visibility map (VM) and page-level visibility info
ltreedata type for hierarchical tree-like structures
pg_prewarmprewarm relation data
postgisPostGIS geometry, geography, and raster spatial types and functions
address_standardizer_data_usAddress Standardizer US dataset example
address_standardizerUsed to parse an address into constituent elements. Generally used to support geocoding address normalization step.
postgis_sfcgalPostGIS SFCGAL functions
postgis_topologyPostGIS topology spatial types and functions
postgis_tiger_geocoderPostGIS tiger geocoder and reverse geocoder

What happens if a node is not in optimal condition?

If High-Availability (HA) is enabled, fail-over to a healthy node will be done automatically, and your unhealthy node will be auto-healed. If HA is disabled, your instance will be unavailable.


Is my instance available during backup?

Yes, your instance is available during backup. There will be a performance impact and some actions may not be available.


Can I upgrade my current plan?

You can upgrade your current plan from the management console by using the Scale up feature or via the API by upgrading your node_type.


Is there a limitation on the number of backups I can have?

You can have as many backups as your quota permits. In case you need to increase your quotas, contact our technical assistance by support ticket.


How am I billed for my Database Instances?

Billing of your Database Instance starts at the moment of its creation and ends at deletion of the resource.


Which relational database engines does Scaleway Elements Database support?

PostgreSQL 9.6, 10 and 11 are currently supported.

MySQL support will come at a later date.


What does Scaleway Elements Database manage on my behalf?

On your behalf, the Scaleway Elements Database Service manages the deployment on Compute ressources, OS, system updates, database engine updates and configuration. High-availability and backups are also managed by the service.


How do I backup my database?

If the automatic backup feature is enabled, new backups will be created according to your backup schedule, which can be set on the “instance overview” tab.
It is also possible to launch manual backups by clicking on the Create a backup button from the backups tab.


Is it possible to increase the storage capacity of an already provisioned Database Instance?

You can increase the storage capacity for your Database Instance by using the Scale up function from the management console. It allows you to migrate your database to a more powerful instance.


How do I import data into a Scaleway Elements Database?

To import data into your Scaleway Elements Database, export your data using the pg_dump command in a first step:

pg_dump -h OLD_DB_IP -p OLD_DB_PORT -U OLD_DB_USERNAME -F c -b -v -f "/usr/local/backup/database.backup" DATABASE_NAME

Once the data is exported, import the database using the pg_restore command:

pg_restore -h INSTANCE_IP -p INSTANCE_PORT -U USERNAME -d DATABASE_NAME -v "/usr/local/backup/database.backup"

The different parameters used in the commands represent the following values:

  • -h (--host): IP address of the host
  • -p (--port): Port number of the host
  • -U (--username): PostgreSQL user
  • -F (--format): Format
  • c: c just after a -F means that the format is the binary format specific to postgreSQL
  • -b (--blobs): Specifies the binary string type
  • -v (--verbose)
  • -f (--file): Specifies the file name