| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: backup -restore question |
| Date: | 2020-07-13 21:56:22 |
| Message-ID: | 4e073ca3-9813-0fdb-a31e-4bb55efd4dd5@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7/13/20 2:32 PM, Adrian Klaver wrote:
> 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.
What about this?
gunzip -c | foo.sql.gz | psql
--
Angular momentum makes the world go 'round.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Philippe Chenel | 2020-07-13 23:42:08 | Both side privileges |
| Previous 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 |