Re: Postgresql switch over process - Mailing list pgsql-admin

From Bill MacArthur
Subject Re: Postgresql switch over process
Date
Msg-id 507F0B95.5010002@dhs-club.com
Whole thread Raw
In response to Postgresql switch over process  (Shams Khan <shams.khan22@gmail.com>)
List 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


pgsql-admin by date:

Previous
From: Shams Khan
Date:
Subject: Postgresql switch over process
Next
From: Parkirat Bagga
Date:
Subject: Streaming Replication (Master Delta Sync)