[ADMIN] Postgresql switch over process

2012-10-19 Thread Shams Khan
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 containsHope my thinking is correct. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) T

Re: [ADMIN] Postgresql switch over process

2012-10-18 Thread Albe Laurenz
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 containsHope > my thinking is correct. The contents of the trigger file are irrele

Re: [ADMIN] Postgresql switch over process

2012-10-17 Thread Bill MacArthur
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 containsHope my thinking is correct. The trigger file itself

[ADMIN] Postgresql switch over process

2012-10-17 Thread Shams Khan
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 containsHope my thinking is correct. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) T