pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Failover Solution for Postgres
4+ messages / 3 participants
[nested] [flat]

* Failover Solution for Postgres
@ 2004-10-04 18:49  John Allgood <john@turbocorp.com>
  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 22:32  Gaetano Mendola <mendola@bigfoot.com>
  parent: 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-05 06:06  Peter Eisentraut <peter_e@gmx.net>
  parent: John Allgood <john@turbocorp.com>
  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

* Re: Failover Solution for Postgres
@ 2004-10-05 14:48  John Allgood <john@turbocorp.com>
  parent: Gaetano Mendola <mendola@bigfoot.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


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