From PostgreSQL wiki

< Apt
Jump to: navigation, search

Adding a new PostgreSQL version to the repository

  • Check if apt.postgresql.org/jenkins/generate-pgdg-source needs updating (usually not)
    • If so, update the checkout on pgdgbuild by running the "apt.postgresql.org" job
  • Update apt.postgresql.org/repo/conf/distributions.sh and re-generate the distributions file
    • Update the checkout in atalia:/srv/apt/apt.postgresql.org
  • Create new Jenkins jobs and build them

Changing the default PostgreSQL version

  • Update apt.postgresql.org/jenkins/generate-pgdg-source
    • If so, update the checkout on pgdgbuild by running the "apt.postgresql.org" job
  • If the old version was in sid only, also update apt.postgresql.org/repo/conf/distributions.sh
    • If so, re-generate the distributions file, and update the checkout in atalia:/srv/apt/apt.postgresql.org
  • Rebuild the old default version so its libpq gets added to the extra component (as it was in main before)
  • Rebuild the new default version so its libpq gets added to main (as it was in the extra component before)
  • In postgresql-common, update debian/supported-versions
  • To remove obsolete old lib packages, use for dist in sid squeeze wheezy lucid precise; do sudo -u aptuser reprepro -C 9.3 remove $dist-pgdg-testing libpq5 libecpg6 libecpg-compat3 libecpg-dev libpgtypes3 libpq-dev ; done
  • Removing obsolete PG component: for d in sid jessie wheezy xenial trusty precise; do sudo -u aptuser reprepro -C 9.6 remove $d-pgdg-testing libecpg6 libecpg-compat3 libecpg-dev libpgtypes3 libpq5 libpq-dev postgresql-9.6 postgresql-9.6-dbg postgresql-client-9.6 postgresql-contrib-9.6 postgresql-doc-9.6 postgresql-plperl-9.6 postgresql-plpython3-9.6 postgresql-plpython-9.6 postgresql-pltcl-9.6 postgresql-server-dev-9.6; done

Adding a new distribution

  • Update the apt.postgresql.org repository:
    • repo/conf/distributions.sh and re-generate the distributions file
    • repo/conf/incoming
    • repo/promote
    • jenkins/pgapt-jobs.yaml
    • jenkins/generate-pgdg-source
    • jenkins/sbuild-update.sh (Debian: for backports, if yet applicable; Ubuntu: to tell it it's not Debian (twice))
    • jenkins/schroot-config.sh
  • Update checkout on atalia
    • Seed $newdist-pgdg-testing: reprepro copysrc ... postgresql-common pgdg-keyring pgdg-buildenv from $olddist-pgdg-testing; postgresql-x.y from sid-pgdg-testing (or whatever seems appropriate)
    • possibly: reprepro copymatched $newdist-pgdg $newdist-pgdg-testing '*'
    • or: reprepro export $newdist-pgdg (so apt can run update on it even if it's still empty)
    • Wait until the mirror sync has run (**:17)
  • Update jenkins:
    • Run the "apt.postgresql.org" job
    • Run ./schroot-config.sh | sudo tee /etc/schroot/chroot.d/sbuild.conf
    • Run the "sbuild-update" job
  • Update wiki pages
  • Update pgdg/apt.postgresql.org.sh in postgresql-common
  • Send announcement
Personal tools