Thread: Would it be OK if I put db file on a ext2 filesystem?

Dear,
    I think database has its own operation journal, and different journal
filesystem does give different performance. So if I put database file on a
non-journal filesystem, would it be safe? Does this like using a raw device?

Thanks.

On Dec 11, 2007 9:55 PM, Magicloud Wang <magicloud.magiclouds@gmail.com> wrote:
> Dear,
>         I think database has its own operation journal, and different journal
> filesystem does give different performance. So if I put database file on a
> non-journal filesystem, would it be safe? Does this like using a raw device?

you can put pg_xlog on a non-journaling fs I believe, but the main
data dir needs to be journaled.

Me, I put them both on journaled file systems.