connect my postgres 16 database
tatiana-vieira
HOBBYOP

2 years ago

I'm trying to connect my postgres 16 database, it's giving the error: connecting to database for restore pg_restore: error: connection to server at "railway.app" (76.76.21.21), port 5432 failed: Connection timed out (0x0000274C/10060) Is the server running on that host and accepting TCP/IP connections? I've already pinged railway.app and it's working normally, postgres is allowing connections.

7 Replies

brody
EMPLOYEE

2 years ago

Railway does not run any databases under the railway.app domain, please make sure you have your credentials setup correctly.

tatiana-vieira
HOBBYOP

2 years ago

Which domain does it run on?
brody
EMPLOYEE

2 years ago

You would want to check the from your Databases variables tab.

tatiana-vieira
HOBBYOP

2 years ago

Can you help me with this? What are the variables?
tatiana-vieira
HOBBYOP

2 years ago

Na verdade preciso de ajuda com essas,quais são as pricnipais?Fiz backup do meu banco postgres 16 db.sql. Mas congigurei as variáveis e não deu certo?DATABASE_PRIVATE_URL=postgresql://${{psotgres}}:${{xxx}}@${{RAILWAY_PRIVATE_DOMAIN}}:5432/${{PGDATABASE}}

DATABASE_URL=postgresql://${{postgres}}:${{xxx}}@${{RAILWAY_TCP_PROXY_DOMAIN}}:${{RAILWAY_TCP_PROXY_PORT}}/${{PGDATABASE}}

PGDATA=/var/lib/postgresql/data/pgdata

PGDATABASE=DB

PGHOST=${{RAILWAY_TCP_PROXY_DOMAIN}}

PGPASSWORD=xxxx

PGPORT=${{RAILWAY_TCP_PROXY_PORT}}

PGPRIVATEHOST=${{RAILWAY_PRIVATE_DOMAIN}}

PGUSER=postgres

POSTGRES_DB=DB

POSTGRES_PASSWORD=xxxx

POSTGRES_USER=postgres

SSL_CERT_DAYS=820

brody
EMPLOYEE

2 years ago

This is an English only community, please use English only.

tatiana-vieira
HOBBYOP

2 years ago

I actually need help with these, what are the main ones? I backed up my postgres 16 db.sql database. But I configured the variables and it didn't work?DATABASE_PRIVATE_URL=postgresql://${{psotgres}}:${{xxx}}@${{RAILWAY_PRIVATE_DOMAIN}}:5432/${{PGDATABASE}}

DATABASE_URL=postgresql://${{postgres}}:${{xxx}}@${{RAILWAY_TCP_PROXY_DOMAIN}}:${{RAILWAY_TCP_PROXY_PORT}}/${{PGDATABASE}}

PGDATA=/var/lib/postgresql/data/pgdata

PGDATABASE=DB

PGHOST=${{RAILWAY_TCP_PROXY_DOMAIN}}

PGPASSWORD=xxxx

PGPORT=${{RAILWAY_TCP_PROXY_PORT}}

PGPRIVATEHOST=${{RAILWAY_PRIVATE_DOMAIN}}

PGUSER=postgres

POSTGRES_DB=DB

POSTGRES_PASSWORD=xxxx

POSTGRES_USER=postgres

SSL_CERT_DAYS=820
Loading...