How to restore pgdumpall data
I regularly take pgdumpall from production database and restore the staging database.
Production database size is 4.5 GB.
After restoring the staging database size is incremented.
The following command is used to restore pgdumpall file.
psql -U postgres -f dbdumpall
My aim is to sync up production database and staging database.