Re: Logical replication - initial data synchronization

2025-02-17 Thread Peter Smith
On Tue, Feb 18, 2025 at 11:25 AM David G. Johnston wrote: > > On Sun, Dec 15, 2024 at 11:10 PM Peter Smith wrote: >> >> On Mon, Nov 25, 2024 at 11:55 AM Peter Smith wrote: >> >> > "When logical replication of a table starts, PostgreSQL typically >> > takes a snapshot of the table's data on the p

Re: Logical replication - initial data synchronization

2025-02-17 Thread David G. Johnston
On Sun, Dec 15, 2024 at 11:10 PM Peter Smith wrote: > On Mon, Nov 25, 2024 at 11:55 AM Peter Smith > wrote: > > > "When logical replication of a table starts, PostgreSQL typically > > takes a snapshot of the table's data on the publisher database and > > copies it to the subscriber." > > > > Thi

Re: Logical replication - initial data synchronization

2024-12-15 Thread Peter Smith
On Mon, Nov 25, 2024 at 11:55 AM Peter Smith wrote: > > On Fri, Nov 22, 2024 at 9:15 AM Bruce Momjian wrote: > > > > On Thu, Oct 31, 2024 at 06:52:34PM -0400, Bruce Momjian wrote: > > > On Fri, Nov 1, 2024 at 09:07:38AM +1100, Peter Smith wrote: > > > > On Fri, Nov 1, 2024 at 2:16 AM Bruce Momji

Re: Logical replication - initial data synchronization

2024-11-24 Thread Peter Smith
On Fri, Nov 22, 2024 at 9:15 AM Bruce Momjian wrote: > > On Thu, Oct 31, 2024 at 06:52:34PM -0400, Bruce Momjian wrote: > > On Fri, Nov 1, 2024 at 09:07:38AM +1100, Peter Smith wrote: > > > On Fri, Nov 1, 2024 at 2:16 AM Bruce Momjian wrote: > > > > > > > > On Fri, Oct 25, 2024 at 11:48:16PM +02

Re: Logical replication - initial data synchronization

2024-11-22 Thread Koen De Groote
Thanks for letting us know, will be happy to see it appear. Regards, Koen De Groote On Thu, Nov 21, 2024 at 11:15 PM Bruce Momjian wrote: > On Thu, Oct 31, 2024 at 06:52:34PM -0400, Bruce Momjian wrote: > > On Fri, Nov 1, 2024 at 09:07:38AM +1100, Peter Smith wrote: > > > On Fri, Nov 1, 2024 a

Re: Logical replication - initial data synchronization

2024-11-21 Thread Bruce Momjian
On Thu, Oct 31, 2024 at 06:52:34PM -0400, Bruce Momjian wrote: > On Fri, Nov 1, 2024 at 09:07:38AM +1100, Peter Smith wrote: > > On Fri, Nov 1, 2024 at 2:16 AM Bruce Momjian wrote: > > > > > > On Fri, Oct 25, 2024 at 11:48:16PM +0200, Koen De Groote wrote: > > > > Number 2 would be perfect, I thi

Re: Logical replication - initial data synchronization

2024-10-31 Thread Bruce Momjian
On Fri, Nov 1, 2024 at 09:07:38AM +1100, Peter Smith wrote: > On Fri, Nov 1, 2024 at 2:16 AM Bruce Momjian wrote: > > > > On Fri, Oct 25, 2024 at 11:48:16PM +0200, Koen De Groote wrote: > > > Number 2 would be perfect, I think. It leaves no doubt at all. > > > > I went with even more direct wordi

Re: Logical replication - initial data synchronization

2024-10-31 Thread Peter Smith
On Fri, Nov 1, 2024 at 2:16 AM Bruce Momjian wrote: > > On Fri, Oct 25, 2024 at 11:48:16PM +0200, Koen De Groote wrote: > > Number 2 would be perfect, I think. It leaves no doubt at all. > > I went with even more direct wording, patch attached. Glad we could > improve this together --- the feedba

Re: Logical replication - initial data synchronization

2024-10-31 Thread Koen De Groote
And my thanks to everyone who took part. Regards, Koen De Groote On Thu, Oct 31, 2024 at 4:16 PM Bruce Momjian wrote: > On Fri, Oct 25, 2024 at 11:48:16PM +0200, Koen De Groote wrote: > > Number 2 would be perfect, I think. It leaves no doubt at all. > > I went with even more direct wording, pa

Re: Logical replication - initial data synchronization

2024-10-31 Thread Bruce Momjian
On Fri, Oct 25, 2024 at 11:48:16PM +0200, Koen De Groote wrote: > Number 2 would be perfect, I think. It leaves no doubt at all. I went with even more direct wording, patch attached. Glad we could improve this together --- the feedback from everyone was helpful. -- Bruce Momjian http

Re: Logical replication - initial data synchronization

2024-10-25 Thread Koen De Groote
Number 2 would be perfect, I think. It leaves no doubt at all. Regards, Koen De Groote On Fri, Oct 25, 2024 at 9:32 AM Laurenz Albe wrote: > On Fri, 2024-10-25 at 17:22 +1100, Peter Smith wrote: > > It seems to me the same clarification could be achieved just by adding > > 1 word ("PostgreSQL")

Re: Logical replication - initial data synchronization

2024-10-25 Thread Laurenz Albe
On Fri, 2024-10-25 at 17:22 +1100, Peter Smith wrote: > It seems to me the same clarification could be achieved just by adding > 1 word ("PostgreSQL") to the original text. e.g. > > BEFORE > Logical replication of a table typically starts with taking a snapshot > of the data on the publisher datab

Re: Logical replication - initial data synchronization

2024-10-24 Thread Peter Smith
On Fri, Oct 18, 2024 at 7:11 PM Laurenz Albe wrote: > > On Thu, 2024-10-17 at 16:00 -0400, Bruce Momjian wrote: > > > 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 > > > >

Re: Logical replication - initial data synchronization

2024-10-18 Thread Laurenz Albe
On Fri, 2024-10-18 at 13:05 +0200, Koen De Groote wrote: > I feel like people don't complain because at some point they figure it out, > and then it's no longer an issue for them. But it was initially, and it did > cost them time. Most people will work with PostgreSQL for their job and > their job

Re: Logical replication - initial data synchronization

2024-10-18 Thread Koen De Groote
> But perhaps active voice can make it even clearer: That would be nice. It immediately clarifies the actor, instead of basically saying "it's expected that an action was performed". To give some context, jobs over the past decade have taught me to work on a default setting of "If it isn't explic

Re: Logical replication - initial data synchronization

2024-10-18 Thread Laurenz Albe
On Thu, 2024-10-17 at 16:00 -0400, Bruce Momjian wrote: > > 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 re

Re: Logical replication - initial data synchronization

2024-10-17 Thread Bruce Momjian
On Thu, Oct 17, 2024 at 09:57:04PM +0200, Koen De Groote wrote: > 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 th

Re: Logical replication - initial data synchronization

2024-10-17 Thread Koen De Groote
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 ob

Re: Logical replication - initial data synchronization

2024-10-17 Thread Bruce Momjian
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 ea

Re: Logical replication - initial data synchronization

2024-10-17 Thread Koen De Groote
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

Re: Logical replication - initial data synchronization

2024-10-16 Thread Bruce Momjian
On Sat, May 18, 2024 at 09:02:11PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/logical-replication-subscription.html > Description: > > I'm reading up on Logical Replication and have been rea

Logical replication - initial data synchronization

2024-05-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/logical-replication-subscription.html Description: I'm reading up on Logical Replication and have been reading the pages in order. The first 2 pages: https://www.postgresql.org/docs/curre