0

I have setup a logical replication in PostgreSQL and have made the changes in postgres.conf where i have set wal_level = 'logical'

The create subscription part works well but the create subscriber hangs and does not show any errors in the logs

Below is the command I am using to create a subscription

  CREATE SUBSCRIPTION SUB_NL_LIVE_NEW
  CONNECTION 'host=x.x.x.x port=5432 user=postgres password=xxx dbname=main sslmode=require'
  PUBLICATION NL_LIVE;

The above command hangs and nothing in the logs show. I have the following log settings

log_error_verbosity = verbose
log_min_messages = debug1
  1. any help on what could be going wrong or how can i investigate this further
  2. what is the recommend way to cleanup Publisher? does deleting the publication like below cleanup everything?
DROP PUBLICATION pub_name

Any help here would be really great, Thanks in advance.

Improve this question
5
  • 2
    Trying creating a replication slot manually at publisher side and specify it when creating subscription. Commented Sep 3, 2024 at 1:49
  • Are both databases in the same database cluster? Commented Sep 3, 2024 at 2:21
  • No the databases on two different servers Commented Sep 3, 2024 at 7:31
  • the replication slot gets created correctly on the publisher end @goodfella Commented Sep 3, 2024 at 7:31
  • I think you can check if the connection is working by the number of tables being published (for example, only one table is published). Commented Sep 4, 2024 at 3:47
Related questions
1
Postgres Logical Replication: Replication slot, Subscriber and Publisher Creation Order Matters?
0
Postgresql Logical Replication is not working for some table
4
PostgreSQL logical replication not working after added a new table to publication
Load 2 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.