Thread: How to know if initial sync of logical subscription is finished
Hello all! When subscribing a slave I need to know when the initial sync is finished. Is there some table I can query to know if the initial sync is finished? Thanks Klaus
Am 26.02.2020 um 17:48 schrieb Klaus Darilion: > Hello all! > > When subscribing a slave I need to know when the initial sync is > finished. Is there some table I can query to know if the initial sync is > finished? No solution to this? At least the replication worker need to be aware if it has finished the initial sync of all tables. So I wonder if this information is somewhere exposed to the user. Thanks Klaus
On Tue, 2020-05-05 at 09:33 +0200, Klaus Darilion wrote: > > When subscribing a slave I need to know when the initial sync is > > finished. Is there some table I can query to know if the initial sync is > > finished? > > No solution to this? At least the replication worker need to be aware if > it has finished the initial sync of all tables. So I wonder if this > information is somewhere exposed to the user. You can see that in the "state" column of "pg_stat_replication", right? Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com