def main():
from pg_upgrade import PostgresqlUpgrade
from patroni.config import Config
from patroni.utils import polling_loop
from spilo_commons import get_binary_version
config = Config(sys.argv[1])
upgrade = PostgresqlUpgrade(config)
bin_version = get_binary_version(upgrade.pgcommand(''))
cluster_version = upgrade.get_cluster_version()
if cluster_version == bin_version:
return 0
logger.info('Cluster version: %s, bin version: %s', cluster_version,
bin_version)
assert float(cluster_version) < float(bin_version)
logger.info('Trying to start the cluster with old postgres')
if not upgrade.start_old_cluster(config['bootstrap'], cluster_version):
raise Exception('Failed to start the cluster with old postgres')
for _ in polling_loop(upgrade.config.get('pg_ctl_timeout'), 10):
upgrade.reset_cluster_info_state()
if upgrade.is_leader():
break
logger.info('waiting for end of recovery of the old cluster')
if not upgrade.bootstrap.call_post_bootstrap(config['bootstrap']):
upgrade.stop(block_callbacks=True, checkpoint=False)
raise Exception('Failed to run bootstrap.post_init')
if not upgrade.prepare_new_pgdata(bin_version):
raise Exception('initdb failed')
try:
upgrade.drop_possibly_incompatible_objects()
except Exception:
upgrade.stop(block_callbacks=True, checkpoint=False)
raise
logger.info('Doing a clean shutdown of the cluster before pg_upgrade')
if not upgrade.stop(block_callbacks=True, checkpoint=False):
raise Exception('Failed to stop the cluster with old postgres')
if not upgrade.do_upgrade():
raise Exception('Failed to upgrade cluster from {0} to {1}'.format(
cluster_version, bin_version))
logger.info('Starting the cluster with new postgres after upgrade')
if not upgrade.start():
raise Exception('Failed to start the cluster with new postgres')
try:
upgrade.update_extensions()
except Exception as e:
logger.error('Failed to update extensions: %r', e)
upgrade.analyze()
def main():
from pg_upgrade import PostgresqlUpgrade
from patroni.config import Config
from spilo_commons import get_binary_version
config = Config(sys.argv[1])
upgrade = PostgresqlUpgrade(config)
bin_version = get_binary_version(upgrade.pgcommand(''))
cluster_version = upgrade.get_cluster_version()
logger.info('Cluster version: %s, bin version: %s', cluster_version,
bin_version)
assert float(cluster_version) <= float(bin_version)
perform_pitr(upgrade, cluster_version, bin_version, config['bootstrap'])
if cluster_version == bin_version:
return 0
if not upgrade.bootstrap.call_post_bootstrap(config['bootstrap']):
upgrade.stop(block_callbacks=True, checkpoint=False)
raise Exception('Failed to run bootstrap.post_init')
if not upgrade.prepare_new_pgdata(bin_version):
raise Exception('initdb failed')
try:
upgrade.drop_possibly_incompatible_objects()
except Exception:
upgrade.stop(block_callbacks=True, checkpoint=False)
raise
logger.info('Doing a clean shutdown of the cluster before pg_upgrade')
if not upgrade.stop(block_callbacks=True, checkpoint=False):
raise Exception('Failed to stop the cluster with old postgres')
if not upgrade.do_upgrade():
raise Exception('Failed to upgrade cluster from {0} to {1}'.format(
cluster_version, bin_version))
logger.info('Starting the cluster with new postgres after upgrade')
if not upgrade.start():
raise Exception('Failed to start the cluster with new postgres')
try:
upgrade.update_extensions()
except Exception as e:
logger.error('Failed to update extensions: %r', e)
upgrade.analyze()