Restore Postgres database using pg_restore

Posted on 24-04-2014 19:59 by graham
To restore a database from backup file created using pg_dump, use the following command:
pg_restore -i -h localhost -p 5432 -U <username> -d <database-name> -v "<backup-file>"


Add comment

Has this tutorial been helpful to you? Or do you see anything wrong? We appreciate your opinion!
Your comment:
Show formatting hints
HTML is disallowed, but in your text you can use the following markup
  • [code][/code] for a block of code
  • [tt][/tt] for inline code
  • [link]link href|link anchor[/link] for links
  • [b][/b] for bold text
+ Ask a question
If you have a technical question related to programming and computers, ask it here. Other users will help you solve it!
Unanswered questions
Share your knowledge by helping others solve their problems