pg_xlog on separate drive

From: "Travis Whitton" <tinymountain(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_xlog on separate drive
Date: 2006-11-30 15:50:46
Message-ID: cf9b4f3e0611300750o29aa04d0if2a44e26252cfddd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hey guys, sorry if this is slightly OT for this list, but I figure it's a
simple question. If I'm storing pg_xlog on a second non-redundant drive
using the symlink method and the journal drive were to crash, how difficult
is recovery? Will Postgresql simply be able to reinitialize the journal on a
new drive and carry on, or is there more to it than that? I realize any
pending transactions would be lost, but that's not a huge concern for me
because everything I'm importing comes from raw data.

Thanks,
Travis

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Herrin 2006-11-30 16:02:20 Re: consistent random order
Previous Message Shane Ambler 2006-11-30 15:10:53 Re: Autovaccum