Connections to the production instances should be made via virtual IP.

See below:



   Primary            Standby

db1.domain.tld    db2.domain.tld





            \    /

        db.domain.tld (interface db.domain.tld brought up on primary)

              |

              |

              |

              |

              |

connections made via db.domain.tld