cancel
Showing results for 
Search instead for 
Did you mean: 

Delete all existing publication services

ss
Adventurer

Delete all existing publication services

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?

1 REPLY
Highlighted
EDB Team Member

Re: Delete all existing publication services

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.