Re: [SQL] pg_xlog on separate drive

2006-12-04 Thread Travis Whitton
Thanks for the replies guys. I think I may be ok in my case though because I'll be importing data as a single daily batch from raw data. I'll be taking nightly backups, and in the event of a crash, I can simply restore from a recent backup and then reimport the raw data. I can now see why losing p

Re: [SQL] pg_xlog on separate drive

2006-12-04 Thread Markus Schaber
Hi, Travis, Travis Whitton wrote: > 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 simpl

Re: [SQL] pg_xlog on separate drive

2006-11-30 Thread Tom Lane
"Travis Whitton" <[EMAIL PROTECTED]> writes: > 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 Postgr

[SQL] pg_xlog on separate drive

2006-11-30 Thread Travis Whitton
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