XDB fail when the table exist in target database

SOLVED
Highlighted
Gold Adventurer

XDB fail when the table exist in target database

hi all, 

I trying use xdb Replicator Console to configurate a replica from Oracle to Postgres, and when table not exist in target datase xdb, function well, but when a try tu create a subcription with a table that exist in target dabase i get the fallowing error:

 

Captura de pantalla de 2019-04-22 17-19-02.png

is normal behaivor ?

Can I tell the xdb to ignore creating the tables in the destination database?

 

Regards 

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
EDB Team Member

Re: XDB fail when the table exist in target database

Hi @asotolongo,

 

Yes, it is normal behavior that the subscription database must not contain the table with the same name.

 

Please review the section 5.3.2 in the XDB documentation, the link for the document is as below :

 

 https://www.enterprisedb.com/docs/en/6.2/repguide/EDB_Postgres_Replication_Server_Users_Guide.1.26.h...

 

Please get back to us in case of any issues/queries.

 

Regards,

Sudhir

 

View solution in original post

2 REPLIES 2
Highlighted
EDB Team Member

Re: XDB fail when the table exist in target database

Hi @asotolongo,

 

Yes, it is normal behavior that the subscription database must not contain the table with the same name.

 

Please review the section 5.3.2 in the XDB documentation, the link for the document is as below :

 

 https://www.enterprisedb.com/docs/en/6.2/repguide/EDB_Postgres_Replication_Server_Users_Guide.1.26.h...

 

Please get back to us in case of any issues/queries.

 

Regards,

Sudhir

 

View solution in original post

Highlighted
Gold Adventurer

Re: XDB fail when the table exist in target database

@slonkar, thanks for response.

if is the normal behaivor, i must adjust me to it

 

Regards

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks