Re: Postgresql switch over process

From: Bill MacArthur <webmaster(at)dhs-club(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql switch over process
Date: 2012-10-17 19:48:37
Message-ID: 507F0B95.5010002@dhs-club.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 10/17/2012 3:20 PM, Shams Khan wrote:
> Can somebody tell me how we can automate the switch over process, I
> know there is once file recovery.conf which contains the parameter
> trigger_file. But my question is what code that file contains....Hope
> my thinking is correct.
>
>
The trigger file itself contains nothing. You can simply create an empty file when it's needed. You can use 'touch' in linux. The server will see that it has appeared and do what it needs to do from there.

Bill MacArthur

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Parkirat Bagga 2012-10-17 20:34:05 Streaming Replication (Master Delta Sync)
Previous Message Parkirat Bagga 2012-10-17 19:33:35 WAL corruption while replication