I have 2 postgres nodes setup in a replication and hot standby configuration. I am using pgpool for automatic failover and load balancing the read queries.
I have setup scripts for automatic failover when the master node fails. I want to understand how it would work in the following 2 scenarios.
touch /tmp/pgsql.failover - which is the trigger file.
I dont use pg_standby in my recovery process
Scenario 1
----------------
Suppose the secondary server is lagging behind the primary at the time of primary failure, will the secondary completely catch up to the primary state, before stopping replication. Or what in the process ensures this happens ?
Scenario 2
------------------
Both primary and secondary are running.
Secondary goes down at time t1.
Now primary goes down at t2. At this point, the trigger file is created.
Secondary node restarts at time t3.
What happens to all the transactions that occurred between t1 and t2.
Regards,
Anupama.