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?
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 a front to the above mentioned tools.
There is no (official) tool "backup" or "restore" like you seem to be implying. You are probably confusing terms.