| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Botao Pan <panbot(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: xlog vs. shmfs |
| Date: | 2009-04-20 14:13:35 |
| Message-ID: | 20090420141335.GB29747@calyx.svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2009-04-20 14:27:45 | Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types? |
| Previous Message | Botao Pan | 2009-04-20 13:28:20 | xlog vs. shmfs |