fastest dump/restore - Mailing list pgsql-general

From Scott Ribe
Subject fastest dump/restore
Date
Msg-id 3467D77F-DA2C-4B80-A837-D050073BC9A7@elevated-dev.com
Whole thread Raw
Responses Re: fastest dump/restore
List pgsql-general
Is there an article anywhere which documents everything the current state of the art for the fastest dump/restore? What
dump/restoreformat & 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--whichI am going to remove now.) 

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






pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: pg_dump: dumpBlobs(): could not open large object: ERROR: large object 27729547 does not exist
Next
From: Sameer Kumar
Date:
Subject: Re: Fully-automatic streaming replication failover when master dies?