install confluence with Postgres RDS

[Sally Wong]

Hi,

I am trying to install an empty instance of confluence and connect it to a postgresRDS. this is the binary I used.

atlassian-confluence-7.4.3-x64.bin

I also created a postgres RDS (10.13-R1) in AWS. The RDS name is "confluence"

By trying to run the confluence setup page, I keep getting the following.
"org.postgresql.util.PSQLException: FATAL: database "confluence" does not exist"

here is my db URL. what did I do wrong? am I suppose to create a db called confluence in this RDS?

jdbc:postgresql://confluence.czhphzadwk8g.us-east-1.rds.amazonaws.com:5432/confluence

I also tried to use this, and got the following error

jdbc:postgresql://confluence.czhphzadwk8g.us-east-1.rds.amazonaws.com:5432/

java.sql.SQLException: No suitable driver found for jdbc:postgresql://confluence.czhphzadwk8g.us-east-1.rds.amazonaws.com:5432

thanks

[Bloompeak Support]

Hi @Sally Wong ,

Try below jdbc url pattern. Hope it works.

jdbc:postgresql://{rds_name}.czhphzadwk8g.us-east-1.rds.amazonaws.com::5432/{db_name}?user={username}&password={password}