Python Postgresql.create_replication_slot Exemples

Exemple #1

Fichier : governor.py Projet : miketonks/governor

    postgresql.copy_pg_hba()
    postgresql.follow_no_leader()
    logging.info("Governor Starting up: Starting Postgres")
    postgresql.start(master=False)

showtime()
logging.info("Governor Running: Starting Running Loop")
while True:
    try:
        logging.info("Governor Running: %s" % ha.run_cycle())

        # create replication slots
        if postgresql.is_leader():
            logging.debug("Governor Running: I am the Leader")

            for member in etcd.members():
                member = member['hostname']
                if member != postgresql.name:
                    postgresql.create_replication_slot(member)

        etcd.touch_member(postgresql.name,
                          postgresql.advertised_connection_string)

    except SystemExit as e:
        logging.info("Governor Shutting Down: Exiting Running Loop")
    except Exception as e:
        logging.exception("Unexpected error: %s" % e)

    finally:
        time.sleep(config["loop_wait"])

Exemple #2

Fichier : governor.py Projet : blelump/governor

    postgresql.copy_pg_hba()
    postgresql.follow_no_leader()
    logging.info("Governor Starting up: Starting Postgres")
    postgresql.start(master=False)

showtime()
logging.info("Governor Running: Starting Running Loop")
while True:
    try:
        logging.info("Governor Running: %s" % ha.run_cycle())

        # create replication slots
        if postgresql.is_leader():
            logging.debug("Governor Running: I am the Leader")

            for member in etcd.members():
                member = member['hostname']
                if member != postgresql.name:
                    postgresql.create_replication_slot(member)

        etcd.touch_member(postgresql.name,
                          postgresql.advertised_connection_string)

    except SystemExit as e:
        logging.info("Governor Shutting Down: Exiting Running Loop")
    except Exception as e:
        logging.exception("Unexpected error: %s" % e)

    finally:
        time.sleep(config["loop_wait"])