Re: postgresql cluster on SAN

Поиск
Список
Период
Сортировка
От Lazaro Ruben Garcia Martinez
Тема Re: postgresql cluster on SAN
Дата
Msg-id 591826869.2034341284001338735.JavaMail.root@ucimail3.uci.cu
обсуждение исходный текст
Ответ на Re: postgresql cluster on SAN  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: postgresql cluster on SAN  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: postgresql cluster on SAN  (John R Pierce <pierce@hogranch.com>)
Re: postgresql cluster on SAN  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-general
Thank you very much for your answer, In the cluster that i said before I need only failover.
In the documentation of postgresql I read about the Shared Disk Failover, this tecnique avoids synchronization overhead by having only one copy of the database. It uses a single disk array that is shared by multiple servers. If the main database server fails, the standby server is able to mount and start the database as though it was recovering from a database crash. This allows rapid failover with no data loss. One disadvantage is that the standby server should never access the shared storage while the primary server is running.

For these resons is posible to use a SAN?

Regards.

----- "Craig Ringer" <craig@postnewspapers.com.au> escribió:
> On 9/09/2010 10:27 AM, Lazaro Ruben Garcia Martinez wrote:
> > Hello everyone:
> >
> > I am a student of the University of Informatics Science in Cuba. I
> > want create a postgresql cluster and I have two servers but I have a
> > doubt. Is possible to create a cluster of postgresql server by sharing
> > the database file on a SAN?
>
> No, PostgreSQL does not support shared-storage clsutering. Use one of
> the replication-based clustering options like Bucardo or Slony.
>
> Added to FAQ after "What replication solutions are available?":
>
> http://wiki.postgresql.org/wiki/FAQ#Is_possible_to_create_a_shared-storage_postgresql_server_cluster.3F
>
> --
> Craig Ringer
>
> Tech-related writing at http://soapyfrogs.blogspot.com/
>

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: postgresql cluster on SAN
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: postgresql cluster on SAN