Issue Description

My n8n production deployment on Railway has been down for 27 days. The Postgres service is failing to deploy with the error:

"This service requires a volume to be mounted at /var/lib/postgresql/data. Please attach a volume to the service and try again."

Critical Details

Project: talented-trust (Production) Affected Services:

• Postgres (Build Failed)

• n8n Primary (Depends on Postgres)

• n8n Worker (Depends on Postgres)

Timeline:

• Dec 3, 2024 02:55 UTC: Clean shutdown (SIGTERM received)

• Dec 3 - Dec 30: 27 days offline

• Dec 30, 2024: All restart attempts fail

• Current status: Volume appears unmounted

Error Messages

From Postgres Deploy Logs:

This service requires a volume to be mounted at /var/lib/postgresql/data. Please attach a volume to the service and try again. Deployment failed

From Previous n8n Logs (before volume issue):

Error: connect ENETUNREACH fd12:6ed2:8b83:0:a000:69:f8ea:be69:5432 Could not establish database connection within 20,000 ms Connection terminated unexpectedly

Service Configuration

Postgres Service:

• Docker Image: ghcr.io/railwayapp-templates/postgres-ssl:16

• Region: us-east4-eqdc4a

• Expected Mount: /var/lib/postgresql/data

• PGDATA: /var/lib/postgresql/data/pgdata

Variables (Dynamic references):

DATABASE_URL=postgres://POSTGRESUSER:{{POSTGRES_USER}}: POSTGRESU​SER:{{POSTGRES_PASSWORD}}@PGHOST:{{PGHOST}}: PGHOST:{{PGPORT}}/${{POSTGRES_DB}} PGHOST=${{RAILWAY_PRIVATE_DOMAIN}} PGPORT=5432 POSTGRES_DB=railway

What I've Tried

1. Multiple restart attempts on Postgres service

2. Checked Settings > Volumes (volume seems unmounted)

3. Verified variables are using Railway references (not hardcoded)

4. Checked standalone Postgres in separate project (also failing)

5. Unable to access volume to verify data integrity

Critical Need

Primary Goal: Extract n8n workflows from the database BEFORE recreating infrastructure

I need to:

1. Remount the existing volume (if data still exists)

2. Get Postgres running temporarily (even read-only)

3. Execute pg_dump or direct SQL queries to extract workflow data

4. Then proceed with fresh deployment if needed

Questions

1. Does the volume still exist with data? How can I verify this?

2. How do I remount an existing volume to the Postgres service?

3. Is there a way to access volume data directly without the Postgres service running?

4. Are there any automatic backups/snapshots from the past 30 days?

Project Settings show Volume Usage of $0.16, which suggests the volume and data still exist, but the service cannot mount it.

Attempted Solutions

• Checked Volume settings (no volume appears mounted in service settings)

• Attempted to add volume via Settings > Volumes

• Verified service configuration matches template requirements

Environment

• Railway Project ID: talented-trust

• Postgres Version: 16 (ghcr.io/railwayapp-templates/postgres-ssl:16)

• n8n Version: Latest (was working until Dec 3)

• Other Services: Redis (Online), Primary (Failed), Worker (Failed)

Additional Context

This was a working production deployment for months. The 27-day offline period appears to have caused volume/network configuration issues. I have backups of environment variables but need database contents urgently.

Note: I also have a standalone Postgres project that's experiencing similar failures (build failed), suggesting this might be a broader issue.

Urgency Level

CRITICAL - Production data at risk of permanent loss

Any assistance with volume recovery or data extraction would be greatly appreciated.

Logs Available:

• Postgres deploy logs showing volume mount error

• n8n connection failure logs (ENETUNREACH errors)

• Full error timeline from Dec 3 to present

Can provide additional logs or screenshots if needed.