Fwd: SQL transactions executing from VMSS

2025-04-28 Thread chandan Kumar
the same subnet -- Forwarded message - From: chandan Kumar Date: Tue, Apr 22, 2025 at 4:59 PM Subject: SQL transactions executing from VMSS To: Hi Team, Greetings! Kindly help in below situation, where in I see slowness in response time while I do testing running SQL

SQL transactions executing from VMSS

2025-04-22 Thread chandan Kumar
Hi Team, Greetings! Kindly help in below situation, where in I see slowness in response time while I do testing running SQL transaction in batches from VMSS to postgres database in flexible server(PaaS) 14.17 version. VMSS to IaaS(postgres db on ubuntu) is faster than VMSs to PaaS. 14 version is s

Re: Review my steps for rollback to restore point

2025-03-06 Thread chandan Kumar
nal standbyold.signal* 13.Start Standby 14. Register the standby 15. Check Replication Status On Tue, Mar 4, 2025 at 9:15 PM chandan Kumar wrote: > Hi David, > You catched my word "revert". Thats so encouraging to see how this > community helps.

Re: Review my steps for rollback to restore point

2025-03-04 Thread chandan Kumar
Hi David, You catched my word "revert". Thats so encouraging to see how this community helps. Your answer has cleared my 99% doubt. Thanks again. I wish I also contribute one day . Have a good time! On Tue, Mar 4, 2025 at 9:08 PM David G. Johnston wrote: > On Tuesday, March 4,

Re: Review my steps for rollback to restore point

2025-03-04 Thread chandan Kumar
reaming Replication is for *hot standby*, not backups. > > > On Tue, Mar 4, 2025 at 10:00 AM chandan Kumar > wrote: > >> Thank you for your answer. I want to clarify one more doubt. Can PITR >> be achieved without applying Base Backup >> >> On Tue, Mar 4, 202

Re: Review my steps for rollback to restore point

2025-03-04 Thread chandan Kumar
at 8:37 PM David G. Johnston wrote: > On Tuesday, March 4, 2025, chandan Kumar > wrote: > >> Thank you for your answer. I want to clarify one more doubt. Can PITR >> be achieved without applying Base Backup >> > > The point-in-time you choose must be in the f

Re: Review my steps for rollback to restore point

2025-03-04 Thread chandan Kumar
Thank you for your answer. I want to clarify one more doubt. Can PITR be achieved without applying Base Backup On Tue, Mar 4, 2025 at 3:12 PM Laurenz Albe wrote: > On Tue, 2025-03-04 at 14:26 +0530, chandan Kumar wrote: > > Hello, > > I hope you are doing fine. I need your exp

Review my steps for rollback to restore point

2025-03-04 Thread chandan Kumar
Hello, I hope you are doing fine. I need your expertise on below case study. My current production environment is 2 node streaming replication hosted on Ubuntu VM 's on Azure. I have performed below steps on primary database. 1- Take Base backup 2- Create a restore point using pg_create_restore_p