[Postgres-xl-general] How to test failover and recovery of GTM/Datanode?

FattahRozzaq ssoorruu at gmail.com
Tue Sep 8 05:54:43 PDT 2015


Hi Mason,

Thank you so much for your direct answer.

Cheers,
FattahRozzaq

On 08/09/2015, Mason Sharp <mason.sharp at gmail.com> wrote:
> On Thu, Sep 3, 2015 at 4:39 AM, FattahRozzaq <ssoorruu at gmail.com> wrote:
>
>> Dear fellas Postgres-XL enthusiasts,
>>
>> My questions as below
>> 1. How to test failover the GTM from master node to the slave node?
>>
>
> Setup a slave GTM and kill the master.  Promote the slave. Reassign the IP
> address.
>
>
>> 2. How recovery back the GTM that was in slave to be the GTM in the
>> master
>> node?
>>
>
> You can promote a slave GTM.
>
> 3. How to test failover the Datanode from master node to the slave node?
>>
>
> This is just like PostgreSQL. Shoot the master in the head and promote the
> slave.
>
>
>> 4. How recovery back the Datanode that was in slave to be the Datanode
>> in the master node?
>>
>
> Is this the same as 3?
>
>
>> 5. What is the command I should type in the PGXC_CTL console?
>>
>
> To failover? Use failover.
>
>
>
> Note that there is no easy "failback" command.
>
>
>
>> 6. Where I can find the document/cheatsheet about the commands relate to
>> this?
>>
>>
> http://files.postgres-xl.org/documentation/pgxc-ctl.html
>
> Regards,
>
> Mason
>




More information about the postgres-xl-general mailing list