Skip to main content
Gå til innhold

Databases

PostgreSQL on AWS​

PostgreSQL is an object-relational database. We provide a shared database based on the AWS RDS service. Amazon RDS runs a primary DB Instance and synchronously replicates the data to a standby instance in a different Availability Zone (AZ).

Access to the service and creation of databases and users is done by the platon team. All you need to do is place an order by registering via a sharepoint form, which is then dispatched to Sikts Service Center.

SLA​

We run a Multi-AZ DB Instance. See Amazon RDS Service Level Agreement for detailed information for this set-up.

Backup​

A backup is done daily with storage volume snapshot and retained for the last 30 days. It is possible to do a point in time restore within this retention period.

For large databases the restore process can take a while.

If the entire RDS instance needs to be restored to the latest available backup, up to 5 minutes of data can be lost.

Postgres versions and upgrades​

The AWS RDS currently runs Postgres v13. We will upgrade to new major versions in accordance with AWS supported versions. This will be announced well before the actual upgrade.

Additional notification about downtime during upgrades will be sent to this list of database owners.

Features and supported use cases​

This shared RDS are meant for those that do not wish to maintain their own database. For each DB we provide:

  • A Read/Write user
  • An optional Read-Only user
  • The default RDS extensions for the running Postgres version (see below for a list of these extensions)

It is important to understand what this shared instance is not suitable for. We do not support any of the following requirements:

  • Large DBs (More than a couple of hundred GBs)
  • High performance requirements
  • Any need for administrative access outside of the database itself
  • A large number of users/roles with complex/granular access
  • Any Postgres extension besided the default ones provided by AWS RDS for Postgres
  • You need to stay on a particular Postgres version

For these kind of requirements a dedicated AWS RDS will be more suitable.

Postgres extensions​

info

We only provide the extensions that are available in AWS RDS by default.

Extensions need to be enabled for a given database. Specify any desired extentions when ordering a DB or contact Platon to enable it. See Postgres 13 Extensions for available extentions.