How to Move Talend metadata from public schema to private schema

[RAJ6]

Hi folks,

During installation of Talend we have provided the db with public repository.

We wish to move the tables created in the public schema to private schema and also we need to use private schema only here after. 

how to change the schema db configuration page on TAC. I have added the connection string in this way "jdbc: postgresql://hostname: port/database/schema". Is this the correct method? if not could you suggest the right way to add schema name with the database name

database name: talend

private schema name: dq

I have checked dq schema is there in postgresSQL

could please share your information.

Note: This is urgent requirement

[vapukov]

I can not test it right now (server production)

but You can test

jdbc:postgresql://host:5432/YourDB?currentSchema=YourSchema

[RAJ6]

Hi
I tried your solution. It's not working.

[vapukov]

unfortunately - could not comment, because not see what You full settings

[RAJ6]

Hi vapukov,

Thank you very much for your prompt response. I tried below command.

jdbc: postgresql://dwh.cortobddhensa.ap-south-1.rds.amazonaws.com:5432/talend?currentSchema=dq

jdbc: postgresql://dwh.cortobvddhensa.ap-south-1.rds.amazonaws.com:5432/talend?dq

hostname: dwh.cortobddhensa.ap-south-1.rds.amazonaws.com

database name: talend

schema name: dq

[vapukov · Accepted solution]

check:

- version of PostgreSQL (before 9.4 string little different), You could test it with 

jdbc:postgresql://host:5432/database?searchpath=schema

- permissions

as You can see from pictures - all work as expected:

2nd picture - show new tables in schema dev, created by Talend

[RAJ6]

Hi vapukov,

The information you provided me is of immense help. Thanks for your quick response

[Anonymous]

@vapukov : Hi, 

jdbc:postgresql://host:5432/database?currentschema=schema

 This URL checks out. 

However the tables are not created in the specified private schema. We tried manually moving all the tables from public to private schema and changed the url in tac and tried making changes in tac. The changes are still captured in public schema and it is not getting reflected in private schema even after changing the url connection string.

[vapukov]

---

@gautam_srinivas wrote:

@vapukov : Hi, 

jdbc:postgresql://host:5432/database?currentschema=schema

 This URL checks out. 

However the tables are not created in the specified private schema. We tried manually moving all the tables from public to private schema and changed the url in tac and tried making changes in tac. The changes are still captured in public schema and it is not getting reflected in private schema even after changing the url connection string.

---

check all information above ... it is work 

[vapukov]

what exactly PostgreSQL are You use?