Restore PostgreSQL data into existing database

Question

Of course, the situation is such that I need a solution as soon as possible.

I have database in production in which I accidentally ran a script that deleted records that I did not want deleted. Thankfully, I have a backup of the data before doing so as an *.sql file. As such, I can manipulate it on my development environment to obtain only the data or even a dump file from pg_dump.

Whenever I try to use pg_restore or psql to import the file, it does not seem to import the missing rows. It throws many errors, which I expect since it has duplicate data. But I don't care about the duplicate data; I want the non-duplicated data back into the database.

Does anyone have any idea how to about doing this?

teppic · Accepted Answer · 2018-03-14 19:25:07Z

2

pg_dump with --inserts. This will get you a script with individual inserts for the rows instead of single COPY statements.

Run the script with AUTOCOMMIT on (the default).

answered Mar 14, 2018 at 19:25

teppic

7,3161 gold badge34 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Restore PostgreSQL data into existing database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related