[ADMIN] postgresql cluster on SAN

2005-09-20 Thread Robert Ngo
Hi, Can i create create a cluster of postgresql server by sharing the database file on a SAN? I am also looking into slony but slony replicate data to each server and my database will potentially have terabytes of data. I am thinking about a solution where a cluster of database server will share

[ADMIN] postgresql cluster on SAN

2005-09-22 Thread Robert Ngo
Hi, Can i create create a cluster of postgresql server by sharing the database file on a SAN? I am also looking into slony but slony replicate data to each server and my database will potentially have terabytes of data. I am thinking about a solution where a cluster of database server will sh

Re: [ADMIN] postgresql cluster on SAN

2005-09-20 Thread Chris Browne
[EMAIL PROTECTED] (Robert Ngo) writes: > Can i create create a cluster of postgresql server by sharing the > database file on a SAN? I am also looking into slony but slony replicate > data to each server and my database will potentially have terabytes of > data. I am thinking about a solution where

Re: [ADMIN] postgresql cluster on SAN

2005-09-20 Thread Robert Ngo
Robert Ngo wrote: Chris Browne wrote: [EMAIL PROTECTED] (Robert Ngo) writes: Can i create create a cluster of postgresql server by sharing the database file on a SAN? I am also looking into slony but slony replicate data to each server and my database will potentially have terabytes of d

Re: [ADMIN] postgresql cluster on SAN

2005-09-21 Thread Magnus Hagander
> Hi, > > Can i create create a cluster of postgresql server by sharing > the database file on a SAN? I am also looking into slony but > slony replicate data to each server and my database will > potentially have terabytes of data. I am thinking about a > solution where a cluster of database s

Re: [ADMIN] postgresql cluster on SAN

2005-09-21 Thread Chris Browne
[EMAIL PROTECTED] (Robert Ngo) writes: > Robert Ngo wrote: > >> Chris Browne wrote: >> >>> [EMAIL PROTECTED] (Robert Ngo) writes: >>> >>> Can i create create a cluster of postgresql server by sharing the database file on a SAN? I am also looking into slony but slony replicate d

Re: [ADMIN] postgresql cluster on SAN

2005-09-22 Thread Chris Travers
Robert Ngo wrote: Robert Ngo wrote: Chris Browne wrote: [EMAIL PROTECTED] (Robert Ngo) writes: Can i create create a cluster of postgresql server by sharing the database file on a SAN? I am also looking into slony but slony replicate data to each server and my database will potentially

Re: [ADMIN] postgresql cluster on SAN

2005-09-23 Thread Spiegelberg, Greg
ubject: Re: [ADMIN] postgresql cluster on SAN [EMAIL PROTECTED] (Robert Ngo) writes: > Can i create create a cluster of postgresql server by sharing the > database file on a SAN? I am also looking into slony but slony replicate > data to each server and my database will potentially have teraby

Re: [ADMIN] postgresql cluster on SAN

2005-09-23 Thread Chris Travers
Spiegelberg, Greg wrote: This is possible. Below is a brief recipe. 1. Use Veritas Storage Foundation HA with Cluster File System. 2. Have a volume with cfs available to 2 or more systems via SAN. 3. Install PostgreSQL and be sure PGDATA is on the cfs mount 4. Create a Storage Checkpoint of cf

Re: [ADMIN] postgresql cluster on SAN

2005-09-26 Thread Robert Ngo
How about i have one SAN storage for the slony master node and another SAN to be share by slave nodes that only do SELECT? Can Dell|EMC AX100i iscsi san with sata drive serve as storage for postgresql server, will there be problem in I/O performance? Chris Travers wrote: Spiegelberg, Greg wr

Re: [ADMIN] postgresql cluster on SAN

2005-09-26 Thread Chris Browne
[EMAIL PROTECTED] (Robert Ngo) writes: > How about i have one SAN storage for the slony master node and > another SAN to be share by slave nodes that only do SELECT? That seems like a reasonable sort of idea... > Can Dell|EMC AX100i iscsi san with sata drive serve as storage for > postgresql serv

Re: [ADMIN] postgresql cluster on SAN

2005-09-29 Thread Spiegelberg, Greg
ECTED] Sent: Friday, September 23, 2005 3:58 PM To: Spiegelberg, Greg; pgsql-admin@postgresql.org Subject: Re: [ADMIN] postgresql cluster on SAN Spiegelberg, Greg wrote: >This is possible. Below is a brief recipe. > >1. Use Veritas Storage Foundation HA with Cluster File System.