Seeded Replication

nique constraint" errors. Basically postgresql does not recognize the primary key. Any thought / suggestion is helpful! Lou Tseng lts...@advancedpricing.com<mailto:lts...@advancedpricing.com> [http://advancedpricing.com/wp-content/uploads/logo_AMPS_email.png]<http://www.advancedpri

Re: Seeded Replication

ALTER SUBSCRIPTION ... ENABLE --> errors occur here Thoughts? Lou Tseng lts...@advancedpricing.com<mailto:lts...@advancedpricing.com> [http://advancedpricing.com/wp-content/uploads/logo_AMPS_email.png]<http://www.advancedpricing.com/> Advanced Medical Pricing

Lingering replication slots

Hi, A newbie question: how do I delete lingering replication slots? When creating Subscription for logical replication, the CREATE SUBSCRIPTION stuck and didn't return. After ctrl-c and aborted the command, the master database have lingering replication slots that I can't delete because the ac

Re: Lingering replication slots

Thank you. Wasn't able to drop replication slot because it's still active. Arjun suggested pg_terminate_backend() and it did the trick. Thanks a lot! Lou Tseng lts...@advancedpricing.com<mailto:lts...@advancedpricing.com> [http://advancedpricing.com/wp-content/uploads/log

Re: Seeded Replication

Thank you Adrian. copy_data = false did the trick! Lou Tseng lts...@advancedpricing.com<mailto:lts...@advancedpricing.com> [http://advancedpricing.com/wp-content/uploads/logo_AMPS_email.png]<http://www.advancedpricing.com/> Advanced Medical Pricing Solutions<http://advancedp

Logical replication failed recovery

: could not receive data from WAL stream: ERROR: requested WAL segment 0001520800EB has already been removed 2019-04-07 12:28:37.182 UTC [114186] LOG: worker process: logical replication worker for subscription 8907992 (PID 22292) exited with exit code 1 Lou Tseng lts