a year ago
Crashed my db via a larger operation and cannot succesfully restart
Crash loop
Upgraded to Hobby for more capacity
Am i hooped?
ⓘ Deployment information is only viewable by project members and Railway employees.
9 Replies
a year ago
Hi Brody thanks
Corrupt data I think. No back-ups due to being on the free trial.
Should i kill it?
2025-02-28 04:58:54.766 UTC [5] LOG: database system is shut down
Mounting volume on: /var/lib/containers/railwayapp/bind-mounts/13ad1f06-0f11-4e62-89cf-ad01a899b451/vol_t0xu3pguyb3q9re3
Certificate will not expire
PostgreSQL Database directory appears to contain a database; Skipping initialization
2025-02-28 04:58:58.566 UTC [5] LOG: starting PostgreSQL 16.4 (Debian 16.4-1.pgdg120+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-02-28 04:58:58.566 UTC [5] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-02-28 04:58:58.566 UTC [5] LOG: listening on IPv6 address "::", port 5432
2025-02-28 04:58:58.571 UTC [5] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-02-28 04:58:58.577 UTC [28] LOG: database system was interrupted while in recovery at 2025-02-28 04:58:52 UTC
2025-02-28 04:58:58.577 UTC [28] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2025-02-28 04:58:58.618 UTC [28] LOG: database system was not properly shut down; automatic recovery in progress
2025-02-28 04:58:58.621 UTC [28] LOG: redo starts at 0/92FA198
2025-02-28 04:59:00.288 UTC [28] LOG: redo done at 0/15FFE350 system usage: CPU: user: 1.06 s, system: 0.47 s, elapsed: 1.66 s
2025-02-28 04:59:00.758 UTC [28] FATAL: could not write to file "pg_wal/xlogtemp.28": No space left on device
2025-02-28 04:59:00.768 UTC [5] LOG: startup process (PID 28) exited with exit code 1
2025-02-28 04:59:00.768 UTC [5] LOG: terminating any other active server processes
2025-02-28 04:59:00.770 UTC [5] LOG: shutting down due to startup process failure
2025-02-28 04:59:00.792 UTC [5] LOG: database system is shut down
Attachments
a year ago
Yes, I've upgraded my plan to get more storage, but I'm unsure if I need to manually increase the volume allocation for my PostgreSQL instance.
apprec your advice, I'm new to this, vibe coding
a year ago
Trying to upgrade to Pro now
a year ago
resizing to 5gb now 
Status changed to Solved brody • about 1 year ago
