Spring boot can't connect to PostgresQl

domaschhTRIAL

a year ago

I'm having trouble connecting my spring boot app with the postgres isntance they are both starting correctly and I set the env variables in my spring app to

SPRINGDATASOURCEURL=jdbc:postgresql://monorail.proxy.rlwy.net:48165/tiss-postgres
SPRINGDATASOURCEUSERNAME=postgres
SPRINGDATASOURCEPASSWORD=mypw

but I get

Caused by: org.postgresql.util.PSQLException: FATAL: database "tiss-postgres" does not exist

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) ~[postgresql-42.3.5.jar!/:42.3.5]

at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2787) ~[postgresql-42.3.5.jar!/:42.3.5]

at org.postgresql.core.v3.QueryExecutorImpl.(QueryExecutorImpl.java:173) ~[postgresql-42.3.5.jar!/:42.3.5]

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:290) ~[postgresql-42.3.5.jar!/:42.3.5]

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.3.5.jar!/:42.3.5]

at org.postgresql.jdbc.PgConnection.(PgConnection.java:223) ~[postgresql-42.3.5.jar!/:42.3.5]

at org.postgresql.Driver.makeConnection(Driver.java:402) ~[postgresql-42.3.5.jar!/:42.3.5]

at org.postgresql.Driver.connect(Driver.java:261) ~[postgresql-42.3.5.jar!/:42.3.5]

at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar!/:na]

at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar!/:na]

at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar!/:na]

at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar!/:na]

at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-5.0.1.jar!/:na]

at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:100) ~[HikariCP-5.0.1.jar!/:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-5.0.1.jar!/:na]

2 Replies

a year ago

still hitting this error, domaschh


splawrenceHOBBY

a year ago

Same error. Do the environment variable not work with Spring Boot? That's a deal breaker for me. I can't be expected to expose my production credentials.