Aiven PostgreSQL read-only replicas

What are master and standby nodes?

What is the difference between having 0, 1 or even 2 standby nodes?

Using standby nodes for read-only queries

Replica Usage

$ psql postgres://
psql (9.6.1, server 9.6.1)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)Type “help” for help.
defaultdb=> SELECT * FROM pg_is_in_recovery();
— — — — — — — — — -
(1 row)

Try PostgreSQL 9.6 for free in Aiven




Your database in the cloud,

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store


Your database in the cloud,

More from Medium

Open Source is fun — no need to be shy

Triggering Airflow Workflows After Data Modification in Amazon Aurora

Amazon Aurora integration with AWS Lambda which calls Apache Airflow REST API.

Writing Data Integration Software with the Conduit REST API

Using Timeplus and Redpanda for low latency, real-time streaming analytics