Postgres Volume Shows 434MB Total Despite 250GB Allocation
kajabednar12-cpu
PROOP

a month ago

We're experiencing a critical issue with our PostgreSQL 17.9 deployment on Railway. Despite expanding the volume to 250GB several days ago, SSH access shows the Postgres data directory is reporting only 434MB total space with 424MB used (100% full).

Symptoms:

  • Backend login failing: 401 Unauthorized errors
  • All write operations fail: FATAL: could not write init file: No space left on device
  • psql client cannot connect to the database
  • df -h in the container shows /dev/zd10416 at 434M total, 424M used, 0 bytes free

Environment Details:

  • PostgreSQL 17.9 on Railway
  • Instance had volume expanded to 250GB ~3 days ago
  • Data directory: /var/lib/postgresql/data/pgdata
  • Disk usage breakdown:
    • base/: 388M (actual data tables)
    • pg_wal/: 33M (write-ahead logs)
    • pg_xact/: 3.5M

Questions:

  1. Did the volume expansion to 250GB complete successfully, or is there a separate container storage limit?
  2. Why does df -h show only 434M total despite the 250GB allocation?
  3. Does the Postgres service need to be manually restarted to recognize the new volume size?

Impact:

Production application is completely offline. Users cannot log in. All database writes are blocked.

Solved

1 Replies

Status changed to Awaiting Railway Response Railway about 1 month ago


sam-a
EMPLOYEE

a month ago

Hi there, thanks for the detailed report. We've identified and fixed the issue. Here's what happened:

  1. The volume expansion to 250 GB was partially applied — the storage was allocated, but an internal step that makes the full space available to your database didn't complete. There's no separate container storage limit at play here.

  2. That's why df -h was showing only 434 MB — your database could only see the original volume size, not the expanded one.

  3. A restart alone wouldn't have resolved this — it required a fix on our side, which we've now applied.

We've redeployed your Postgres service. Your database should now have access to the full ~233 GB of usable space (250 GB minus normal overhead), and all your existing data is intact.


Status changed to Awaiting User Response Railway about 1 month ago


Railway
BOT

a month ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 29 days ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...