Thread: [pgsql-pkg-debian] PostgreSQL Automatic Failover packages

Hi,

The PostgreSQL Automatic Failover (PAF) project is releasing a beta version
today at https://github.com/dalibo/PAF/releases/tag/v2.2_beta1

This project has been providing Debian package files since a few versions
through github.

You will find the 2.1 and 2.2~beta1 packages at
https://github.com/dalibo/PAF/releases/download/v2.1.0/resource-agents-paf_2.1.0-1_all.deb
https://github.com/dalibo/PAF/releases/download/v2.2_beta1/resource-agents-paf_2.2.beta1-1_all.deb

These packages are only compatible with Pacemaker version provided in Debian 8
and up or Ubuntu Xenial and up. I suppose I should fix this in the control file
of the debian packages before 2.2~rc1.

Is it possible to include them in related repositories?

Version 1.1 of PAF is compatible with Pacemaker in previous OSes, and its
package is available at

https://github.com/dalibo/PAF/releases/download/v1.1.0/resource-agents-paf_1.1.0-1_all.deb

Is it possible to include it in related repo as well ?


Thank you in advance for your help !

Regards,
--
Jehan-Guillaume (ioguix) de Rorthais
Dalibo

On Mon, 26 Jun 2017 15:34:47 +0200
Jehan-Guillaume de Rorthais <jgdr@dalibo.com> wrote:

> You will find the 2.1 and 2.2~beta1 packages at
> https://github.com/dalibo/PAF/releases/download/v2.1.0/resource-agents-paf_2.1.0-1_all.deb
> https://github.com/dalibo/PAF/releases/download/v2.2_beta1/resource-agents-paf_2.2.beta1-1_all.deb
>
> These packages are only compatible with Pacemaker version provided in Debian 8
> and up or Ubuntu Xenial and up. I suppose I should fix this in the control
> file of the debian packages before 2.2~rc1.

...and this has been fixed. The updated link:

https://github.com/dalibo/PAF/releases/download/v2.2_beta1/resource-agents-paf_2.2.beta1-2_all.deb

Regards,
--
Jehan-Guillaume de Rorthais
Dalibo

Hi,

Am 26.06.2017 um 15:34 schrieb Jehan-Guillaume de Rorthais:
> Hi,
>
> The PostgreSQL Automatic Failover (PAF) project is releasing a beta version
> today at https://github.com/dalibo/PAF/releases/tag/v2.2_beta1
>
> This project has been providing Debian package files since a few versions
> through github.
>
> You will find the 2.1 and 2.2~beta1 packages at
> https://github.com/dalibo/PAF/releases/download/v2.1.0/resource-agents-paf_2.1.0-1_all.deb
> https://github.com/dalibo/PAF/releases/download/v2.2_beta1/resource-agents-paf_2.2.beta1-1_all.deb
>
> These packages are only compatible with Pacemaker version provided in Debian 8
> and up or Ubuntu Xenial and up. I suppose I should fix this in the control file
> of the debian packages before 2.2~rc1.
>
> Is it possible to include them in related repositories?

I've created a pgdgbuild [1] (apt.postgresql.org) build job for PAF [2].
Currently the build fails. It's related to the pull request I opened
earlier [3].

> Version 1.1 of PAF is compatible with Pacemaker in previous OSes, and its
> package is available at
>
> https://github.com/dalibo/PAF/releases/download/v1.1.0/resource-agents-paf_1.1.0-1_all.deb
>
> Is it possible to include it in related repo as well ?

I don't think it makes much sense to add the resource agent for wheezy
and so on. The RA wasn't available in the past and I don't think anyone
chooses wheezy or trusty for a new PostgreSQL HA Cluster.
I will update the build job to exclude distributions that only ships
pacemaker versions older then 1.1.13.

[1] https://pgdgbuild.dus.dg-i.net/
[2] https://pgdgbuild.dus.dg-i.net/job/paf-source/
[3] https://github.com/dalibo/PAF/pull/105


> Thank you in advance for your help !

Thanks for your work on the RA. It's great!

Cheers,
 - Adrian

Re: Adrian Vondendriesch 2017-06-26 <925349a8-74df-7d16-5d02-72a8fbbe3d77@credativ.de>
> [1] https://pgdgbuild.dus.dg-i.net/
> [2] https://pgdgbuild.dus.dg-i.net/job/paf-source/

Fwiw, jenkins requires a client certificate if you want to see the
jobs and build logs, see "Jenkins Login" on
https://wiki.postgresql.org/wiki/Apt/Jenkins

Christoph

Hi,

On Mon, 26 Jun 2017 20:35:46 +0200
Adrian Vondendriesch <adrian.vondendriesch@credativ.de> wrote:
> Am 26.06.2017 um 15:34 schrieb Jehan-Guillaume de Rorthais:
> > The PostgreSQL Automatic Failover (PAF) project is releasing a beta version
> > today at https://github.com/dalibo/PAF/releases/tag/v2.2_beta1
> >
> > This project has been providing Debian package files since a few versions
> > through github.
> >
> > You will find the 2.1 and 2.2~beta1 packages at
> > https://github.com/dalibo/PAF/releases/download/v2.1.0/resource-agents-paf_2.1.0-1_all.deb
> > https://github.com/dalibo/PAF/releases/download/v2.2_beta1/resource-agents-paf_2.2.beta1-1_all.deb
> >
> > These packages are only compatible with Pacemaker version provided in
> > Debian 8 and up or Ubuntu Xenial and up. I suppose I should fix this in the
> > control file of the debian packages before 2.2~rc1.
> >
> > Is it possible to include them in related repositories?
>
> I've created a pgdgbuild [1] (apt.postgresql.org) build job for PAF [2].
> Currently the build fails. It's related to the pull request I opened
> earlier [3].

Thank for your action and help. I merged your PR after our quick discussion
yesterday.

> > Version 1.1 of PAF is compatible with Pacemaker in previous OSes, and its
> > package is available at
> >
> > https://github.com/dalibo/PAF/releases/download/v1.1.0/resource-agents-paf_1.1.0-1_all.deb
> >
> > Is it possible to include it in related repo as well ?
>
> I don't think it makes much sense to add the resource agent for wheezy
> and so on. The RA wasn't available in the past and I don't think anyone
> chooses wheezy or trusty for a new PostgreSQL HA Cluster.

Not sure, I just closed an issue on github where someone were trying to use
PAF 2.1 on ubuntu 14... And I know a bunch of companies that are still
migrating from Debian 7 to Debian 8 or deploying EL6 :/

But anyway, packages for 1.1 are available on github, so I'm perfectly fine if
you prefer to keep it simple on PGDG repo. I'm in favor to convince people
upgrading their OS.

> I will update the build job to exclude distributions that only ships
> pacemaker versions older then 1.1.13.
>
> [1] https://pgdgbuild.dus.dg-i.net/
> [2] https://pgdgbuild.dus.dg-i.net/job/paf-source/

I can not access them.

> Thanks for your work on the RA. It's great!

Thank you :)

--
Jehan-Guillaume de Rorthais
Dalibo

On Tue, 27 Jun 2017 11:51:30 +0200
Jehan-Guillaume de Rorthais <jgdr@dalibo.com> wrote:
|...]
> > > Version 1.1 of PAF is compatible with Pacemaker in previous OSes, and its
> > > package is available at
> > >
> > > https://github.com/dalibo/PAF/releases/download/v1.1.0/resource-agents-paf_1.1.0-1_all.deb
> > >
> > > Is it possible to include it in related repo as well ?
> >
> > I don't think it makes much sense to add the resource agent for wheezy
> > and so on. The RA wasn't available in the past and I don't think anyone
> > chooses wheezy or trusty for a new PostgreSQL HA Cluster.
>
> Not sure, I just closed an issue on github where someone were trying to use
> PAF 2.1 on ubuntu 14... And I know a bunch of companies that are still
> migrating from Debian 7 to Debian 8 or deploying EL6 :/
>
> But anyway, packages for 1.1 are available on github, so I'm perfectly fine if
> you prefer to keep it simple on PGDG repo. I'm in favor to convince people
> upgrading their OS.
>
> > I will update the build job to exclude distributions that only ships
> > pacemaker versions older then 1.1.13.
> >
> > [1] https://pgdgbuild.dus.dg-i.net/
> > [2] https://pgdgbuild.dus.dg-i.net/job/paf-source/
>
> I can not access them.

I can access them now.

By the way, what is the status of this package? May I do anything to help?

Am Dienstag, den 04.07.2017, 09:50 +0200 schrieb Jehan-Guillaume de
Rorthais:
> By the way, what is the status of this package? May I do anything to
> help?

Sorry for the delay. Packages are now available within the <dist>-pgpg-
testing repositories on apt.postgresql.org [1]. Please have a look at
those packages.

I don't know if we want to promote the packages to the non -testing
repositories. This will potentially upgrade a lot of postgres /
pacemaker / paf installations out there to a beta version.

[1] https://wiki.postgresql.org/wiki/Apt/FAQ#Development_snapshots

Cheers,
 - Adrian

On Tue, 04 Jul 2017 21:22:27 +0200
Adrian Vondendriesch <adrian.vondendriesch@credativ.de> wrote:

> Am Dienstag, den 04.07.2017, 09:50 +0200 schrieb Jehan-Guillaume de
> Rorthais:
> > By the way, what is the status of this package? May I do anything to
> > help?
>
> Sorry for the delay.

No worries! Thank you very much for your work!

> Packages are now available within the <dist>-pgpg-
> testing repositories on apt.postgresql.org [1]. Please have a look at
> those packages.

I'll do as soon as possible this week.

> I don't know if we want to promote the packages to the non -testing
> repositories. This will potentially upgrade a lot of postgres /
> pacemaker / paf installations out there to a beta version.

Agree. We can wait for the official release of 2.2.

Regards,
--
Jehan-Guillaume de Rorthais
Dalibo