Skip to content

Instantly share code, notes, and snippets.

@thb

thb/Dump and restore PostgreSQL database

Last active August 29, 2015 14:07
Show Gist options
  • Save thb/99c8d98100caf6265579 to your computer and use it in GitHub Desktop.
Save thb/99c8d98100caf6265579 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Dump and restore PostgreSQL database
pg_dump {database} > {dump_name}.sql -U {dbuser} -h {host}
psql -p {port} -d {database} -U {dbuser} -W -f {dump_name}.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment