-> To restore the custom dump then we should always use pg_restore
Syntax:instllation_location -Fc -d db_name port location_of_dump_file
cmd:
/usr/local/pgsql/bin/pg_restore -Fc -d sandbox_db -p 5435 /DB/sandbox_db_21_nov_17_custom
-> To restore the plain dump then we should use psql cmd.
cmd:/usr/local/pgsql/bin/pg_restore -Fc -d sandbox_db -p 5435
-f /DB/DB_BACKUP/sandbox_db_21_nov_17
To restore the single table
cmd:/usr/local/pgsql/bin/pg_restore -Fc -d sandbox_db -p 5435
-f /DB/DB_BACKUP/uixml_backup_table