Hello there,
One of our PostgreSQL 9.4.1 databases has been backed up as *.gz file with the compression 9 "pg_dump -Z 9". What is the right format of restore this file when needed? Can I run the restore from a compressed file or I need to unzip the file first, then run pg_restore? Thanks