1. Download moc latest database dump from production server 2. extract the zip file 3. In local delete the database moc SELECT *, pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = moc 4. Delete the database - drop database moc; 5. import the database "c:\Program Files\PostgreSQL\14\bin"\psql -Upostgres -W moc < moc_prod27-10-2022.psql 6. Import the migrate_partner sql "c:\Program Files\PostgreSQL\14\bin"\psql -Upostgres -W moc < sql\migrate_partner.sql