Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 71C699FA0FB for ; Thu, 30 Nov 2006 11:51:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 30910-04 for ; Thu, 30 Nov 2006 11:50:44 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id A605F9F9DAD for ; Thu, 30 Nov 2006 11:50:50 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1931340ugf for ; Thu, 30 Nov 2006 07:50:48 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=kZGE93TdxQ4e66Xs//7vpv3lT9Vw6r3Hm89M14kMOyb3TJZCEj1CpOvQJ7VM1MlZGqsTqu6jaVilr+P/cw1fgrbghJaOyaXDVVisTSDd+tcvRECp/sA4A891h09WRBZQC+Zp2pise0UQvmp1Zv8j+zyR6oWTJ0PbTQ2kHDHvutM= Received: by 10.78.97.7 with SMTP id u7mr3681604hub.1164901846937; Thu, 30 Nov 2006 07:50:46 -0800 (PST) Received: by 10.78.105.20 with HTTP; Thu, 30 Nov 2006 07:50:46 -0800 (PST) Message-ID: Date: Thu, 30 Nov 2006 10:50:46 -0500 From: "Travis Whitton" To: pgsql-sql@postgresql.org Subject: pg_xlog on separate drive MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_46545_31486495.1164901846824" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/294 X-Sequence-Number: 26946 ------=_Part_46545_31486495.1164901846824 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_46545_31486495.1164901846824 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
------=_Part_46545_31486495.1164901846824--