fastest dump/restore

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: fastest dump/restore
Date: 2014-01-26 17:27:33
Message-ID: 3467D77F-DA2C-4B80-A837-D050073BC9A7@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there an article anywhere which documents everything the current state of the art for the fastest dump/restore? What dump/restore format & options? What things to tweak in the config? I've picked up a few bits here and there along the line, but was just wondering if there's a comprehensive source of current advice.

(I want to do a prophylactic dump/restore, after a middle-of-the-day OS crash caused by a third-party in-kernel driver--which I am going to remove now.)

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sameer Kumar 2014-01-27 03:10:08 Re: Fully-automatic streaming replication failover when master dies?
Previous Message antono124 2014-01-26 17:02:10 Composite type