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
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 |