R
Railway9mo ago
n-march

Unable to make Postgres database work

My project cannot connect to the database but when I copy the command to connect to my database via psql I'm able to connect no problem. This leads me to believe there is a problem with the database in the backend. Anyone has any ideas on how I can debug this? This works in Terminal: "PGPASSWORD=** psql -h monorail.proxy.rlwy.net -U postgres -p 55074 -d railway" Build log: 2024-02-23 07:29:35.678 UTC [8] LOG: starting PostgreSQL 16.0 (Debian 16.0-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-02-23 07:29:35.678 UTC [8] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-02-23 07:29:35.678 UTC [8] LOG: listening on IPv6 address "::", port 5432 2024-02-23 07:29:35.682 UTC [8] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-02-23 07:29:35.689 UTC [31] LOG: database system was interrupted; last known up at 2024-02-21 19:47:14 UTC 2024-02-23 07:29:35.723 UTC [31] LOG: database system was not properly shut down; automatic recovery in progress 2024-02-23 07:29:35.726 UTC [31] LOG: redo starts at 0/1AB71D0 2024-02-23 07:29:35.726 UTC [31] LOG: invalid record length at 0/1AB72B8: expected at least 24, got 0 2024-02-23 07:29:35.726 UTC [31] LOG: redo done at 0/1AB7280 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-02-23 07:29:35.730 UTC [29] LOG: checkpoint starting: end-of-recovery immediate wait 2024-02-23 07:29:35.739 UTC [29] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.002 s, total=0.011 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=0/1AB72B8, redo lsn=0/1AB72B8 2024-02-23 07:29:35.744 UTC [8] LOG: database system is ready to accept connections
No description
8 Replies
Percy
Percy9mo ago
Project ID: b3aa5d3d-8985-46d1-8747-571b21b032d6
n-march
n-march9mo ago
b3aa5d3d-8985-46d1-8747-571b21b032d6
Brody
Brody9mo ago
have you changed anything at all about this database?
n-march
n-march9mo ago
Nope
Brody
Brody9mo ago
try redploying
n-march
n-march9mo ago
Did not work. I think something went wrong when I tried to make the default variables into global variables (though I just used the “make variable global” option)
Brody
Brody9mo ago
with that extra information, may i ask why you answered no to my first question?
n-march
n-march9mo ago
I didn’t deem changing how the variables are passed through is “changing the database”
Want results from more Discord servers?
Add your server