Restoring the PostgreSQL database

To restore the PostgreSQL database from the dump:On the PT Feeds host, move the dump to the /var/lib/docker/volumes/pt-feeds_pgbackup/_data directory.To restore the database from a TAR archive, run the following command:

docker exec -it pt-feeds_db_1 pg_restore -U ptfeeds -d ptfeeds -Ft /data/postgres/backup/ptfeeds.tar

To restore the database from a BAK archive, run the following command:

docker exec -it pt-feeds_db_1 pg_restore -U ptfeeds -d ptfeeds -Ft /data/postgres/backup/ptfeeds.bak

The PostgreSQL database is restored.