From: | Sang Gyu Kim <skim(at)webmd(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Can I get some advice regarding logical replication server? |
Date: | 2020-09-04 15:31:40 |
Message-ID: | CAHq_kQbYdX36_zCnPNdSwnbYkphJ673M-zsQWgnKYmabLCfzLA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Ranjan,
This is Sang Kim and I recently set up a logical replication server on
postgresql 11 but got an error. While google for the issue, I found some
pages and this email address is the responder.
Please give me some idea how to fix the issue on postgresql 11.
I set up logical replication server and it work for several hours but
finally stuck.
I google it and someone recommended to set wal_sender/receiver_timeout
longer, so I tested with zero, 1 min, 5 mins, 10 mins, 30 mins. None of
them work after I got error "ERROR: replication slot "profprod01_sub2" is
active for PID 8328".
Even though I bounced logical replication server, stream replication from
master server is alive and bring same error.
Please give me some idea or advice for this issue.
Thanks,
Sang
--
skim(at)webmd(dot)net
646-674-5346 (desk)
732-829-2872 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Sterritt | 2020-09-04 15:51:04 | Re: Check for duplicates before inserting new rows |
Previous Message | Adrian Klaver | 2020-09-04 14:56:13 | Re: Dependency problem using community repo on Redhat 7 |