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

Clarify old WAL files cannot be removed until they are summarized

2024-10-17 Thread Fujii Masao
Hi, The documentation in wal.sgml explains that old WAL files cannot be removed or recycled until they are archived (when WAL archiving is used) or replicated (when using replication slots). However, it did not mention that, similarly, old WAL files are also kept until they are summarized if WAL

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

pg_prewarm can handle indexes

2024-10-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/pgprewarm.html Description: IMHO, in the pg_prewarm documentation, it should be mentioned that it can prewarm indexes as well, if given an index name as input. https://www.postgresql.org

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: A minor bug in doc. Hovering over heading shows # besides it.

2024-10-17 Thread Daniel Gustafsson
> On 17 Oct 2024, at 01:24, David Rowley wrote: > > On Thu, 17 Oct 2024 at 11:19, Bruce Momjian wrote: >> Where are we on this? I still see "#". > > I was hoping for some voting for or against my patch or the general idea of > it. Sorry for the delay, this fell off the inbox-radar. I am in f