Issue connecting to Postgresql on AWS when schema specified
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