Steps to place standby database in read write

From: Prashanth Reddy <prash4783(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Steps to place standby database in read write
Date: 2017-07-18 01:27:22
Message-ID: CANN5QLbdhn9e66riKBWbONSL=oFYUdF195pJHifoNkSUhQWu4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-in-general pgsql-novice pgsql-sql pgus-general

Hi,
Can you please provide me the steps as how to stop the replication and open
the standby database for read write and put the standby database back in
sync with production.
--
Sent from Gmail Mobile

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Luan Huynh 2017-07-18 07:04:15 ORDER BY too slow in Foreign Table using postgres_fdw
Previous Message Joshua D. Drake 2017-07-17 21:22:12 Re: web pgadmin API

Browse pgsql-in-general by date

  From Date Subject
Next Message Bhuvana vv 2017-07-18 09:13:47 PgAdmin Table Data View
Previous Message Patel Akash 2017-07-10 10:12:36 Query : "SELECT reltuples FROM pg_class WHERE oid = 'schema_name.table_name'::regclass;"

Browse pgsql-novice by date

  From Date Subject
Next Message Prashanth Reddy 2017-07-18 14:58:12 Re: Steps to place standby database in read write
Previous Message Aleksey Tsalolikhin 2017-07-15 16:18:48 Re: Bulk load billions of records into Postgres cluster

Browse pgsql-sql by date

  From Date Subject
Next Message Luan Huynh 2017-07-18 03:06:56 Filter JSONB on Foreign Table in postgres_fdw
Previous Message Kanjibhai.Kanzaria 2017-07-13 13:53:01 Function with table Valued Parameters execution issue

Browse pgus-general by date

  From Date Subject
Next Message Prashanth Reddy 2017-07-18 14:58:12 Re: Steps to place standby database in read write
Previous Message Bruce Momjian 2016-10-19 17:47:20 Re: journaled FS and and WAL