Re: how to fail over slave to master

From: Amine Tengilimoglu <aminetengilimoglu(at)gmail(dot)com>
To: Pepe TD Vo <pepevo(at)yahoo(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: how to fail over slave to master
Date: 2020-12-28 18:37:44
Message-ID: CADTdw-yhihjbQ7VEvKtqdBEUV9XEbd6fq+JfHtesF3f+Pk7Fzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

You need to promote standby server, you can do that pg_ctl promote command.
And also you need to use pg_rewind command for setup the old master as a
standby server. So you can start with investigate pg_ctl promote and
pg_rewind...

28 Ara 2020 Pzt 21:29 tarihinde Pepe TD Vo <pepevo(at)yahoo(dot)com> şunu yazdı:

> Hello,
>
> I have a problem with my master's Postgresql service. I can't start up
> Postgresql, something corrupted and the Postgresql service is down. The
> slave is still up and running, I wonder how to turn slave to primary and
> fixing the master server. Once the master server is fixed, how can I fail
> it back?
>
> Please advise.
>
>
>
>
> *Bach-Nga*No one in this world is pure and perfect. If you avoid people
> for their mistakes you will be alone. So judge less, love, and forgive more.[image:
> Emoji][image: Emoji][image: Emoji]
> To call him a dog hardly seems to do him justice though in as much as he
> had four legs, a tail, and barked, I admit he was, to all outward
> appearances. But to those who knew him well, he was a perfect gentleman
> (Hermione Gingold)
>
> **Live simply **Love generously **Care deeply **Speak kindly.
> *** Genuinely rich *** Faithful talent *** Sharing success
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Pepe TD Vo 2020-12-28 18:54:59 Re: how to fail over slave to master
Previous Message Pepe TD Vo 2020-12-28 18:29:44 how to fail over slave to master