Re: pg_dump/pg_restore

From: Alexey Bobkov <bax(at)sunet(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump/pg_restore
Date: 2004-01-12 15:01:49
Message-ID: 4002B6DD.6090206@sunet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom Lane wrote:

> Alexey Bobkov <bax(at)sunet(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2004-01-12 15:48:15 Re: Cluster in users home
Previous Message Tom Lane 2004-01-12 14:46:58 Re: pg_dump/pg_restore