agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: lists <lists@insyde.com.br>
To: pgsql-admin@postgresql.org
Subject: restore time
Date: Wed, 2 Apr 2003 17:22:50 -0300
Message-ID: <012f01c2f955$a2c74560$32faabc8@insyde> (raw)

Hi, I'm trying to restore a database, btu I couldn't so far.
It's taking more than 14 hours to complete, and we make 
a valuation of more than 22 hours to complete restore a 1,5 Gb
database, from a 60 mb dump.

This only happen when I use the binary mode (-Fc) with plain text
it takes at most 3 hours. I need this mode because of the lo types.

Is anyone having this kind of problem? How long your dump/restore 
takes to complete? What's the size of the DB?

Is there any workaround?

TIA,
Ricardo.

view thread (2+ messages)  latest in thread

Message-ID: <012f01c2f955$a2c74560$32faabc8@insyde>
Permalink:  ../012f01c2f955$a2c74560$32faabc8@insyde/
Also on:    postgresql.org/message-id/012f01c2f955$a2c74560$32faabc8@insyde

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: lists@insyde.com.br
  Subject: Re: restore time
  In-Reply-To: <012f01c2f955$a2c74560$32faabc8@insyde>

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

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