5 days ago
I have PostgreSQL databases on Railway (gravity-cadastros-teste, gravity-servicos-teste, etc).
Problem:
- psql connects and works perfectly
- Databases have 14+ tables with data
- pg_dump fails silently (no output, no error)
- Even with PGSSLMODE=require, pg_dump produces no output
- This prevents backing up/syncing data between databases
The issue appears to be SSL/certificate related since psql works but pg_dump doesn't.
Project ID: 036d6bfe-5711-4063-8169-a784b925981c
2 Replies
5 days 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 • 5 days ago
5 days ago
So，do you mean the psql is working, but pd_dump is not? Have you tried the railway's public url's host?
Could you try this and see what you get?
pg_dump "postgresql://user:pass@host:port/dbname?sslmode=require" > dump.sql
Then try this, let's see what the logs on it?
pg_dump --verbose "postgresql://user:pass@host:port/dbname?sslmode=require" -f test.sql 2>&1
5 days ago
Try forcing full SSL parameters explicitly (sslmode=require sslrootcert=system) or use the public connection URL with the latest PostgreSQL client version; if it still hangs, Railway support will likely need to inspect the proxy/network layer for project 036d6bfe-5711-4063-8169-a784b925981c
this should work
cheers