Re: binary logs: a location other than pg_xlog??

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

Thanks for your response.

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lou Picciano" <loupicciano(at)comcast(dot)net>
Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Sent: Sunday, November 21, 2010 7:54:55 PM
Subject: Re: [ADMIN] binary logs: a location other than pg_xlog??

Lou Picciano <loupicciano(at)comcast(dot)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