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 <normandavis1...@proton.me> wrote: > > On Saturday, March 2nd, 2024 at 1:24 AM, Abdul Sayeed < > abdulsayee...@gmail.com> wrote: > > Hi, > > When Master server goes down, either you need to promote one of slave node > or configure HA mechanism so that in case of master server goes down it > will automatically promote the slave server as new master. > > Patroni HA tool would be good option for your requirement. > > https://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 <ijbrews...@alaska.edu> > wrote: > >> On Mar 1, 2024, at 11:36 AM, normandavis1990 <normandavis1...@proton.me> >> wrote: >> >> > On Thursday, February 29th, 2024 at 11:38 PM, Israel Brewster < >> ijbrews...@alaska.edu> wrote: >> >> On Feb 29, 2024, at 10:15 AM, David G. Johnston < >> david.g.johns...@gmail.com> wrote: >> >> >> >> On Thursday, February 29, 2024, normandavis1990 < >> normandavis1...@proton.me> wrote: >> >>> >>> What is the difference between High Availability and Replication? >>> >> >> The former is a goal, the later is a technique. >> >> >> Perhaps more specifically: Replication is simply Replicating - or copying >> - the “master” database to one or more “slave” databases, generally in >> real-time such that the slave database clusters are replicas of the master. >> This is good when the master goes down, because you’ll still have one or >> more copies of it available, but by itself it doesn’t keep there from being >> an outage if/when the master goes down. >> >> High Availability layers on top of replication to provide some means of >> ensuring that the database is HIGHLY available, such as an automatic >> failover system or load balancer. Many different options that work in many >> different ways are available to help meet this goal. >> --- >> Israel Brewster >> Software Engineer >> Alaska Volcano Observatory >> Geophysical Institute - UAF >> 2156 Koyukuk Drive >> <https://www.google.com/maps/search/2156+Koyukuk+Drive+Fairbanks+AK+99775-7320?entry=gmail> >> Fairbanks AK 99775-7320 >> <https://www.google.com/maps/search/2156+Koyukuk+Drive+Fairbanks+AK+99775-7320?entry=gmail> >> Work: 907-474-5172 >> cell: 907-328-9145 >> >> >> David J. >> >> >> >> Hi, >> You said "This is good when the master goes down, because you’ll still >> have one or more copies of it available, but by itself it doesn’t keep >> there from being an outage if/when the master goes down.". What does "goes >> down" mean? >> >> >> Exactly what I said - it goes down. Not functioning. Offline. >> Inaccessible. It is not up and running, therefore, it is down. >> >> In Replication mode, if the primary server is shut down, then the data >> will also be lost? >> >> >> No. As I said - and you quoted - “When the master goes down…you’ll still >> have one or more copies of it available”. So no, the data will NOT be lost. >> >> --- >> Israel Brewster >> Software Engineer >> Alaska Volcano Observatory >> Geophysical Institute - UAF >> 2156 Koyukuk Drive >> <https://www.google.com/maps/search/2156+Koyukuk+Drive+Fairbanks+AK+99775-7320?entry=gmail> >> Fairbanks AK 99775-7320 >> <https://www.google.com/maps/search/2156+Koyukuk+Drive+Fairbanks+AK+99775-7320?entry=gmail> >> Work: 907-474-5172 >> cell: 907-328-9145 >> >> > Hi, > Does installing Patroni cause the primary server to stop even for a short > time? >
