Re: pg_dump/pg_restore - Mailing list pgsql-admin

From Alexey Bobkov
Subject Re: pg_dump/pg_restore
Date
Msg-id 4002B6DD.6090206@sunet.ru
Whole thread Raw
In response to Re: pg_dump/pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom Lane wrote:

> Alexey Bobkov <bax@sunet.ru> writes:
>
>>I have been dumping my database with next options:
>>pg_dump -f /path_to_database/backup/db_backup.file -Z 9 database_name
>>and get db_backup.file file.
>
>
> This is giving you a plain SQL-script dump file.  To restore, feed it
> into psql.
No :)
this is giving me gzip compressed file
I found solution for my problem.
This is step by step instruction for me :)

mv db_backup.file db_backup.file.gz
gzip -g db_backup.file.gz

:)

thanks

--
Alexey Bobkov
e-Style ISP
tel/fax +7 095 7969797


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump/pg_restore
Next
From: Bruno Wolff III
Date:
Subject: Re: Cluster in users home