[snip] I would suggest checking out pg_loader it is designed to deal with this scenario.
psycopg by date:
Соглашаюсь с условиями обработки персональных данных