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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin