1,049 questions
1
vote
1
answer
118
views
n8n and postgres deploy incompatibility version
I am trying to use the fast deploy of n8n with heroku:
link deploy
But, I get the following error:
We tried to create heroku-postgresql:essential-0, but received an error from the add-on provider. Try ...
0
votes
0
answers
13
views
Adding add-ons on build to Review applications on Heroku
This is my app.json file which i am using to push to github for the review app on heroku but the add-ons listed are not being added upon build finish. How to fix this?
{
"name": "test ...
1
vote
1
answer
155
views
ActiveRecord::ConnectionNotEstablished tries local PostgreSQL socket instead of Heroku DB
I have a Rails 8.0.1 application (Ruby 3.3.4) that I’m deploying to Heroku. The code pushes successfully, but whenever I run:
heroku run rails db:migrate
I get this error:
ActiveRecord::...
0
votes
1
answer
78
views
Connect to Heroku PostgreSQL using Tableau ODBC and SSL
I'm trying to connect to my Heroku PostgreSQL database through Tableau and ODBC, this needs to be over ODBC because it needs to be SSL connection. This being said, I have configured a User DSN. I ...
- 1,104
0
votes
2
answers
81
views
Postgres Query fast when field TRUE and slow when FALSE
I have a tickets table (Postgres on Heroku) that has about 7 million records.
I have a single table query that is run often with the exported field either true or false. When it is true, it runs very ...
- 369
0
votes
1
answer
39
views
Heroku Postgres not working on Heroku Server [Django]
I have a Django project, where I am using Redis/Celery to call some API's. I've set up my settings.py file to connect to the Postgres database and when running the Django project locally (with Redis/...
- 11
0
votes
0
answers
52
views
Ruby on Rails app ID sequence gets out of order all the time
I have a Ruby on Rails app using a Heroku Postgres database. When I create new records for any model, the id's get out of sequence constantly. They usually skip about 30 id's. I know how to reset the ...
- 1,098
0
votes
2
answers
104
views
I am trying to view rows and run queries in my heroku postgres database using the heroku pg:psql command but I always get this error
I am trying to view rows and run queries in my heroku postgres database using the heroku pg:psql command but I always get this error : --> Connecting to postgresql-tapered-69603
psql: error: ...
1
vote
1
answer
538
views
DrizzleORM - ClientAuthentication Error using `heroku-postgres` database (aws) connection url
I am trying to connect to a heroku-postgres database with drizzleORM, the db is actually an aws db.
This is the error I get, using the db url I got from the heroku dashboard:
xxx\node_modules\drizzle-...
- 167
0
votes
1
answer
126
views
Deployment Failure on Heroku: Vue-CLI Build Errors
I am encountering persistent issues with deploying my Node.js application, which includes a Vue.js frontend, on Heroku. Despite multiple attempts and varying configurations, my builds consistently ...
- 3
1
vote
1
answer
43
views
Heroku API for data processing and Postgres post
I'm attempting to write my first API. I wrote (with help of GPT), a simple Request script and I uploaded the Dash-API script to Heroku. I'm getting input from multiple remote locations and I wish to ...
- 303
0
votes
1
answer
187
views
Background jobs on heroku
I am brand new to Heroku and I am going through the tutorials for a Rails app.
Right now all it does is process some background jobs with sidekiq. The only frontend component is the Sidekiq dashboard.
...
- 23
0
votes
1
answer
65
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
0
votes
0
answers
44
views
Securely connect to a database from a CLI
I am writing a CLI in Kotlin primarily using this library: the CLIKT Library and I am using Gradle to manage dependencies
I have a separate Django website that I have deployed to Heroku
This Heroku ...
- 220
0
votes
1
answer
38
views
Django Heroku /GET Favicon.Ico when running heroku logs --tail
My Heroku build is complete, but the application is not booting for some reason.
When I run heroku logs --tail,
2023-09-04T13:32:07.484629+00:00 heroku[router]: at=error code=H10 desc="App ...
1
vote
0
answers
48
views
Significantly slower DB queries between Ruby 2.7.6 (heroku-20) and Ruby 3.1.4 (heroku-22)
I have a Ruby 2.7.6 app running on Heroku (stack heroku-20) and a branch of the same app on Ruby 3.1.4 running on Heroku (stack heroku-22). Both have identical DBs. Running these two branches locally, ...
- 1,985
1
vote
0
answers
103
views
apt file and sql repository error on app deployment in Heroku
Newbie here. I am trying to deploy an app in Heroku. All the code and files are in github.
In the review apps, the app is working just fine, but when it is in production, I don't understand why it is ...
- 11
0
votes
1
answer
109
views
Unable to perform Insert/Update operation on Heroku Postgres
We have a Codeigniter (PHP) application hosted on the Heroku instance. We are using the Heroku Postgres database to connect and do CRUD operations. It is also connected to the Salesforce instance ...
- 1,716
3
votes
3
answers
1k
views
Connecting Heroku Postgres to Google Studio Looker
I'm trying to connect a Heroku Postgres database to Google Looker Studio (former Data Studio).
I found an old stack overflow question that suggests I need to use SSL and for that I need to enable ...
- 2,911
0
votes
1
answer
31
views
failure to deploy by django webapp on heroku
Good day, I'm trying to deploy by django webapp on heroku but i'm facing the following problem.
The conflict is caused by:
The user requested botocore==1.23.50
awsebcli 3.20.3 depends ...
- 27
1
vote
0
answers
100
views
How do I fetch data from Heroku Postgres database in my Heroku app?
My Heroku app fetches data from a "products" table in my database to display on my shop page. When I deploy the app on Heroku, the shop page isn't rendering the products. I'm not seeing any ...
0
votes
1
answer
2k
views
pg_restore: error: error returned by PQputCopyData when restoring database to heroku
I have my local database and I created a dump file that is 1.1GB I need that data to put on Heroku but every time I run this command
pg_restore --verbose --clean --no-acl --no-owner -h heroku-host -U ...
0
votes
0
answers
47
views
how big can a Heroku Postgres database be?
I have a Heroku database ($200 plan). THe database is quite simple: it contains user clicks. There are about 10 fields in the main table, some fields are indexed, and the table contains about several ...
- 8,832
1
vote
0
answers
44
views
How can I access the Heroku Postgres Database copy?
I was one of the users who had their free DB deleted. I notice they left me with a DB copy when I run heroku pg:backups as you can see below:
(venv) MacBook-Pro-4:TheDropCore adamlamorre$ heroku pg:...
- 705
2
votes
1
answer
322
views
What is the command to upgrade Heroku Postgresql to a Basic plan
I need to upgrade my Heroku Postgresql database to the Basic plan. I've found the command in Heroku's docs, but I'm not sure if I need to change it to affect my account. My app's name on Heroku is ...
- 1,764