topic Issue connecting to Postgresql on AWS when schema specified in Talend Studio

Issue connecting to Postgresql on AWS when schema specified

Anonymous — Sat, 16 Nov 2024 10:02:45 GMT

Hi,
I created a instance of PostgreSQL 9.5.4 on AWS RDS, called "analysis". Works fine, and I can connect correctly with a client application as superuser.
jdbcostgresql://:5432/analysis
I can use the "check" functionality fine when I don't specify the schema. Says connection successful.
But if I specify the Postgresql schema I want to connect to as staging_01, I get a connection failure, and it says the schema is not present (although I can see it is there in my client)
Are there any known issues with making the Postgresql schema explicit?
Thanks,
Jack

Re: Issue connecting to Postgresql on AWS when schema specified

vapukov — Fri, 24 Feb 2017 02:35:05 GMT

You are connect from application as Superuser
are You do the same from Talend? or From Talend You use other user?

Re: Issue connecting to Postgresql on AWS when schema specified

Anonymous — Fri, 24 Feb 2017 04:01:29 GMT

Hi,
Same user for both