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://avnadmin:foo@replica.demopg.demoprj.aivencloud.com:10546/defaultdb?sslmode=require
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=>
defaultdb=> SELECT * FROM pg_is_in_recovery();
pg_is_in_recovery
— — — — — — — — — -
t
(1 row)

Try PostgreSQL 9.6 for free in Aiven

--

--

--

Your database in the cloud, www.aiven.io

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
Aiven

Aiven

Your database in the cloud, www.aiven.io

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