restore time - Mailing list pgsql-admin

From lists
Subject restore time
Date
Msg-id 012f01c2f955$a2c74560$32faabc8@insyde
Whole thread Raw
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Murthy Kambhampaty
Date:
Subject: Re: Speed & Memory Management
Next
From: Juan Miguel
Date:
Subject: Re: Speed & Memory Management