All Questions
49 questions
0
votes
0
answers
87
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
1
vote
1
answer
1k
views
Sequelize/Postgres: NUMERIC scale 7 must be between 0 and precision 2
Issue
Can't seem to figure out how to resolve error when migrating decimal to Heroku.
In my sequelize, it is running fine but heroku is giving me this error for postgres:
migration
async up(...
user6437206
0
votes
1
answer
324
views
TypeError: str.charAt is not a function: at parse (/app/node_modules/pg-connection-string/index.js:13:11) Heroku Addons postgresql
when I run deploy my app to heroku I got this error
2022-05-26T01:38:34.587567+00:00 app[web.1]: TypeError: str.charAt is not a function
2022-05-26T01:38:34.587577+00:00 app[web.1]: at parse (/app/...
- 1
0
votes
1
answer
999
views
Error: The server does not support SSL connections | PostgreSQL + Knex
I have my back-end at Heroku. The connection file looks like this:
const knex = require("knex")({
client: "pg",
connection: {
host: process.env.DB_HOST,
user: process....
-2
votes
1
answer
249
views
Is there a way to disable security on heroku Postgres db?
My project doesn't involve any private information, so I don't care about vulnerabilities.
I am certain that the connection between the App/server and the DB is the problem.
I tried to looking on ...
- 133
0
votes
0
answers
106
views
Method Not Allowed heroku deploy
Hello I am deploying for the first time with heroku, and I have a problem.
When doing git push heroku master everything works correctly, but when entering the site through the browser it shows me only ...
1
vote
0
answers
196
views
Do you need to nullify variables at the end of Node.js functions to avoid memory leaks?
so I'm trying to find a memory leak in an app I've deployed to Heroku. I use express post requests in most if not all of my functions so I think there's some fundamental issue I'm missing here. ...
- 294
0
votes
0
answers
40
views
Heroku app on node.js can't connect to heroku Postgre
I am writing a node.js app using Heroku and PostgreSQL. But when I try to make a request through Heroku it times out. Here are the Heroku logs:
2021-05-15T18:33:34.397049+00:00 heroku[router]: at=info ...
- 11
1
vote
1
answer
135
views
How to convert a Heroku Postgres Client to a Pool?
So I am currently using the following:
const { Client } = require('pg');
const db = new Client({
connectionString: process.env.DATABASE_URL,
ssl: {
rejectUnauthorized: false
}
});
I'd like ...
- 294
0
votes
1
answer
809
views
Postgres: When to use .end() vs .release() in queries (and does this change in util.promisify)? Does lack of these functions increase memory usage?
So in my application, I'm using a Postgres DB in a Node.js environment that's deployed to Heroku. I realized that in all of my queries, I don't have a db.release() or db.end(), and I think I need to ...
- 294
0
votes
1
answer
26
views
React App page refreshes to the wrong page after posting data to a Postgres database on Heroku
1. Summarize the problem
GitHub repo: https://github.com/JorySmith/feature-request-tracker
GitHub live project: https://jorysmith.github.io/feature-request-tracker/
This is a simple feature tracker ...
- 1
0
votes
1
answer
471
views
Heroku cannot connect to postgres database using Node.js
I am writing a full stack program in NodeJS, using Heroku and Postgresql. When I try to make a request through Heroku it times out. Here are the Heroku logs:
2021-04-14T23:39:01.483427+00:00 heroku[...
1
vote
1
answer
315
views
no pg_hba.conf, just will not work. I have located and tried changing it many times
I have no pg_hba.conf error with Heroku Postgres. I have searched all over especially on here and tried many of the users suggestions. I have tried changing the pg_hba.conf file to pretty much all the ...
- 13
1
vote
4
answers
148
views
Express.js app times out when attempting to query a PostgreSQL database
I've built an Express.js app, hosted by Heroku, with a non-embedded PostgreSQL database.
The app was running as intended until about a month ago, and for several months before that. However, when I ...
- 732
1
vote
1
answer
360
views
Heroku with Strapi, Application is not using production database
I've deployed my app to Heroku. It gives an Application Error message upon visit.
The logs gave me this:
[2021-02-15T01:04:05.882Z] debug ⛔️ Server wasn't able to start properly.
[2021-02-15T01:04:05....
- 11