Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 30 Nov 2006 10:50:46 -0500
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
- Follow-Ups:
- Re: pg_xlog on separate drive
- From: Tom Lane
- Re: pg_xlog on separate drive
- Prev by Date: Re: Autovaccum
- Next by Date: Re: consistent random order
- Previous by thread: Autovaccum
- Next by thread: Re: pg_xlog on separate drive
- Indexes: