Hey friends. I need to copy a Postgres database on the same server.
So if I have a source
database, I want to make a source_copy
database with all of the same data and tables.
CREATE DATABASE source_copy WITH TEMPLATE source
does not work because it will lock the table and does not allow additional connections. This makes things excessively complicated, and I’ve not figured out how to make this work with Ecto.
Also it is a managed database so pg_dump
isn’t great either since the DB is HUGE and I don’t want to pay the networking transfer penalty. ( Plus reloading the dump has a penalty as well )
These are for dev environments so they do not have to be perfect.
Any recommendations for doing this?