From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: backup -restore question |
Date: | 2020-07-14 00:37:57 |
Message-ID: | 6ce138d2-0b27-30ab-5da0-6c9cc0bb69fe@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 7/13/20 2:56 PM, Ron wrote:
> 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
>
gunzip -c | test_plain.gz | psql -d test_gz -U postgres
bash: test_plain.gz: command not found
gzip: compressed data not read from a terminal. Use -f to force
decompression.
For help, type: gzip -h
Null display is "NULL".
I think what you want is:
gunzip -c test_plain.gz | psql -d test_gz -U postgres
Null display is "NULL".
SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
CREATE SCHEMA
....
In any case that will only work if the *.gz file is a compressed plain
text format. My suspicion is it is, still I had to allow the possibility
that it is a custom format file that someone hung a gz extension on.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-07-14 02:32:42 | Re: PostgresQL 12 - could not connect to server: FATAL: the database system is in recovery mode |
Previous Message | David G. Johnston | 2020-07-13 23:46:08 | Re: Both side privileges |