Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

2024-11-24 Thread Subhash Udata
time. However, if using a cron job for this purpose is a viable option, then that would be acceptable. On Sun, 24 Nov 2024 at 22:27, Ron Johnson wrote: > On Sun, Nov 24, 2024 at 11:52 AM Subhash Udata > wrote: > >> I understand your point and appreciate the clarification. >&g

Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

2024-11-24 Thread Subhash Udata
Dear PostgreSQL Community, I have a production database setup with a primary server and a standby server. The database is currently running on *PostgreSQL 15.0*, and I plan to upgrade both servers to *15.9*. I have the following questions regarding the upgrade and replication process: 1.

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

2024-11-24 Thread Subhash Udata
Pettus wrote: > > > > On Nov 24, 2024, at 09:03, Subhash Udata wrote: > > When we shut down the standby, upgrade it, and then start it back up, > will the replication automatically resume from the primary to the standby? > > Assuming that the standby has access to a

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

2024-11-24 Thread Subhash Udata
, 24 Nov 2024 at 22:11, Adrian Klaver wrote: > On 11/24/24 08:36, Subhash Udata wrote: > > The reason to upgrade from 15.0 to 15.9 is this > > https://www.postgresql.org/support/security/CVE-2024-10979/ > > <https://www.postgresql.org/support/security/CVE-2024-10979/> &

Clarification on CVE-2024-10979 and PostgreSQL Upgrade Necessity Without PL/Perl Usage

2024-11-20 Thread Subhash Udata
ion is not installed or used. Thank you so much for your guidance on this. Best regards, Subhash Udata

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

2024-11-24 Thread Subhash Udata
08:05, Subhash Udata wrote: > > Dear PostgreSQL Community, > > > > I have a production database setup with a primary server and a standby > > server. The database is currently running on *PostgreSQL 15.0*, and I > > plan to upgrade both servers to *15.9*. > > >

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

2024-11-25 Thread Subhash Udata
This would help me. I will try out the pg_rewind and rsync options. On Mon, 25 Nov 2024 at 15:19, Ilya Anfimov wrote: > On Sun, Nov 24, 2024 at 09:35:15PM +0530, Subhash Udata wrote: > >Dear PostgreSQL Community, > > > >I have a production database setup with a

Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10

2024-11-21 Thread Subhash Udata
of my setup. Thank you for your time and support. On Fri, 22 Nov 2024 at 09:39, David G. Johnston wrote: > On Thursday, November 21, 2024, Subhash Udata > wrote: >> >> >> Thank you for your response regarding the affected versions of >> PostgreSQL. I have a follow

Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10

2024-11-21 Thread Subhash Udata
Hi Adrian, Thank you for your response regarding the affected versions of PostgreSQL. I have a follow-up question for clarification: The PostgreSQL documentation mentions that the versions with a fix for CVE-2024-10979 are *17.1, 16.5, 15.9, 14.14, 13.17, and 12.21*. However, your reply states th