Re: [GENERAL] Shared disk storage

2005-09-07 Thread Jim C. Nasby
On Wed, Sep 07, 2005 at 12:19:19AM -0400, Tom Lane wrote: Having said that, I'm not sure I believe in filesystem locks as doing much to improve security in the case of multiple hosts attached to a SAN filesystem. Does the locking work at all across hosts, and if it does, does the lock get

Re: [GENERAL] Shared disk storage

2005-09-07 Thread Peter Nixon
Jim C. Nasby wrote: On Wed, Sep 07, 2005 at 12:19:19AM -0400, Tom Lane wrote: Having said that, I'm not sure I believe in filesystem locks as doing much to improve security in the case of multiple hosts attached to a SAN filesystem. Does the locking work at all across hosts, and if it does,

Re: [GENERAL] Shared disk storage

2005-09-07 Thread Tom Lane
Bruno Wolff III [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] wrote: Well, if you know any vendors who move postmaster.pid out of the PGDATA directory, let us know so we can knock some sense into their heads. I thought Fedora did, but there are actually two files, one in /var/run

Re: [GENERAL] Shared disk storage

2005-09-06 Thread Bruno Wolff III
On Mon, Sep 05, 2005 at 12:20:24 +0300, Peter Nixon [EMAIL PROTECTED] wrote: Hi List Does anyone have any comments, HOWTOs and experience running multiple Postgres servers with a shared disk (SAN) in a Hot standby configuration? Can someone please point me in the direction of any docs on

Re: [GENERAL] Shared disk storage

2005-09-06 Thread Jim C. Nasby
On Tue, Sep 06, 2005 at 10:13:33AM -0500, Bruno Wolff III wrote: On Mon, Sep 05, 2005 at 12:20:24 +0300, Peter Nixon [EMAIL PROTECTED] wrote: Hi List Does anyone have any comments, HOWTOs and experience running multiple Postgres servers with a shared disk (SAN) in a Hot standby

Re: [GENERAL] Shared disk storage

2005-09-06 Thread Alvaro Herrera
On Tue, Sep 06, 2005 at 01:47:42PM -0500, Jim C. Nasby wrote: On Tue, Sep 06, 2005 at 10:13:33AM -0500, Bruno Wolff III wrote: On Mon, Sep 05, 2005 at 12:20:24 +0300, Peter Nixon [EMAIL PROTECTED] wrote: Hi List Does anyone have any comments, HOWTOs and experience running multiple

Re: [GENERAL] Shared disk storage

2005-09-06 Thread Bruno Wolff III
On Tue, Sep 06, 2005 at 13:47:42 -0500, Jim C. Nasby [EMAIL PROTECTED] wrote: On Tue, Sep 06, 2005 at 10:13:33AM -0500, Bruno Wolff III wrote: On Mon, Sep 05, 2005 at 12:20:24 +0300, Peter Nixon [EMAIL PROTECTED] wrote: Hi List Does anyone have any comments, HOWTOs and

Re: [GENERAL] Shared disk storage

2005-09-06 Thread Jim C. Nasby
On Tue, Sep 06, 2005 at 02:58:52PM -0500, Bruno Wolff III wrote: On Tue, Sep 06, 2005 at 13:47:42 -0500, Jim C. Nasby [EMAIL PROTECTED] wrote: On Tue, Sep 06, 2005 at 10:13:33AM -0500, Bruno Wolff III wrote: On Mon, Sep 05, 2005 at 12:20:24 +0300, Peter Nixon [EMAIL PROTECTED] wrote:

Re: [GENERAL] Shared disk storage

2005-09-06 Thread Bruno Wolff III
On Tue, Sep 06, 2005 at 17:01:41 -0500, Jim C. Nasby [EMAIL PROTECTED] wrote: Maybe it would be better to keep this in PGDATA (or even a duplicate copy). Holding a write lock on the file should also help ensure that you can tell if it's stale or not. And the end user can do that if they

Re: [GENERAL] Shared disk storage

2005-09-06 Thread Tom Lane
Bruno Wolff III [EMAIL PROTECTED] writes: Jim C. Nasby [EMAIL PROTECTED] wrote: Maybe it would be better to keep this in PGDATA (or even a duplicate copy). Holding a write lock on the file should also help ensure that you can tell if it's stale or not. And the end user can do that if they

Re: [GENERAL] Shared disk storage

2005-09-06 Thread Bruno Wolff III
On Wed, Sep 07, 2005 at 00:19:19 -0400, Tom Lane [EMAIL PROTECTED] wrote: Well, if you know any vendors who move postmaster.pid out of the PGDATA directory, let us know so we can knock some sense into their heads. postmaster.pid is specifically a lock on the directory, and moving it

[GENERAL] Shared disk storage

2005-09-05 Thread Peter Nixon
Hi List Does anyone have any comments, HOWTOs and experience running multiple Postgres servers with a shared disk (SAN) in a Hot standby configuration? Can someone please point me in the direction of any docs on this subject? Thanks in Advance -- Peter Nixon http://www.peternixon.net/ PGP

Re: [GENERAL] Shared disk storage

2005-09-05 Thread shingav
[Peter Nixon wrote] : Hi List Does anyone have any comments, HOWTOs and experience running multiple Postgres servers with a shared disk (SAN) in a Hot standby configuration? Can someone please point me in the direction of any docs on this subject? Thanks in Advance For server