Re: postgresql cluster on SAN

Поиск
Список
Период
Сортировка
От Spiegelberg, Greg
Тема Re: postgresql cluster on SAN
Дата
Msg-id 82E74D266CB9B44390D3CCE44A781ED96B500D@POSTOFFICE.cranel.local
обсуждение исходный текст
Ответ на postgresql cluster on SAN  (Robert Ngo <robertngo@perridot.com>)
Ответы Re: postgresql cluster on SAN  (Chris Travers <chris@travelamericas.com>)
Список pgsql-admin
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 cfs mount (read-write virtual copy)
5. Bring up PostgreSQL on node1
6. Mount storage checkpoint on node2
7. Start PostgreSQL on node2

Drawbacks?  Heck yes.  There are many and you should understand the
nature of Veritas Storage Checkpoints before using.  I have tested it
though in conjunction with dblink() and some other proprietary API's we
use for load balancing and the potential is there to manage many large
SELECT's.

Greg


-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chris Browne
Sent: Tuesday, September 20, 2005 10:15 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] postgresql cluster on SAN

robertngo@perridot.com (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 a cluster of database
server
> will share database files on SAN, can this be done? I am also looking
> for a load balancing salution for the postgresql database. Any
sugestion?

What you wish can NOT be done.

There can only be ONE postmaster for each database cluster; you can
NOT have multiple servers sharing a single cluster.
--
(reverse (concatenate 'string "gro.gultn" "@" "enworbbc"))
http://cbbrowne.com/info/internet.html
"The real  romance is   out   ahead and   yet to come.    The computer
revolution hasn't started yet. Don't be misled by the enormous flow of
money into bad defacto standards for unsophisticated buyers using poor
adaptations of incomplete ideas." -- Alan Kay

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

В списке pgsql-admin по дате отправления:

Предыдущее
От: Aldor
Дата:
Сообщение: Re: COPY TO / COPY FROM
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: COPY TO / COPY FROM