Copy PostgreSQL production database to a new Railway Postgres instance for testing

Question

Hello Railway Support,

I have a PostgreSQL database in production and I need to test a merge with new functionalities before making any changes to production.

For that, I would like to create a copy of the current production database — including all data, schema, constraints, indexes, and relationships — into a new PostgreSQL instance in another workspace/environment, so I can safely run integration and merge tests there first.

The database size is approximately 500 MB.

Could you please confirm:

1. Whether Railway supports cloning or copying a PostgreSQL database of this size into a new Postgres instance.
2. What is the recommended way to do it inside Railway.
3. Whether the copy can preserve the full schema, constraints, indexes, and data exactly as in production.
4. Whether there is any built-in tool, template, snapshot, backup restore, or migration workflow you recommend for this case.
5. Whether there are any limitations when copying between different workspaces or projects.

My goal is to create a safe testing environment identical to production before applying the merge.

Thank you in advance.

Best regards,  
Horacio Lampe