Copy postgres prod db data to dev environment
Hi,
I want to copy my prod db data to my dev envirnment db, i tried using
$ pg_dump -U user1 dbname_old_db | psql -U user2 dbname_new_db but getting
$ pg_dump: error: connection to server at "[my railwaydb host]" (...ip), port [my port] failed: Operation timed out
Is the server running on that host and accepting TCP/IP connections?
for either db host. can anyone help me out perhaps?3 Replies
Project ID:
a7634f0c-f9d1-4ef7-9dd8-e651539a7ea0a7634f0c-f9d1-4ef7-9dd8-e651539a7ea0