Moving PostgreSQL Database Host | Django | Page 1

urban marsh Jan 8, 2025, 1:38 PM

#

Hi! I'm currently trying to migrate an entire PostGres database from one host to another for my Django app.

What is the best way of doing this?
I've tried getting a dump and loading it into the app but I'm just hit with a world of errors regarding constraints etc. I also need to be certain of data integrity – nothing left behind!

zealous bramble Jan 8, 2025, 1:40 PM

#

pg_dump pg_restore

tiny folio Jan 8, 2025, 1:40 PM

#

pg_dump/pg_restore https://www.postgresql.org/docs/current/app-pgdump.html

fallow burrow Jan 8, 2025, 1:40 PM

#

shutdown the app, pqdump, import dump into new db, restart app with new server name ?

#Moving PostgreSQL Database Host