agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feed29.2. Subscription
2+ messages / 2 participants
[nested] [flat]
* 29.2. Subscription
@ 2025-04-30 14:24 PG Doc comments form <noreply@postgresql.org>
2025-04-30 20:51 ` Re: 29.2. Subscription David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2025-04-30 14:24 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: jes.challand@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/logical-replication-subscription.html
Description:
Hi,
https://www.postgresql.org/docs/17/logical-replication-subscription.html#LOGICAL-REPLICATION-SUBSCRI...
Firstly - a big thank you!
As an Oracle DBA, new to PostgreSQL, and therefore learning all the time,
every time I have reason to consult the PostgreSQL documentation, I'm hugely
impressed with the amount, quality, clarity, and accessibility of the
documentation provided. As a documentaion anorak myself, it brings a big
smile to my face so, as I said, thank you!
Today, I happened to be re-doing, and expanding on, labs on logical
replication, covered on a recently-completed course. I browsed through the
online documentation, (smiled), and started following the examples provided
in "29.2.2. Examples: Set Up Logical Replication."
Having created tables on publisher and subscriber, inserted data on the
publisher, and created publication and subscription, I found my results to
be the exact opposite of those indicated here - "Observe that initial table
data is copied, regardless of the publish operation of the publication.".
My subscriber tables t2 and t3 were emply (as though the (publish =
'truncate') rule had in fact been applied to the initial data).
As a result, having inserted the second set of data, my tables now look like
this:
=================
= Publisher
=================
postgres=# INSERT INTO t1 VALUES (4, 'four'), (5, 'five'), (6, 'six');
INSERT 0 3
postgres=# INSERT INTO t2 VALUES (4, 'D'), (5, 'E'), (6, 'F');
INSERT 0 3
postgres=# INSERT INTO t3 VALUES (4, 'iv'), (5, 'v'), (6, 'vi');
INSERT 0 3
postgres=# SELECT * FROM t1;
a | b
---+-------
1 | one
2 | two
3 | three
4 | four
5 | five
6 | six
(6 rows)
postgres=# SELECT * FROM t2;
c | d
---+---
1 | A
2 | B
3 | C
4 | D
5 | E
6 | F
(6 rows)
postgres=# SELECT * FROM t3;
e | f
---+-----
1 | i
2 | ii
3 | iii
4 | iv
5 | v
6 | vi
(6 rows)
=================
= Subscriber
=================
postgres=# SELECT * FROM t1;
a | b
---+-------
1 | one
2 | two
3 | three
4 | four
5 | five
6 | six
(6 rows)
postgres=# SELECT * FROM t2;
c | d
---+---
(0 rows)
postgres=# SELECT * FROM t3;
e | f
---+---
(0 rows)
Have I misunderstood something, perhaps inadvertantly mis-configured some
obscure parameter, or (please no!) is the documentation incorrect?
Thanks in advance for any guidance you're able to offer.
Regards,
Jes
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 29.2. Subscription
2025-04-30 14:24 29.2. Subscription PG Doc comments form <noreply@postgresql.org>
@ 2025-04-30 20:51 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2025-04-30 20:51 UTC (permalink / raw)
To: jes.challand@gmail.com; pgsql-docs@lists.postgresql.org
On Wed, Apr 30, 2025 at 12:51 PM PG Doc comments form <
noreply@postgresql.org> wrote:
>
> https://www.postgresql.org/docs/17/logical-replication-subscription.html#LOGICAL-REPLICATION-SUBSCRI...
>
> Have I misunderstood something, perhaps inadvertantly mis-configured some
> obscure parameter, or (please no!) is the documentation incorrect?
>
>
Testing the documented script against master-ish shows it works as
described (I dislike the fact the example cannot just be copy-pasted in
bulk/chunks but that is a different topic).
You are going to need to show the exact scripts that reproduce the observed
behavior.
The only thing different from a stock installation is setting wal_level =
logical but creating publications without making that change would simply
fail.
David J.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-04-30 20:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-30 14:24 29.2. Subscription PG Doc comments form <noreply@postgresql.org>
2025-04-30 20:51 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox