# Live Upgrading PGQ

DevFeed: [Live Upgrading PGQ](<https://devfeed.tech/articles/live-upgrading-pgq-34493.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2013/02/live-upgrading-pgq/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2013-02-08T14:52:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [upgrade](<https://devfeed.tech/topics/upgrade.md>), [version](<https://devfeed.tech/topics/version.md>), [Debian](<https://devfeed.tech/topics/debian.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [FOSDEM](<https://devfeed.tech/topics/fosdem.md>)

Tags: [apt](<https://devfeed.tech/tags/apt.md>), [debian](<https://devfeed.tech/tags/debian.md>), [fosdem](<https://devfeed.tech/tags/fosdem.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>), [version](<https://devfeed.tech/tags/version.md>)

## AI overview

This article explains a live upgrade from PGQ 2 to PGQ 3 alongside Skytools 3.1.3. It notes that Skytools 3.1.3 entered Debian experimental and was available from apt.postgresql.org, then outlines stopping the ticker, installing updated packages, upgrading the PGQ database components, and restarting the new ticker. The author reports testing the procedure during a replicated pgbench run.

## Source excerpt

Some skytools related new today, it's been a while. For those who where at my FOSDEM's talk about Implementing High Availability you might have heard that I really like working with PGQ. A new version has been released a while ago, and the most recent verion is now 3.1.3, as announced in the Skytools 3.1.3 email. *Upgrade time!* Skytools 3.1.3 enters debian First news is that Skytools 3.1.3 has been entering debian today (I hope that by the time you reach that URL, it's been updated to show information according to the news here, but I might be early). As there's current a debian freeze to release wheezy (and you can help squash some bugs), this version is only getting uploaded to experimental for now. Thanks to the tireless work of Christoph Berg though, this version is already available from apt.postgresql.org.