pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert Treat <xzilla@users.sourceforge.net>
To: lists <lists@insyde.com.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_restore problem
Date: 31 Mar 2003 08:43:16 -0500
Message-ID: <1049118197.13798.1712.camel@camel> (raw)
In-Reply-To: <003201c2f526$8e88fd60$8efaabc8@insyde>
References: <003201c2f526$8e88fd60$8efaabc8@insyde>

Are you sure your restoring to an empty database? If you try to restore
your dump into the database you dumped it from (without first
drop/create) it will take forever as you'll have all kinds of data
collisions (imagine every insert into a table erroring out due to
duplicate primary key).

As for the -Ft vs. -Fc size question, the tar format is not a compressed
format, while the "c"ustom format is.

Robert Treat


On Fri, 2003-03-28 at 07:35, lists wrote:
> Hi,
>  
> I've a dump I made with the command:
>  
> pg_dump -a -b -Fc -f DB.dump -o -v DB
>  
> then I try to restore with:
>  
> pg_restore -a -d DB2 -Fc -o -v DB.dump
>  
> This database is about 1.5Gb big. 
>  
> The dump takes abou 1 hour, but the restore takes forever!
>  
> Last time I ran it, it takes more than 10 hours, when I gave up 
> and stopped the process.
>  
> Tried with both Ft and Fc. 
>  
> Another doubt: Why a dump of this DB with Ft has about the
> same size of the original DB(1.5GB) and with Fc it has about 50MB?
>  
> My system is:
> P3 1Ghz, 1GB ram, Win2k, Postgres 7.2.2 
> Free space ~5GB.
>  
> TIA,
>  
> Ricardo.




view thread (17+ messages)  latest in thread

Message-ID: <1049118197.13798.1712.camel@camel>
Permalink:  ../1049118197.13798.1712.camel@camel/
Also on:    postgresql.org/message-id/1049118197.13798.1712.camel@camel

 · 

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: xzilla@users.sourceforge.net, lists@insyde.com.br
  Subject: Re: pg_restore problem
  In-Reply-To: <1049118197.13798.1712.camel@camel>

* 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