Re: xlog vs. shmfs - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: xlog vs. shmfs
Date
Msg-id 20090420141335.GB29747@calyx.svana.org
Whole thread Raw
In response to xlog vs. shmfs  (Botao Pan <panbot@gmail.com>)
List pgsql-general
On Mon, Apr 20, 2009 at 09:28:20PM +0800, Botao Pan wrote:
> I know that it's guaranteed to cause problems when putting xlog in a
> disk mounted from shared memory, but in what scale? Am I looking at
> data loss or full database cluster corruption? I'm running postgresql
> 8.2.4.

There is no essential difference between the data in your user tables
and the data in the catalogs that let you read your own data. So
corruption could be anything between losing some data in your tables to
complete wiping out of columns or tables or even the entire DB (if
you're unlucky).

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: paulo matadr
Date:
Subject: Error stranger
Next
From: Robson Fidalgo
Date:
Subject: Re: [DOCS] Postgresql 8.3X supports Arrays of Composite Types?