Delete all existing publication services

[ss]

When I am trying to create a new publication service by adding database to the publication server it gives the following error:

"Cannot register database because it is already registered by a publication service"

I had previously installed xDB Replication Server but recently uninstalled and re-installed afresh. But the error persists despite the fact that no databases are shown in the publication/subscription server under SMR/MMR.

How can all previous subscription/publication databases be deleted?

[kapil]

Hi SS,

Could you please follow the below workaround.

Steps:

1) Stop both publication(pubserver) and subscription(subserver) services.

2) Drop xDB schema's i.e, _edb_replicator_pub and _edb_replicator_sub from the database.
3) Start both publication(pubserver) and subscription(subserver) services.
4) create a new publication service by adding database to the publication server.

You can refer below documents for more details.

https://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replication_Server_Users_Guide-5...

Hope this helps you.

[funnyjokes]

 Really your post is really very good and I appreciate it. It’s hard to sort the good from the bad sometimes.You definitely put a new spin on a topic thats been written about for years.