Don't they essentially do the same thing by storing all the data in a file and dumping it into another database? Is it that
pg_dump just adds the data on to whatever is already there and restore deletes everything and then dumps it in?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Mar 19 '13 at 2:03
This question came from our site for professional and enthusiast programmers.
To restore, you can either use
The "Backup" and "Restore" options of pgAdmin are just fronts to the above mentioned tools.
There is no (official) tool "backup" or "restore" like you seem to be implying. You are probably confusing terms.