Обсуждение: Clustering with PostgreSQL?

Поиск
Список
Период
Сортировка

Clustering with PostgreSQL?

От
"Bob McCormick"
Дата:
All,

I'm wondering if PostgreSQL is capable of being setup in a clustering
configuration like one can setup for MSSQL server?  We are seriously
considering a move to PostgreSQL, but this is probably the only item I
haven't seen available.  We are setting up an ASP-based website and need to
have a seriously fault tolerant backend in place.

Any thoughts or comments regarding the 'appropriate' or 'recommended' type
of configuration for such a system would be greatly appreciated.

Thanks...Bobbo  ;-)

Bob McCormick
Intuitive Software Technology



Re: Clustering with PostgreSQL?

От
Marc Wrubleski
Дата:
There is no inherent clustering or replication built into postgres yet. Version
7.2 promises replication on various levels.

For fault tolerance, I am sucessfully using drbd and heartbeat to failover
machines.

see http://www.complang.tuwien.ac.at/reisner/drbd/

Marc Wrubleski

Bob McCormick wrote:

> All,
>
> I'm wondering if PostgreSQL is capable of being setup in a clustering
> configuration like one can setup for MSSQL server?  We are seriously
> considering a move to PostgreSQL, but this is probably the only item I
> haven't seen available.  We are setting up an ASP-based website and need to
> have a seriously fault tolerant backend in place.
>
> Any thoughts or comments regarding the 'appropriate' or 'recommended' type
> of configuration for such a system would be greatly appreciated.
>
> Thanks...Bobbo  ;-)
>
> Bob McCormick
> Intuitive Software Technology
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl


RE: Clustering with PostgreSQL?

От
"Dan Harrington"
Дата:
And is there a semi-scheduled release for 7.2?

:-)
Clustering would be awesome, if not imperative.

Dan


> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Marc Wrubleski
> Sent: Tuesday, April 17, 2001 1:20 PM
> To: Bob McCormick
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Clustering with PostgreSQL?
>
>
> There is no inherent clustering or replication built into postgres
> yet. Version
> 7.2 promises replication on various levels.
>
> For fault tolerance, I am sucessfully using drbd and heartbeat to failover
> machines.
>
> see http://www.complang.tuwien.ac.at/reisner/drbd/
>
> Marc Wrubleski
>
> Bob McCormick wrote:
>
> > All,
> >
> > I'm wondering if PostgreSQL is capable of being setup in a clustering
> > configuration like one can setup for MSSQL server?  We are seriously
> > considering a move to PostgreSQL, but this is probably the only item I
> > haven't seen available.  We are setting up an ASP-based website and need to
> > have a seriously fault tolerant backend in place.
> >
> > Any thoughts or comments regarding the 'appropriate' or 'recommended' type
> > of configuration for such a system would be greatly appreciated.
> >
> > Thanks...Bobbo  ;-)
> >
> > Bob McCormick
> > Intuitive Software Technology
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://www.postgresql.org/search.mpl
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly