Re: WAL Replication query
| От | Laurenz Albe |
|---|---|
| Тема | Re: WAL Replication query |
| Дата | |
| Msg-id | 88faef33e966796226022d6e7f3e32ad6c59fcfd.camel@cybertec.at обсуждение исходный текст |
| Ответ на | WAL Replication query (KK CHN <kkchn.in@gmail.com>) |
| Ответы |
RE: [External] Re: WAL Replication query
|
| Список | pgsql-admin |
On Tue, 2022-11-01 at 11:25 +0530, KK CHN wrote: > I am trying WAL replication,the setup is working with a primary and Standby server. > > Query is : When the primary crashes due an unforeseen reason, > what may happen to the uncommitted transactions at primary ? Their effects remain invisible. > Those won't replicate to the standby right ? They may be replicated, but their effects will remain invisible there too. > How much data loss occurs in this case ? Data loss? I don't understand. There is no data loss with replication. If an incomplete transaction is rolled back, that is no data loss. > What is the mechanism to overcome this uncommitted transaction loss due to primary > server crash which is not replicated to the standby server ? I don't understand. Are you perhaps talking about failover? Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
В списке pgsql-admin по дате отправления: