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
8 Replies
Project ID:
b3aa5d3d-8985-46d1-8747-571b21b032d6
b3aa5d3d-8985-46d1-8747-571b21b032d6
have you changed anything at all about this database?
Nope
try redploying
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)
with that extra information, may i ask why you answered no to my first question?
I didn’t deem changing how the variables are passed through is “changing the database”