So i received a message from heroku saying it needs to carry out maintenance on my database and will be read only for a bit. However I go to check my site and the site isn’t working for the pages that require data from the database, I go to check the logs and see this error message:
2022-05-20T09:57:55.246102+00:00 app[web.1]: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "eu-west-1.compute.amazonaws.com" (52.18.116.67), port 5432 failed: FATAL: password authentication failed for user "MYUSERNAME"
2022-05-20T09:57:55.246102+00:00 app[web.1]: connection to server at ".eu-west-1.compute.amazonaws.com" (52.18.116.67), port 5432 failed: FATAL: no pg_hba.conf entry for host "IP", user "MYUSERNAME", database "DATABASE", no encryption
I haven’t touched or changed anything, so not sure what the problem is.
>Solution :
This happen if you are not using the "dynamic" environment variable that Heroku manage for connecting to a PostgreSQL database
If you have just one, it’s better to use DATABASE_URL as it always have up-to-date location and credentials
Heroku can change the url for various reasons, ex credentials rotation
If you are using sqlalchemy you might need a slight workaround:
os.environ.get('DATABASE_URL').replace('postgres://', 'postgresql://')