I need help deploying my app

orion-barjamaj

TRIAL

6 months ago

Hey! I've created an app using node.js and for the database using neon, but my app is crashing. I did what this tutorial told me https://neon.tech/docs/guides/railway and i get these errors on the deploy logs.

Database connection error: Error: Connection terminated unexpectedly

    at /app/node_modules/pg-pool/index.js:45:11

    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

/app/node_modules/pg-pool/index.js:45

    Error.captureStackTrace(err)

          ^



Error: Connection terminated unexpectedly

    at /app/node_modules/pg-pool/index.js:45:11

    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

    at async getPgVersion (/app/app.js:21:20)

Also here is the app.js file https://github.com/Orion-Barjamaj/Inventory-Application/blob/main/app.js

0 Replies

orion-barjamaj

TRIAL

6 months ago

953a689f-47cd-491d-88a5-0e347fc11d93

orion-barjamaj

TRIAL

6 months ago

I need help deploying my app

brody

EMPLOYEE

6 months ago

does it connect at all?

orion-barjamaj

TRIAL

6 months ago

nope

orion-barjamaj

TRIAL

6 months ago

now its asking for a start command

brody

EMPLOYEE

6 months ago

check out the docs on that -

orion-barjamaj

TRIAL

6 months ago

nevermind still the same it crashed here are the deploy logs Database connection error: Error: Connection terminated unexpectedly

at /app/node_modules/pg-pool/index.js:45:11

at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

/app/node_modules/pg-pool/index.js:45

Error.captureStackTrace(err)

      ^

Error: Connection terminated unexpectedly

at /app/node_modules/pg-pool/index.js:45:11

at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

at async getPgVersion (/app/app.js:21:20)

Node.js v18.20.2

orion-barjamaj

TRIAL

6 months ago

i think the problem may be at how i am connecting with my neon database

brody

EMPLOYEE

6 months ago

you arent using a port

orion-barjamaj

TRIAL

6 months ago

const port = process.env.PORT || 5432;

// Connect to database

const { Pool } = require('pg');
const { PGHOST, PGDATABASE, PGUSER, PGPASSWORD } = process.env;
const pool = new Pool({
    host: PGHOST,
    database: PGDATABASE,
    username: PGUSER,
    password: PGPASSWORD,
    port: port,
});