Postgres crashes
psrivastav21
PROOP

2 months ago

On importing data to the database, it keeps crashing. The account is upgraded to 100 gb.

2026-01-15 06:27:09.613 UTC [29] FATAL: could not write to file "pg_wal/xlogtemp.29": No space left on device

2026-01-15 06:27:09.619 UTC [6] LOG: startup process (PID 29) exited with exit code 1

2026-01-15 06:27:09.619 UTC [6] LOG: terminating any other active server processes

2026-01-15 06:27:09.619 UTC [6] LOG: shutting down due to startup process failure

2026-01-15 06:27:09.633 UTC [6] LOG: database system is shut down

$10 Bounty

3 Replies

Railway
BOT

2 months ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!


Railway
BOT

2 months ago

This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.

Status changed to Open Railway about 2 months ago


Click on your volume that's mounted to the postgres service and increase the volume. The max volume for users on Pro plan is 250GB. Make sure to redeploy the service after.


ilyassbreth
FREE

2 months ago

hey, your volume didn't actually grow to 100gb when you upgraded your plan. railway doesn't auto-resize volumes, you gotta do it manually. click on your postgres service in the project canvas, then click on the volume attached at the bottom, go into volume settings, hit grow and increase it to 100gb, then restart your postgres service. your pg_wal is filling up because postgres is still writing to the old small volume

hope this help you slightly_smiling_face emoji


Loading...