postgresqlherokuheroku-postgres
Heroku Postgres - suddenly appeared error
I have an app on Heroku which is already running 5 months.
Suddenly I saw today that the server is crashed with this error message:
no pg_hba.conf entry for host "", user "", database "", SSL off
I don't understand what went wrong cause it's worked fine yesterday and I didn't released a new version by two weeks.
I also tried to connect to the db from my local machine and it's worked properly.
I'll appreciate any help !
Solution
What I did is to set the DB credentials as environment variables in Heroku, and use them inside a config object like so:
I preferred to connect using the connection string because it's much more cleaner, but it's seems like this option is not working anymore.
- Rails 4 scope NOTNULL refactor
- Select on self-referencing table where all chains meet a condition
- In a join, fields with null values are not getting shown but in normal query they are
- Install pgAgent on AWS RDS for Postgres
- Spring JBDC bad SQL grammar on PostgreSQL
- Using IF in function for different queries as a result
- Variables in looping condition in a postgreSQL while loop
- SQL query for returning rows with only certain values in list but not others?
- How to insert data into a code-first database with a SQL script?
- How do I insert a record into a Postgres DB based off the MAX of one column?
- Pyspark JDBC read with partitions
- Quarkus dev postgresql container not shutting down with quarkus
- Permission issue with PostgreSQL in docker container
- Starting application development using Docker or configuring Docker during development?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- postgresql - replace all instances of a string within text field
- migrate data from MS SQL to PostgreSQL?
- How to change the select output delimeter from '|' to ',' on Postgres through command line?
- Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?
- Psycopg2: how to deal with special characters in password?
- SET CONSTRAINTS ALL DEFERRED not working as expected
- Postgres container doesn't start
- How do you find the row count for all your tables in Postgres
- Alter column ignoring dependent views
- Recursive CTE 'Query Error: relation [] does not exist', PostgreSQL v17
- How to view Oldest Query results in Azure Monitor Metrics for an Azure PostgreSQL Flex Server instance
- Insert literal '${value}' without variable substitution into PostgreSQL table from DBeaver
- How should I set my DATABASE_URL?
- How can I use composite primary keys in django?
- How to switch databases in psql?