hello this is maybe a docker problem but I got a problem wit

Question

hello this is maybe a docker problem but I got a problem with my supertokens It cannot connect to the postgresql container

Cat Swolo · Answer

``` 01 Apr 2022 07 20 52 829 +0000 | DEBUG | pid ab12b59e 98a4 4068 9cc7 cdbdf3f76117 | main thread | io supertokens storage postgresql HikariLoggingAppender doAppend HikariLoggingAppender java 136 | SuperTokens Starting 01 Apr 2022 07 20 52 832 +0000 | DEBUG | pid ab12b59e 98a4 4068 9cc7 cdbdf3f76117 | main thread | io supertokens storage postgresql HikariLoggingAppender doAppend HikariLoggingAppender java 136 | SuperTokens Failed to create setup connection Connection to localhost 5432 refused Check that the hostname and port are correct and that the postmaster is accepting TCP IP connections 01 Apr 2022 07 20 52 833 +0000 | DEBUG | pid ab12b59e 98a4 4068 9cc7 cdbdf3f76117 | main thread | io supertokens storage postgresql HikariLoggingAppender doAppend HikariLoggingAppender java 136 | SuperTokens Cannot acquire connection from data source 01 Apr 2022 07 20 52 834 +0000 | ERROR | pid ab12b59e 98a4 4068 9cc7 cdbdf3f76117 | main thread | io supertokens storage postgresql HikariLoggingAppender doAppend HikariLoggingAppender java 132 | SuperTokens Exception during pool initialization Trying again in a few seconds for 59 0 mins 01 Apr 2022 07 20 52 836 +0000 | INFO | pid ab12b59e 98a4 4068 9cc7 cdbdf3f76117 | main thread | io supertokens storage postgresql ConnectionPool initPool ConnectionPool java 155 | Trying again in a few seconds for 59 0 mins ```

Cat Swolo · Answer

Here is the docker compose

Cat Swolo · Answer

``` version 3 1 services supertoken users image registry supertokens io supertokens supertokens postgresql ports 3567 3567 environment POSTGRESQL USER=root POSTGRESQL PASSWORD=example POSTGRESQL HOST=host POSTGRESQL PORT=5432 POSTGRESQL DATABASE NAME=authdb db image postgres restart always ports 5432 5432 environment POSTGRES USER root POSTGRES PASSWORD example POSTGRES DB authdb adminer image adminer restart always ports 8080 8080 ```

rp · Answer

`POSTGRESQL HOST` should be `db` Cause the name of the db in the compose file is `db`

Cat Swolo · Answer

wait so host is not a `url` but a `docker container` itself

Cat Swolo · Answer

so the supertoken container is trying to connect to a postgres container named db

rp · Answer

Well it s the the address on which the db is reachable

Cat Swolo · Answer

ok I thought it was the address

rp · Answer

It is the address of the postgresql container

Cat Swolo · Answer

makes sense

rp · Answer

but in docker network that is = to the name of the service

rp · Answer

which i think in this case is `db`

Cat Swolo · Answer

ok I thought you have to input the url of the database

Cat Swolo · Answer

but this makes developing a lot easier

rp · Answer

im not sure what you mean by url of database and how that s different from the address on which the db is hosted at

Cat Swolo · Answer

ah

Cat Swolo · Answer

by that I meant localhost

rp · Answer

hmm