All Questions
Tagged with postgresql heroku
3,215
questions
0
votes
1
answer
48
views
Heroku Postgres database error: "server does not support SSL, but SSL was required"
I am trying to enable pgbouncer to experiment with managing number of connections to my app.
I followed this guide, but am seeing the following error when the app hits the database.
connection to ...
- 2,027
0
votes
1
answer
39
views
Can't get the chart.js graph on my web app to populate when pulling data from my database and I know it's related to the format of the date returned
For background, I am working on my first web app using heroku + flask/python. It's a personal project to track soil humidity in various potted plants around my house using an esp32 and sensors that ...
0
votes
0
answers
40
views
Heroku Postgres database records gone after about 24 hours
I have deployed application in Spring Boot on heroku server, but after about 24 hours all records in the database are gone. All tables are still there.
Maybe I shoud create new Postgres addon again ...
- 53
0
votes
0
answers
34
views
trouble using proxy with sequelize
I am on Heroku and due it's IP address rotation nature it's difficult to connect to an external database with IP restriction.
We can use proxy with pg but in sequelize there is no way to add a proxy.
...
- 120
4
votes
4
answers
215
views
error: could not execute query: ERROR: schema "_heroku" does not exist
I use Heroku to deploy my app and changed my plan from Basic to Essential 1 on the Postgresql add-on this morning.
Since then, I cannot manage to download my database in a local environment.
Here is ...
- 81
0
votes
0
answers
35
views
Trouble Connecting to PostgreSQL on Heroku with node-pg-migrate: SSL Configuration Issues
I'm trying to deploy a Node.js application on Heroku that uses PostgreSQL. I'm using node-pg-migrate for database migrations, but I'm running into issues with SSL connection settings. Heroku requires ...
- 321
0
votes
0
answers
41
views
Django deploy on Heroku causes causes too many connections error
I have a well-established Django app running on Heroku. It has a Heroku Postgres Standard 0 plan. My latest build upgraded the app to Python 3.12 and Django 4.0, as well as a few dependencies, ...
- 825
0
votes
1
answer
83
views
How to detach Postgres attachment from Heroku app?
I'm cleaning up some ops stuff on a Rails app hosted on Heroku and noticed we have two postgres attachments set up which means we are paying double. I dug into the tables and saw that one (...
- 11
0
votes
0
answers
53
views
Heroku - Django - How to reduce cool down of keep alive
I have an API that creates a model object whenever an action is true.
Slight problem, everytime the API sends some data it creates a connection and these connections dont seem to cool down very ...
- 301
0
votes
0
answers
189
views
Installing Apache Superset on Heroku gives "relation 'user_attribute' does not exist" erorr
I try to install Apache Superset on Heroku (for a week already) with this manual: https://chizurumolorondu.medium.com/setting-up-apache-superset-on-heroku-b547302f600e
The local Superset installation (...
- 11
0
votes
1
answer
85
views
heroku migrate: django.db.utils.OperationalError: connection to server failed
I am a student learning on full-stack web development.
I am very new to coding and would need help with following.
I am trying to deploy my Django app to Heroku.
Previously was using sqlite3 - then I ...
- 3
0
votes
1
answer
94
views
How to insert Bulk data from csv in Postgres-Heroku?
I have connected my hosted postgres-db from heroku to my local machine, using dbeaver, connection was successful, and when I do try to insert single or multiple data(more than one but not bulk) at a ...
0
votes
0
answers
52
views
Django app working locally anyhow when I push it to Heroke it will display a 500 error (H10)
I started my Django app with the sqlite default data base and later on I proceeded the steps (shown below) since I wanted to host it in Pythonanywhere since it was a cheaper alternative (it did not ...
- 11
0
votes
1
answer
88
views
Typescript app and api on heroku - CORS failed and NS_ERROR_DOM_BAD_URI
I have been looking for a solution on this for days now and getting pretty tired of it. Here is my setup on heroku:
Application
Running an app with typescript served by Heroku.
For log in and ...
0
votes
1
answer
43
views
Local postgres database not syncing with Heroku postgres database
I am creating a CRM system with Django for my non-profit organisation. Have installed a local postgres database to which I created a table students and have added 2 rows via Django Admin interface. ...
- 3