pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFailover Solution for Postgres
4+ messages / 3 participants
[nested] [flat]
* Failover Solution for Postgres
@ 2004-10-04 18:49 John Allgood <john@turbocorp.com>
2004-10-04 22:32 ` Re: Failover Solution for Postgres Gaetano Mendola <mendola@bigfoot.com>
2004-10-05 06:06 ` Re: Failover Solution for Postgres Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 4+ messages in thread
From: John Allgood @ 2004-10-04 18:49 UTC (permalink / raw)
To: pgsql-admin
Hello All
I am looking for information on postgres failover solutions. I have
researched Dbmirror, DBcluster, and GFS along with others. This server
is running rh-postgresql-7.3.6 and Redhat ES 3.0 and I am trying to get
an idea of what is stable and reliable. What are people on this list
running for you failover solutions and what recommendations can you give
me. The server will be running about 9 databases anywhere form 350MB to
3GB. Looking to go live on the system 1st quarter 2005. I would love to
wait until postgres 8.0 is released and get the point-in-time recovery
along with the other features that will be in that version. But that
will have to wait.
Thanks
--
John Allgood - ESC
Systems Administrator
678.989.3051
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Failover Solution for Postgres
2004-10-04 18:49 Failover Solution for Postgres John Allgood <john@turbocorp.com>
@ 2004-10-04 22:32 ` Gaetano Mendola <mendola@bigfoot.com>
2004-10-05 14:48 ` Re: Failover Solution for Postgres John Allgood <john@turbocorp.com>
1 sibling, 1 reply; 4+ messages in thread
From: Gaetano Mendola @ 2004-10-04 22:32 UTC (permalink / raw)
To: pgsql-admin
John Allgood wrote:
> Hello All
>
> I am looking for information on postgres failover solutions. I have
> researched Dbmirror, DBcluster, and GFS along with others. This server
> is running rh-postgresql-7.3.6 and Redhat ES 3.0 and I am trying to get
> an idea of what is stable and reliable. What are people on this list
> running for you failover solutions and what recommendations can you give
> me. The server will be running about 9 databases anywhere form 350MB to
> 3GB. Looking to go live on the system 1st quarter 2005. I would love to
> wait until postgres 8.0 is released and get the point-in-time recovery
> along with the other features that will be in that version. But that
> will have to wait.
We use the cluster RH solution.
Regards
Gaetano Mendola
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Failover Solution for Postgres
2004-10-04 18:49 Failover Solution for Postgres John Allgood <john@turbocorp.com>
2004-10-04 22:32 ` Re: Failover Solution for Postgres Gaetano Mendola <mendola@bigfoot.com>
@ 2004-10-05 14:48 ` John Allgood <john@turbocorp.com>
0 siblings, 0 replies; 4+ messages in thread
From: John Allgood @ 2004-10-05 14:48 UTC (permalink / raw)
To: Gaetano Mendola <mendola@bigfoot.com>; pgsql-admin
Hello
I am thinking about using the Redhat Cluster software. Could you tell
me a about the hardware requirements and what type of configuration you
are running.
Thanks
Gaetano Mendola wrote:
> John Allgood wrote:
>
>> Hello All
>>
>> I am looking for information on postgres failover solutions. I
>> have researched Dbmirror, DBcluster, and GFS along with others. This
>> server is running rh-postgresql-7.3.6 and Redhat ES 3.0 and I am
>> trying to get an idea of what is stable and reliable. What are people
>> on this list running for you failover solutions and what
>> recommendations can you give me. The server will be running about 9
>> databases anywhere form 350MB to 3GB. Looking to go live on the
>> system 1st quarter 2005. I would love to wait until postgres 8.0 is
>> released and get the point-in-time recovery along with the other
>> features that will be in that version. But that will have to wait.
>
>
> We use the cluster RH solution.
>
> Regards
> Gaetano Mendola
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
--
John Allgood - ESC
Systems Administrator
678.989.3051
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Failover Solution for Postgres
2004-10-04 18:49 Failover Solution for Postgres John Allgood <john@turbocorp.com>
@ 2004-10-05 06:06 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2004-10-05 06:06 UTC (permalink / raw)
To: John Allgood <john@turbocorp.com>; pgsql-admin
John Allgood wrote:
> I am looking for information on postgres failover solutions.
Set up two machines with shared storage and have the machine monitor
each other with heartbeat. If you don't want to invest in shared
storage hardware, set up DRBD to replicate the file system between the
two. (I think the Red Hat cluster mentioned elsewhere amounts to the
first variant, more or less.)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-10-05 14:48 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-04 18:49 Failover Solution for Postgres John Allgood <john@turbocorp.com>
2004-10-04 22:32 ` Gaetano Mendola <mendola@bigfoot.com>
2004-10-05 14:48 ` John Allgood <john@turbocorp.com>
2004-10-05 06:06 ` Peter Eisentraut <peter_e@gmx.net>
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