Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections

proencio
HOBBY

a year ago

I deployed a Java Spring Boot application using Github. I created the variables but can't access the database.

DDLBD=false NIXPACKSJDK_VERSION=11
PGDATABASE=${{Postgres.PGDATABASE}}
PGPASSWORD=${{Postgres.PGPASSWORD}}
PGPORT=${{Postgres.PGPORT}}
PGPRIVATEHOST=${{Postgres.PGPRIVATEHOST}}
PGUSER=${{Postgres.PGUSER}}
PORT=8080
spring.profiles.active=prod

@Configuration
@Profile("prod")
public class prod extends BaseConfig {

@Autowired
public prod() {  
    [this.host](this.host) = System.getenv("PGPRIVATEHOST");
    this.port = Integer.valueOf(System.getenv("PGPORT"));
    this.dbName = System.getenv("PGDATABASE");
    this.user = System.getenv("PGUSER");

    this.password = System.getenv("POSTGRES_PASSWORD");
    this.dbGenerateDDL =  Boolean.parseBoolean(System.getenv("DDL_BD"));

    System.out.println("host " + [this.host](this.host));
}

}

2024-04-02 15:28:48.791 INFO 7 --- [ main] b.c.f.GestorFlorLaranjeiraApplication : The following 1 profile is active: "prod"

2024-04-02 15:28:49.705 INFO 7 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.

2024-04-02 15:28:49.725 INFO 7 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 6 ms. Found 0 JPA repository interfaces.

2024-04-02 15:28:50.436 INFO 7 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)

2024-04-02 15:28:50.450 INFO 7 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]

2024-04-02 15:28:50.450 INFO 7 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.62]

2024-04-02 15:28:50.544 INFO 7 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext

2024-04-02 15:28:50.544 INFO 7 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1695 ms

@@@@@@ prod DATABASE: jdbc:postgresql://postgres.railway.internal:54356/railway

2024-04-02 15:28:50.728 INFO 7 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]

2024-04-02 15:28:50.802 INFO 7 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.6.8.Final

2024-04-02 15:28:50.846 INFO 7 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}

2024-04-02 15:28:51.354 INFO 7 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting…

2024-04-02 15:28:52.412 ERROR 7 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.

org.postgresql.util.PSQLException: Connection to postgres.railway.internal:54356 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

0 Replies

Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections - Railway Help Station