pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17221: Data sending resume
2+ messages / 2 participants
[nested] [flat]
* BUG #17221: Data sending resume
@ 2021-10-11 16:17 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2021-10-11 16:17 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: nagandllamohan@gmail.com
The following bug has been logged on the website:
Bug reference: 17221
Logged by: Mohan nagandlla
Email address: nagandllamohan@gmail.com
PostgreSQL version: 13.3
Operating system: Alpine:3.13
Description:
HI team ,
I Have query that is let we assume I have HA postgres setup by repmgr. Now i
was copying the data from local file in size 10 GB to database. In mean
while let we assume master was down so before the master node down the data
5 GB sent if I again try to send the data to new master isn't the database
will collect the remining 5 GB data only or it will start from beginning of
the file again?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17221: Data sending resume
@ 2021-10-11 21:38 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2021-10-11 21:38 UTC (permalink / raw)
To: nagandllamohan@gmail.com <nagandllamohan@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Monday, October 11, 2021, PG Bug reporting form <noreply@postgresql.org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17221
> Logged by: Mohan nagandlla
> Email address: nagandllamohan@gmail.com
> PostgreSQL version: 13.3
> Operating system: Alpine:3.13
> Description:
>
> HI team ,
> I Have query that is let we assume I have HA postgres setup by repmgr. Now
> i
> was copying the data from local file in size 10 GB to database. In mean
> while let we assume master was down so before the master node down the data
> 5 GB sent if I again try to send the data to new master isn't the database
> will collect the remining 5 GB data only or it will start from beginning of
> the file again?
>
I presume when the new master is promoted all transactions on the old
master were already aborted and new transactions begun. The new master
will start the data copy from scratch as part of the new transaction. It
has no way of knowing that this new transaction and the old one are in any
way related.
David J.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-10-11 21:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-10-11 16:17 BUG #17221: Data sending resume PG Bug reporting form <noreply@postgresql.org>
2021-10-11 21:38 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox