Completely automatic setup and maintenance

Aiven hosted Postgres services are launched by a push of a button and non-functional nodes are automatically replaced with new ones. This is a true Database-as-a-Service, you do not need to worry about the administrative details of setting the service up.

Get your database running fast

It only takes a few minutes to sign-up, pick a service plan and get a database service running. Databases are launched using the Aiven self-service console with a couple clicks to provision and automatically set up the new database. Databases are typically available within a few minutes of the provisioning request.

High-Availability

Aiven PostgreSQL Business and Premium plans have replica nodes in hot standby mode that will automatically take over a failed master node in case the master node fails reducing a possible service outage in case of a system failure. Immediately following a failure Aiven automatically starts restoring the service to the configured service level, provisioning new replica nodes.

Fault recovery

The Startup and Hobbyist plans which do not have replica nodes are also automatically restored to their last good state without requiring user intervention should a failure occur. The perceived outage in such a situation depends on the database size.

Automatic real-time backups to a remote location

Full database backups are periodically uploaded to extremely fault resilient cloud-specific object stores. Incremental changes are streamed to standby nodes in real-time and periodically to backups as well.

Seamlessly upgrade from a single-node starter plan to a geo-replicated premium setup without downtime

You can smoothly upgrade to a larger plan with High Availability and better performance without causing any downtime. Updating the service plan is implemented by performing a rolling upgrade to new, larger virtual machines.

Migrate databases between clouds without downtime

Move your database service between regions or to different clouds altogether at the push of a button, without downtime. Migrating the service from one cloud to another is implemented by performing a rolling upgrade to the new cloud.

Real-time view of your query patterns

View your query patterns in real-time in the Web. Pin point your slow or unexpectedly often run queries.

Powerful REST API and command-line tools

Besides using the Web-interface you can control your database services through our command line client or by directly calling our REST API.

Support for multiple users and databases

Aiven allows creating an unlimited number of logical databases and database users per service instance. Useful when you want to separate different applications data.

Fork databases without stressing the production system

Fork your database for reporting or testing without stressing your production system. This is especially useful when you want to test against your production data without affecting your actual production service.

Restore from backups to any point in time (PITR)

Restore your data to any point in time. Useful when you need to return to the time before a problem occurred or want to see how the data looked at some particular moment in the past. The time range available for point-in-time-recovery depends on the service plan.

Connection pooling

PGBouncer based connection pooling allows you to have thousands of PostgreSQL connections without slowing down the server. You can create your own pools with session, transaction or statement level connection pooling.

Always the latest Postgres versions

Aiven PostgreSQL always allows you to use the very latest PostgreSQL features. PostgreSQL major versions 9.5 and 9.6 are both available for use.

Popular extensions available, including PostGIS and PL/v8

Aiven PostgreSQL comes with batteries included. Whether you want to use common GIS functions provided by PostGIS or would like to use Javascript functions Aiven PostgreSQL has an extension for you.

Data always encrypted in transit and at rest

With Aiven PostgreSQL your data is always encrypted whether it's being transferred or when it's at rest on disk. We enforce the use of TLS for connections and encrypt the data on disk.

Run on dedicated virtual machines, no shared resources

Always run on dedicated virtual machines, never sharing resources with other users. Provides security isolation from other users.

Automatic security update deployment

Security updates are deployed promptly and you never have to worry about patching your Postgres or operating system vulnerabilities again.

Network security

All service nodes are firewalled and users are only allowed to connect from IP addresses or address ranges specified by you.

100% service level guarantee

Aiven takes great pride in providing highly fault-resilient database services with automatic recovery in case of system failures. If an outage is caused by an apparent failure in the Aiven software, users of Startup, Business and Premium plans are provided with free usage credits covering 30 times the outage period.

Outage credits are not provided in case the used cloud provider terminates virtual machines used by Aiven to implement the service because of a planned or emergency maintenance event. In such cases the replicated Business and Premium plans continue to operate without outages, but Startup and Hobbyist plans will be unavailable while the service is rebuilt on new virtual machines. Please note that Hobbyist plans are not covered by the 100% service level guarantee.

Support options

Aiven operates 24/7/365 monitoring of the Aiven service and Aiven personnel will be automatically alerted to any service anomalies. Aiven personnel will rapidly address any issues in system operations requiring manual intervention.

Aiven's support staff are contactable over email at support@aiven.io and will answer any questions regarding the Aiven service during the ongoing or next business day.

Support contracts providing higher levels of response times plus alternative contact methods (phone, IM) are available on request. Please contact sales@aiven.io for more details.