| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Julie Nishimura <juliezain(at)hotmail(dot)com>, 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: | Re: backup -restore question |
| Date: | 2020-07-13 19:32:10 |
| Message-ID: | 97dbd799-7a6c-d0bc-deb2-fd56d3cda7a9@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7/13/20 12:12 PM, Julie Nishimura wrote:
> 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
It depends on whether you dumped using the custom format -Fc or plain(no
-F or -Fp). If the custom format then you run pg_restore against it. If
the plain format then you will to unzip first then feed the file to psql.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | FOUTE K. Jaurès | 2020-07-13 20:14:08 | Re: PostgresQL 12 - could not connect to server: FATAL: the database system is in recovery mode |
| Previous Message | Julie Nishimura | 2020-07-13 19:12:49 | backup -restore question |