Re: Large Database Restore

From: "Michael Nolan" <htfoot(at)gmail(dot)com>
To: "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Large Database Restore
Date: 2007-05-17 21:49:55
Message-ID: 4abad0eb0705171449o34e9b48dyf11ade61d0eb3b1f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I don't know if my database is typical (as there probably is no such thing),
but to restore a full dump (pg_dumpall) takes over 4 hours on my backup
server, but to restore a low level backup (about 35GB) and then process 145
WAL files (since Tuesday morning when the last low level backup was run)
took me around 2 hours today
--
Mike Nolan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-05-17 22:25:14 Re: 8.0, UTF8, and CLIENT_ENCODING
Previous Message Glen Parker 2007-05-17 21:49:49 Re: Vacuum non-clustered tables only