I would still add that the snapshot and data copying is handled by postgres itself. That was the big question I was stuck with:"Who is taking this snapshot? Do I have to do it? Will they explain how?"
Because it's left in the middle who does it. Once you know how logical replication works, it's obvious, re-reading the documentation I know what to expect, but that's only because I've already done it a few time snow. As someone just starting and reading the documentation, it was a stumbling block for me. To me, > When logical replication of a table typically starts, a snapshot is > taken of the table's data on the publisher database and copied to the > subscriber Does not clarify that. It's the reason I created this mail: I would like it stated explicitly that the database process takes care of this for us. Regards, Koen De Groote On Thu, Oct 17, 2024 at 3:08 PM Bruce Momjian <br...@momjian.us> wrote: > On Thu, Oct 17, 2024 at 10:59:51AM +0200, Koen De Groote wrote: > > Hello Bruce, thanks for picking this up. > > > > Personally, I would make explicit mention of the fact that creating the > > snapshot and copying the data is taken care of by Postgres itself. Those > are > > the points that had me confused early on, wondering if I had to perform > the > > copy once the snapshot was ready. > > Updated patch attached. I tried to tighten up the wording and add more > detail. I didn't see the point in repeating the same paragraph later on > so I removed it. > > -- > Bruce Momjian <br...@momjian.us> https://momjian.us > EDB https://enterprisedb.com > > When a patient asks the doctor, "Am I going to die?", he means > "Am I going to die soon?" >
