From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: backup -restore question |
Date: | 2020-07-14 04:18:02 |
Message-ID: | cdc57c38-467c-947e-ded2-9779f77dadb2@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 7/13/20 7:37 PM, Adrian Klaver wrote:
> 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
>
The hazards of not testing code before posting... :)
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2020-07-14 06:50:40 | Re: Doubt in mvcc |
Previous 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 |