| 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: | Whole Thread | Raw Message | 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 |