Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 0026E1337B84
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun, 21 Nov 2010 23:21:57 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 01476-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 22 Nov 2010 03:21:50 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from spinlock.commandprompt.com (host-215.commandprompt.net
	[207.173.203.215])
	by mail.postgresql.org (Postfix) with ESMTP id 1B7011335B36
	for <pgsql-admin@postgresql.org>; Sun, 21 Nov 2010 23:21:50 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by spinlock.commandprompt.com (Postfix) with ESMTP id 047A1348023;
	Sun, 21 Nov 2010 19:21:45 -0800 (PST)
X-Virus-Scanned: Debian amavisd-new at commandprompt.com
Received: from spinlock.commandprompt.com ([127.0.0.1])
	by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1])
	(amavisd-new, port 10024)
	with ESMTP id 8uFQddPvzhA4; Sun, 21 Nov 2010 19:21:41 -0800 (PST)
Received: from [192.168.1.100] (unknown [71.94.248.62])
	by spinlock.commandprompt.com (Postfix) with ESMTPSA id 7F356348022;
	Sun, 21 Nov 2010 19:21:41 -0800 (PST)
Subject: Re: binary logs: a location other than pg_xlog??
From: "Joshua D. Drake" <jd@commandprompt.com>
Reply-To: jd@commandprompt.com
To: Lou Picciano <loupicciano@comcast.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-admin <pgsql-admin@postgresql.org>
In-Reply-To: 
 <167491417.901188.1290395393626.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
References: 
 <167491417.901188.1290395393626.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
Content-Type: text/plain; charset="UTF-8"
Organization: Command Prompt, Inc.
Date: Sun, 21 Nov 2010 19:21:20 -0800
Message-ID: <1290396080.10258.12401.camel@jd-desktop>
Mime-Version: 1.0
X-Mailer: Evolution 2.30.3 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201011/172
X-Sequence-Number: 36138

On Mon, 2010-11-22 at 03:09 +0000, Lou Picciano wrote:
> Really? Wouldn't it be good general practice to store the xlogs on a
> different filesystem - offering one further layer of protection, if
> you will? L 

Best practice is to move the xlogs to another filesystem but not for
protection (that is garnered by using RAID). It is for performance.
Xlogs are written sequentially and can greatly benefit from not being
where the data pages are as they are written randomly.

JD
> 
> 
> Thanks for your response. 
> 
> ----- Original Message ----- 
> From: "Tom Lane" <tgl@sss.pgh.pa.us> 
> To: "Lou Picciano" <loupicciano@comcast.net> 
> Cc: "pgsql-admin" <pgsql-admin@postgresql.org> 
> Sent: Sunday, November 21, 2010 7:54:55 PM 
> Subject: Re: [ADMIN] binary logs: a location other than pg_xlog?? 
> 
> Lou Picciano <loupicciano@comcast.net> writes: 
> > Admin Friends, Can someone tell me the conf variablee to change
> location of binary logs? Would like to store logs in a location other
> than pg_xlog in cluster data dir. 
> 
> There is no such setting. But if you're so inclined you can make 
> pg_xlog be a symlink to some other directory. 
> 
> regards, tom lane 
-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt