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
>
>
>
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 |