Re: Large Database Restore - Mailing list pgsql-general

From Michael Nolan
Subject Re: Large Database Restore
Date
Msg-id 4abad0eb0705171449o34e9b48dyf11ade61d0eb3b1f@mail.gmail.com
Whole thread Raw
In response to Re: Large Database Restore  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Large Database Restore
List 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


pgsql-general by date:

Previous
From: Glen Parker
Date:
Subject: Re: Vacuum non-clustered tables only
Next
From: Reece Hart
Date:
Subject: Re: Vacuum non-clustered tables only