pg_basebackup from slave (PITR)

From: Sunil Jadhav <sunilbjpatil(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_basebackup from slave (PITR)
Date: 2021-06-29 06:13:52
Message-ID: CAEQOu1HYZOV3E_DLKRjKkOEAE3H810MOspk25Z6vGYAuEVUuqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Team,

If I have taken pg_basebackup from slave with -Xs options and copied
base.tar and pg_wal .tar file from slave to master and performed the
activity . after starting the service on master the server log showing " system
is ready to accept read only connection"
why ?? why it is not read/write operation serve access only read operation.
is it the only option to promote the servers??
any other way instead of promoting the servers ?

If anyone knows then pls help me..

Thanks in advance.

*Thanks & Regards *

*Mob No : 91-9850910870*
*Sunil Jadhav *

Browse pgsql-admin by date

  From Date Subject
Next Message Vineet Naik 2021-06-29 11:53:55 Re: Comparing 2 data base or 2 tables
Previous Message Julien Rouhaud 2021-06-28 15:58:18 Re: PostgreSQL: A command is already in progress in .NET Windows application