What's the difference between restoring a dump file with pg_restore or psql < dump.sql?
Loading
What's the difference between restoring a dump file with pg_restore or psql < dump.sql?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rajanikant HawaldarPosted Sep 5, 2021, 4:33 PM
A different types of dumps require different tools. Pg_restore would not load just .sql, and it's not that simple to put .tar or dir to the psql.