Re: Postgres switchover and switchback
| От | Ron |
|---|---|
| Тема | Re: Postgres switchover and switchback |
| Дата | |
| Msg-id | 46af6991-03bf-3843-2640-46a297c9c409@gmail.com обсуждение исходный текст |
| Ответ на | Postgres switchover and switchback (David Jordan <itman73@protonmail.com>) |
| Список | pgsql-admin |
On 5/18/22 09:23, David Jordan wrote:
Async mode, huh?
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; font-size:11.0pt; font-family:"Calibri",sans-serif;}span.EmailStyle19 {mso-style-type:personal-compose; font-family:"Times New Roman",serif;}.MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;}div.WordSection1 {page:WordSection1;} Hi, folks;
I’m a former Oracle database administrator of many years who is new to PostgreSQL. I’m in the process of testing PG v12.7 hot streaming standby’s in async mode, and specifically in the areas of switchover and switchback.
Async mode, huh?
In SQL Server, at least, you must be in synchronous replication mode before doing a (manual or automatic) non-crash failover, to guarantee that all the transaction log data has reached the replica before the switchover.
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
В списке pgsql-admin по дате отправления: