Skip to content

Instantly share code, notes, and snippets.

View meagar's full-sized avatar

meagar

38 followers · 4 following
View GitHub Profile
@meagar
meagar / fast_restore_large_postgres_database.md
Created August 14, 2013 17:19

This is a really fast way to restore a large Postgres database by omiting the indexes and restoring them later (if necessary).

  1. Dump database.

    pg_dump -Fc --no-owner my_db -f ~/my_db.dump

  2. Create the summary files. One for the indexes and another for everything else.

pg_restore -l ~/my_db.dump | grep -v 'INDEX public' > ~/my_db.list

@meagar
meagar / fast_restore_large_postgres_database.md
Last active December 21, 2015 02:09

This is a really fast way to restore a large Postgres database by omiting the indexes and restoring them later (if necessary).

  1. Dump database.

     pg_dump -Fc --no-owner my_db -f ~/my_db.dump

  2. Create the summary files. One for the indexes and another for everything else.

pg_restore -l ~/my_db.dump | grep -v 'INDEX public' > ~/my_db.list