Re: [GENERAL] Advice on contingency plan for DAS array with separate local WAL drives

2010-06-14 Thread Greg Smith
Jeff Amiel wrote: Recently migrated to a shiny new 8.4.4 postgres instancedata stored on attached storage array. Transaction logs stored on 2 local mirrored drives (local to the database server itself) for best performance. Have you benchmarked that this really helps? Splitting the W

Re: [GENERAL] Advice on contingency plan for DAS array with separate local WAL drives

2010-06-14 Thread Jeff Amiel
On 6/14/10 8:05 AM, "Jeff Amiel" wrote: > What is recommended in terms of prep/switchover in this instance? Should we > be rsyncing or using built-in wal-log shipping of these transaction logs to > our stand-by server? Simply pop out these drives and hand-move them to the > standby-server? (a

[GENERAL] Advice on contingency plan for DAS array with separate local WAL drives

2010-06-14 Thread Jeff Amiel
Recently migrated to a shiny new 8.4.4 postgres instancedata stored on attached storage array. Transaction logs stored on 2 local mirrored drives (local to the database server itself) for best performance. While we are replicating (using slony) to our DR site, our first-choice plan (in the