Re: High Availability and Replication

2024-03-02 Thread Abdul Sayeed
Hi, Not required. Thanks & Regards, Abdul Sayeed PostgreSQL DBA Postgres Professional Certified Skype: abdul.sayeed24 On Sat, 2 Mar 2024 at 12:21 PM, normandavis1990 wrote: > > On Saturday, March 2nd, 2024 at 1:24 AM, Abdul Sayeed < > abdulsayee...@gmail.com> wrote: >

Re: High Availability and Replication

2024-03-01 Thread Abdul Sayeed
://patroni.readthedocs.io/en/latest/README.html Hope this helps. Thanks & Regards, Abdul Sayeed PostgreSQL DBA On Sat, 2 Mar 2024 at 2:15 AM, Israel Brewster wrote: > On Mar 1, 2024, at 11:36 AM, normandavis1990 > wrote: > > > On Thursday, February 29th, 2024 at 11:38 PM, Israel B

Re: Postgres to edb AS, need conversion?

2022-11-03 Thread Abdul Sayeed
After migration you need to execute below command from SQL Prompt: vacuum (verbose, analyze); --> to update statistics. Rest is good. Regards, Abdul Sayeed On Thu, Nov 3, 2022 at 3:15 PM milist ujang wrote: > Hi all, > > Anyone have experiences or someone from edb can guid

Re: Patroni & PostgreSQL issue

2022-07-20 Thread Abdul Sayeed
. Regards, Abdul Sayeed On Wed, Jul 20, 2022 at 5:29 PM Sankar, Uma (Uma) wrote: > Hi All, > > > > This is regarding the Postgres HA working with patroni in 3 node setup, we > have an issue with the primary because a few database files were deleted > manually so performed a sw

Re: It is possible to force periodically switch xlog?

2020-04-01 Thread Abdul Sayeed
Hi Edson, You can switch by using below command below PG 10. Select pg_switch_xlog(); And there is no parameter present to switch it. Regards, Abdul Sayeed On Thursday, April 2, 2020, Edson Richter wrote: > I would like to know if there is any parameter I can set to force postgres &