Re: [ADMIN] Postgres on NAS/NFS

2011-02-16 Thread Bruce Momjian
Bryan Keller wrote: I am considering running a Postgres with the database hosted on a NAS via NFS. I have read a few things on the Web saying this is not recommended, as it will be slow and could potentially cause data corruption. My goal is to have the database on a shared filesystem so in

Re: [ADMIN] Postgres on NAS/NFS

2011-02-16 Thread Greg Smith
Bryan Keller wrote: It sounds like NFS is a viable solution nowadays. I a still going to shoot for using iSCSI, given it is a block-level protocol rather than file-level, it seems to me it would be better suited to database I/O. Please digest carefully where Joe Conway pointed out that it

Re: [ADMIN] Postgres on NAS/NFS

2011-02-16 Thread Joshua D. Drake
On Wed, 2011-02-16 at 15:56 -0500, Greg Smith wrote: Bryan Keller wrote: It sounds like NFS is a viable solution nowadays. I a still going to shoot for using iSCSI, given it is a block-level protocol rather than file-level, it seems to me it would be better suited to database I/O.

Re: [ADMIN] Postgres on NAS/NFS

2011-02-14 Thread Stuart Bishop
On Thu, Feb 10, 2011 at 2:59 AM, Bryan Keller brya...@gmail.com wrote: I am considering running a Postgres with the database hosted on a NAS via NFS. I have read a few things on the Web saying this is not recommended, as it will be slow and could potentially cause data corruption. Its not

Re: [ADMIN] Postgres on NAS/NFS

2011-02-14 Thread Bryan Keller
Thanks for the feedback. It sounds like NFS is a viable solution nowadays. I a still going to shoot for using iSCSI, given it is a block-level protocol rather than file-level, it seems to me it would be better suited to database I/O. On Feb 14, 2011, at 2:07 AM, Stuart Bishop wrote: On Thu,

Re: [ADMIN] Postgres on NAS/NFS

2011-02-14 Thread Scott Marlowe
On Mon, Feb 14, 2011 at 11:05 AM, Bryan Keller brya...@gmail.com wrote: Thanks for the feedback. It sounds like NFS is a viable solution nowadays. I a still going to shoot for using iSCSI, given it is a block-level protocol rather than file-level, it seems to me it would be better suited to

[ADMIN] Postgres on NAS/NFS

2011-02-11 Thread Bryan Keller
I am considering running a Postgres with the database hosted on a NAS via NFS. I have read a few things on the Web saying this is not recommended, as it will be slow and cause data corruption. My goal is to have the database on a shared filesystem so in case of server failure, I can start up a

[ADMIN] Postgres with NAS/NFS

2011-02-11 Thread Bryan Keller
I am considering running a Postgres with the database hosted on a NAS via NFS. I have read a few things on the Web saying this is not recommended, as it will be slow and could potentially cause data corruption. My goal is to have the database on a shared filesystem so in case of server

Re: [ADMIN] Postgres on NAS/NFS

2011-02-11 Thread Joseph Conway
On 2/11/11 9:09 AM, Frederiko Costa wrote: Paying close attention to details to avoid any corruption issue in a shared environment, I don't think it would be a problem going for NFS. FYI -- beware of NFS related kernel bugs in recent Red Hat 5.x kernels:

Re: [ADMIN] Postgres on NAS/NFS

2011-02-10 Thread CS DBA
On 02/09/2011 03:49 PM, Jim Mlodgenski wrote: On Wed, Feb 9, 2011 at 2:59 PM, Bryan Kellerbrya...@gmail.com wrote: I am considering running a Postgres with the database hosted on a NAS via NFS. I have read a few things on the Web saying this is not recommended, as it will be slow and could

[ADMIN] Postgres on NAS/NFS

2011-02-09 Thread Bryan Keller
I am considering running a Postgres with the database hosted on a NAS via NFS. I have read a few things on the Web saying this is not recommended, as it will be slow and could potentially cause data corruption. My goal is to have the database on a shared filesystem so in case of server

Re: [ADMIN] Postgres on NAS/NFS

2011-02-09 Thread Anibal David Acosta
: [ADMIN] Postgres on NAS/NFS I am considering running a Postgres with the database hosted on a NAS via NFS. I have read a few things on the Web saying this is not recommended, as it will be slow and could potentially cause data corruption. My goal is to have the database on a shared filesystem so

Re: [ADMIN] Postgres on NAS/NFS

2011-02-09 Thread Jim Mlodgenski
On Wed, Feb 9, 2011 at 2:59 PM, Bryan Keller brya...@gmail.com wrote: I am considering running a Postgres with the database hosted on a NAS via NFS. I have read a few things on the Web saying this is not recommended, as it will be slow and could potentially cause data corruption. My goal is