Hi all. Another question. Sorry for bothering.
So I am trying to use a custom PostgreSQL database. I have set the a prefectdb postgre db with a username prefect and a given password. I have add the following lines of code into my config.toml file:
[server.database]
connection_url = "
postgres://prefect:_mypassword_@0.0.0.0:5432/prefectdb"
I launch my server with the command :
prefect server start --external-postgres --expose
However, I have the following error log coming up:
hasura_1 | {"internal":"could not connect to server: Connection refused\n\tIs the server running on host \"0.0.0.0\"
I believe there is a mistake in my host definition, or a docker container link issue. I have tried to replace 0.0.0.0 with localhost and the hostname of my virtual machine, but I still find the same problem. Is there any more changes to add to the prefect server config file?
Moreover, I have another error with the graphql container:
Error: Can't load plugin: sqlalchemy.dialects:postgres
And I am wondering whether I should set the connection_url element in config.toml as connection_url = "
postgresql://...", as stated here:
https://stackoverflow.com/questions/62688256/sqlalchemy-exc-nosuchmoduleerror-cant-load-plugin-sqlalchemy-dialectspostgre
Could you please help me solve that issue? Thanks in advance, again!