Re: Fastest way to restore a database

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Robert Treat <robert(at)omniti(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, William Garrison <postgres(at)mobydisk(dot)com>
Subject: Re: Fastest way to restore a database
Date: 2008-09-12 20:56:19
Message-ID: Pine.GSO.4.64.0809121655001.25027@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 12 Sep 2008, Robert Treat wrote:

> Don't forget to bump up checkpoint_timeout along with that... actually, I
> blogged a couple of times on this topic

And with that there's enough information to start a dedicated page on this
topic: http://wiki.postgresql.org/wiki/Bulk_Loading_and_Restores

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Todd 2008-09-12 21:13:00 Re: Windows ODBC Driver
Previous Message Blazej 2008-09-12 20:37:09 Re: psql scripting tutorials