pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexey Bobkov <bax@sunet.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump/pg_restore
Date: Mon, 12 Jan 2004 18:01:49 +0300
Message-ID: <4002B6DD.6090206@sunet.ru> (raw)
In-Reply-To: <28375.1073918818@sss.pgh.pa.us>
References: <400288CC.4050005@sunet.ru>
	<28375.1073918818@sss.pgh.pa.us>

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




view thread (12+ messages)  latest in thread

Message-ID: <4002B6DD.6090206@sunet.ru>
Permalink:  ../4002B6DD.6090206@sunet.ru/
Also on:    postgresql.org/message-id/4002B6DD.6090206@sunet.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: bax@sunet.ru, tgl@sss.pgh.pa.us
  Subject: Re: pg_dump/pg_restore
  In-Reply-To: <4002B6DD.6090206@sunet.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox