pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHigh availability with Postgres
7+ messages / 7 participants
[nested] [flat]
* High availability with Postgres
@ 2010-06-20 16:36 Elior Soliman <elior.soliman@correlix.com>
2010-06-21 19:05 ` Re: High availability with Postgres Alex Hunsaker <badalex@gmail.com>
2010-06-23 04:42 ` Re: High availability with Postgres Greg Spiegelberg <gspiegelberg@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Elior Soliman @ 2010-06-20 16:36 UTC (permalink / raw)
To: pgsql-admin
Hello,
My company looking for some solution for High availability with Postgres.
Our optional solution is as follows :
Two DB servers will be using a common external storage (with raid). Both
servers are going to use the same DB files on the storage (as
active/passive)
Now I'm trying to understand how Postgres can work with this configuration.
I.e :
DB_server1 crashed, so we want to start DB_server2 using same files.
Is it possible ?
Regards,
Elior
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: High availability with Postgres
2010-06-20 16:36 High availability with Postgres Elior Soliman <elior.soliman@correlix.com>
@ 2010-06-21 19:05 ` Alex Hunsaker <badalex@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Alex Hunsaker @ 2010-06-21 19:05 UTC (permalink / raw)
To: Elior Soliman <elior.soliman@correlix.com>; +Cc: pgsql-admin
On Sun, Jun 20, 2010 at 10:36, Elior Soliman <elior.soliman@correlix.com> wrote:
> Hello,
>
> My company looking for some solution for High availability with Postgres.
>
> Our optional solution is as follows :
> Two DB servers will be using a common external storage (with raid). Both
> servers are going to use the same DB files on the storage (as
> active/passive)
>
> Now I'm trying to understand how Postgres can work with this configuration.
> I.e :
>
> DB_server1 crashed, so we want to start DB_server2 using same files.
> Is it possible ?
Yeah, I have used linux + heartbeat + stonith (shoot the other node in
the head) successfully in the past. Basically if you do this want
want to be really really really careful that both machines are not
running postgres at the same time.
[ Note, I dont run this any more instead I use a simpler pitr setup.
You can of course still use shared external storage, you just need 2
copies of the database :-( ]
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: High availability with Postgres
2010-06-20 16:36 High availability with Postgres Elior Soliman <elior.soliman@correlix.com>
@ 2010-06-23 04:42 ` Greg Spiegelberg <gspiegelberg@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Greg Spiegelberg @ 2010-06-23 04:42 UTC (permalink / raw)
To: Elior Soliman <elior.soliman@correlix.com>; +Cc: pgsql-admin
On Sun, Jun 20, 2010 at 10:36 AM, Elior Soliman
<elior.soliman@correlix.com> wrote:
> Hello,
>
> My company looking for some solution for High availability with Postgres.
>
> Our optional solution is as follows :
> Two DB servers will be using a common external storage (with raid). Both
> servers are going to use the same DB files on the storage (as
> active/passive)
>
> Now I'm trying to understand how Postgres can work with this configuration.
> I.e :
>
> DB_server1 crashed, so we want to start DB_server2 using same files.
> Is it possible ?
I've used the Symantec Storage Foundation & Cluster Server products in
the past. Worked very well in shared SAN storage, 4-way cluster with
3 service groups each running PostgreSQL. Easy to configure and
manage too. Their volume manager and file system are very mature and
always recovered well.
HTH.
Greg
^ permalink raw reply [nested|flat] 7+ messages in thread
* High availability with Postgres
@ 2015-02-18 06:10 shyamkant.dhamke@wipro.com
2015-02-18 07:12 ` Re: High availability with Postgres Sameer Thakur <samthakur74@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: shyamkant.dhamke@wipro.com @ 2015-02-18 06:10 UTC (permalink / raw)
To: pgsql-admin
Hi All,
I am looking for some solution for High availability with Postgres 9.3 on Red Hat Linux Enterprise edition V6.
Will "Symantec(tm) Storage Foundation Cluster File System HA (SFCFSHA)" product can be fitted for above requirement?
As our customer has this product and asking our recommendation on this. Please help me. If anyone has good links to read more please share.
Regards
Shyamkant
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: High availability with Postgres
2015-02-18 06:10 High availability with Postgres shyamkant.dhamke@wipro.com
@ 2015-02-18 07:12 ` Sameer Thakur <samthakur74@gmail.com>
2015-02-18 07:24 ` Re: High availability with Postgres Iñigo Salvat <inigo@isalvat.es>
0 siblings, 1 reply; 7+ messages in thread
From: Sameer Thakur @ 2015-02-18 07:12 UTC (permalink / raw)
To: pgsql-admin
Hello,
>I am looking for some solution for High availability with Postgres 9.3 on
Red Hat Linux Enterprise edition >V6.
Please have a look @ http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster
This solution uses Linux HA components to provide HA to PostgreSQL
configured for streaming replication
regards
Sameer
--
View this message in context: http://postgresql.nabble.com/High-availability-with-Postgres-tp5838373p5838378.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: High availability with Postgres
2015-02-18 06:10 High availability with Postgres shyamkant.dhamke@wipro.com
2015-02-18 07:12 ` Re: High availability with Postgres Sameer Thakur <samthakur74@gmail.com>
@ 2015-02-18 07:24 ` Iñigo Salvat <inigo@isalvat.es>
2015-02-18 11:16 ` Re: High availability with Postgres Luis Antonio Dias de Sá Junior <luisjunior.sa@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Iñigo Salvat @ 2015-02-18 07:24 UTC (permalink / raw)
To: pgsql-admin
Hi,
We are using Pacemaker + Corosync + pcs + the latest pgsql Resource Agent.
It is working very nice and the resource agent is able to manage pretty
well the streaming protocol so you don't need to share any disk.
Regards,
Iñigo
El 18/02/15 08:12, Sameer Thakur escribió:
> Hello,
>> I am looking for some solution for High availability with Postgres 9.3 on
> Red Hat Linux Enterprise edition >V6.
> Please have a look @ http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster
>
> This solution uses Linux HA components to provide HA to PostgreSQL
> configured for streaming replication
>
> regards
> Sameer
>
>
>
> --
> View this message in context: http://postgresql.nabble.com/High-availability-with-Postgres-tp5838373p5838378.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: High availability with Postgres
2015-02-18 06:10 High availability with Postgres shyamkant.dhamke@wipro.com
2015-02-18 07:12 ` Re: High availability with Postgres Sameer Thakur <samthakur74@gmail.com>
2015-02-18 07:24 ` Re: High availability with Postgres Iñigo Salvat <inigo@isalvat.es>
@ 2015-02-18 11:16 ` Luis Antonio Dias de Sá Junior <luisjunior.sa@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Luis Antonio Dias de Sá Junior @ 2015-02-18 11:16 UTC (permalink / raw)
To: Iñigo Salvat <inigo@isalvat.es>; +Cc: pgsql-admin
We use Pacemaker + heatbeat to linux process like pgpool and Virtual IP.
For postgres pgpool have failover process, just set then. See pgpool
oficial documentation.
2015-02-18 5:24 GMT-02:00 Iñigo Salvat <inigo@isalvat.es>:
> Hi,
>
> We are using Pacemaker + Corosync + pcs + the latest pgsql Resource Agent.
>
> It is working very nice and the resource agent is able to manage pretty
> well the streaming protocol so you don't need to share any disk.
>
> Regards,
>
> Iñigo
>
>
> El 18/02/15 08:12, Sameer Thakur escribió:
>
> Hello,
>>
>>> I am looking for some solution for High availability with Postgres 9.3 on
>>>
>> Red Hat Linux Enterprise edition >V6.
>> Please have a look @ http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster
>>
>> This solution uses Linux HA components to provide HA to PostgreSQL
>> configured for streaming replication
>>
>> regards
>> Sameer
>>
>>
>>
>> --
>> View this message in context: http://postgresql.nabble.com/
>> High-availability-with-Postgres-tp5838373p5838378.html
>> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>>
>>
>>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Luis Antonio Dias de Sá Junior
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2015-02-18 11:16 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-20 16:36 High availability with Postgres Elior Soliman <elior.soliman@correlix.com>
2010-06-21 19:05 ` Alex Hunsaker <badalex@gmail.com>
2010-06-23 04:42 ` Greg Spiegelberg <gspiegelberg@gmail.com>
2015-02-18 06:10 High availability with Postgres shyamkant.dhamke@wipro.com
2015-02-18 07:12 ` Sameer Thakur <samthakur74@gmail.com>
2015-02-18 07:24 ` Iñigo Salvat <inigo@isalvat.es>
2015-02-18 11:16 ` Luis Antonio Dias de Sá Junior <luisjunior.sa@gmail.com>
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