Skip to content

Instantly share code, notes, and snippets.

@vivg

vivg/dump_and_restore

Last active August 29, 2015 14:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save vivg/db3514a2be15524975e6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save vivg/db3514a2be15524975e6 to your computer and use it in GitHub Desktop.
Download ZIP
Take postgresql dump and restore
Raw
dump_and_restore
#take full dump
pg_dump -i -U user_name -F t -b -v -f "prod.backup" db_name
#restore specific table
pg_restore -i -U user_name -d db_name -t table_name -v "prod.backup"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment