Replication questions - read-only and temporary read/write slaves

From: Tiffany Thang <tiffanythang(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Replication questions - read-only and temporary read/write slaves
Date: 2017-12-15 17:03:08
Message-ID: CAB_W-NMAMEHG4qaF2qV9DRLPxUpov5kazgL7ckGG4Emza5AtHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
In PostgreSQL, would it be possible to

1. set up a read-only slave database? The closest solution I could find is
Hot Standby but the slave would not be accessible until after a failover.

2. temporary convert a read-only slave in read-write mode for testing
read/write workloads? Currently in Oracle, we can temporary open our
read-only standby database in read-write mode to occasionally test our
read-write workloads. We would stop the log apply on the standby database,
convert the read-only database to read-write,
perform our read/write test, discard all the changes after testing and
reopen and resync the standby database in read-only mode. Is there a
similar feature in PostgreSQL or are there ways to achieve something close
to our needs?

Thanks.

Tiff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2017-12-15 17:55:39 Re: Replication questions - read-only and temporary read/write slaves
Previous Message Olga Lytvynova-Bogdanova 2017-12-15 15:37:22 pgbench