How to restore PostgreSQL database from .tar file?
- by Stephen
I have all PostgreSQL databases backed up during incremental backups using WHM, which creates a $dbName.tar file.
Data is stored in these .tar files, but I do not know how to restore it back into the individual databases via SSH. In particular the file location.
I have been using:
pg_restore -d client03 /backup/cpbackup/daily/client03/psql/client03.tar
which generates the error 'could not open input file: Permission denied'
Any assistance appreciated.