backup -restore question

From: Julie Nishimura <juliezain(at)hotmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: backup -restore question
Date: 2020-07-13 19:12:49
Message-ID: BYAPR08MB5014E2946B409EE7779468DCAC600@BYAPR08MB5014.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-07-13 19:32:10 Re: backup -restore question
Previous Message Jehan-Guillaume de Rorthais 2020-07-13 16:55:42 Re: Clustering solution ?