pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHelp on creating a High Availability PostgreSQL solution?
2+ messages / 2 participants
[nested] [flat]
* Help on creating a High Availability PostgreSQL solution?
@ 2002-10-24 14:27 Charles H. Woloszynski <chw@clearmetrix.com>
0 siblings, 1 reply; 2+ messages in thread
From: Charles H. Woloszynski @ 2002-10-24 14:27 UTC (permalink / raw)
To: pgsql-sql
We are looking to create a two-machine high-availability configuration
for PostgreSQL. We have been pursuing using something like rserv, but
this appears to be more of a slave sync tool. Actually, this is also
important to us (as we expect we will need to scale to lots of readers
doing queries on the database (we are running datamart of website
performance metrics).
But, rserv (and eRServer, its commercial cousin) dont seem to have a
hot-standby capability at the moment. I have looked through some of the
PostgreSQL archives and I've seen articles about other approaches, but I
mostly see replication engines (which are a good thing, but not what I
am hunting for).
I saw one posting that suggested using a clustered filesystem; is this
an option? Has anyone done postgreSQL on a replicating/clustered file
system with decent performance? Any and all ideas are welcome.
Thanks in advance,
Charlie
--
Charles H. Woloszynski
ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015
tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Help on creating a High Availability PostgreSQL
@ 2002-10-25 01:26 Tatsuo Ishii <t-ishii@sra.co.jp>
parent: Charles H. Woloszynski <chw@clearmetrix.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tatsuo Ishii @ 2002-10-25 01:26 UTC (permalink / raw)
To: chw@clearmetrix.com; +Cc: pgsql-sql
> We are looking to create a two-machine high-availability configuration
> for PostgreSQL. We have been pursuing using something like rserv, but
> this appears to be more of a slave sync tool. Actually, this is also
> important to us (as we expect we will need to scale to lots of readers
> doing queries on the database (we are running datamart of website
> performance metrics).
>
> But, rserv (and eRServer, its commercial cousin) dont seem to have a
> hot-standby capability at the moment. I have looked through some of the
> PostgreSQL archives and I've seen articles about other approaches, but I
> mostly see replication engines (which are a good thing, but not what I
> am hunting for).
>
> I saw one posting that suggested using a clustered filesystem; is this
> an option? Has anyone done postgreSQL on a replicating/clustered file
> system with decent performance? Any and all ideas are welcome.
We are selling Lifekeeper (a hot-standby cluster software) +
PostgreSQL adapter software for Lifekeeper + support combo package
called "PostgreSQL HA package" in Japan. This requires an expensive
shared disk hardware though.
--
Tatsuo Ishii
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-10-25 01:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-24 14:27 Help on creating a High Availability PostgreSQL solution? Charles H. Woloszynski <chw@clearmetrix.com>
2002-10-25 01:26 ` Re: Help on creating a High Availability PostgreSQL Tatsuo Ishii <t-ishii@sra.co.jp>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox