From: | "E-Blokos" <infos(at)e-blokos(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: about synchronous_standby_names or sync replic |
Date: | 2011-09-23 03:48:53 |
Message-ID: | 9504BF99C69F42EF914CA0ED1574D3D5@e1705 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for your answer.
That's great,
so for later other nodes replication it
needs an asynchronous replic like pg_stat or even a good old rsync ?
Franck
----- Original Message -----
From: "Jaime Casanova" <jaime(at)2ndquadrant(dot)com>
To: "e-blokos" <infos(at)e-blokos(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, September 22, 2011 11:38 PM
Subject: Re: [GENERAL] about synchronous_standby_names or sync replic
On Thu, Sep 22, 2011 at 2:34 PM, e-blokos <infos(at)e-blokos(dot)com> wrote:
> Hi Folks,
>
> I wonder if it's possible to have a sync replication only from the the
> node
> where the client
> who update the DB and other node replicated asynchronously ?
>
> example :
> nodeCentral node1 node2 node3
>
> user1 from node3 update db to nodeCentral (master) so nodeCentral
> replicates synchronously node3 and later other nodes...
>
yep, put the names of all the nodes in synchronous_standby_names and
set synchronous_commit to local... then when someone sends a write
command to the server "set synchronous_commit to on" (of course, this
SET is a command you send to the server just like any other SQL
command)
don't forget to reset synchronous_commit or use set local, otherwise
you will let this node as the sync rep until disconnect
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
From | Date | Subject | |
---|---|---|---|
Next Message | pasman pasmański | 2011-09-23 04:34:52 | Re: how just install psql on windows? |
Previous Message | Jaime Casanova | 2011-09-23 03:38:14 | Re: about synchronous_standby_names or sync replic |