Restore database with pg_restore in PostgreSQL docker run

Question

I need to restore the PostgreSQL .backup file while running PostgreSQL docker image. I am able to restore the database with .sql file but it is taking too much time because the file size is more than 100mb and it will fire 500000 insert statement. Is there any other way to restore database much faster inside docker container?

cohenjo · Accepted Answer · 2016-08-02 17:59:30Z

1

First, pg_dump/pg_restore can use copy which is much faster than the insert option look at the archive option.

If backup/restore take too long then you can use file system backups. It would allow for incremental backups which are (if frequent enough) faster to restore.

That being said, 100mb is rather small and you should be able to recover quickly with the copy option.

Btw, if you're looking for a docker based solution, you could commit the container (or data container if you use it) and then restore by simply pulling the new image.

Regards Jony

answered Aug 2, 2016 at 17:59

cohenjo

5863 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

Restore database with pg_restore in PostgreSQL docker run

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