Re: PostgreSQL 13.1 Upgrade

2021-02-05 Thread Pierre-Emmanuel Andr??
On Thu, Feb 04, 2021 at 01:32:31PM +, Stuart Henderson wrote: > > > @conflict postgresql-* > > > -@ask-update postgresql-server-<${V_MAJOR} Make sure your existing > > > database is backed up > > > +@ask-update postgresql-server-<${PREV_MAJOR} Old version too old for > > > pg_upgrade, make s

Re: PostgreSQL 13.1 Upgrade

2021-02-04 Thread Stuart Henderson
> > @conflict postgresql-* > > -@ask-update postgresql-server-<${V_MAJOR} Make sure your existing database > > is backed up > > +@ask-update postgresql-server-<${PREV_MAJOR} Old version too old for > > pg_upgrade, make sure your database is backed up > > > yes ok pea@ Here is an updated versi

Re: PostgreSQL 13.1 Upgrade

2021-02-04 Thread Pierre-Emmanuel Andr??
On Thu, Feb 04, 2021 at 09:33:48AM +, Stuart Henderson wrote: > On 2021/02/03 21:22, Pierre-Emmanuel Andr?? wrote: > > On Mon, Feb 01, 2021 at 05:00:41PM -0800, Jeremy Evans wrote: > > > On 02/01 07:24, Daniel Jakots wrote: > > > > Hi Pierre-Emmanuel and Jeremy, > > > > > > > > Is there anythi

Re: PostgreSQL 13.1 Upgrade

2021-02-04 Thread Stuart Henderson
On 2021/02/03 21:22, Pierre-Emmanuel Andr?? wrote: > On Mon, Feb 01, 2021 at 05:00:41PM -0800, Jeremy Evans wrote: > > On 02/01 07:24, Daniel Jakots wrote: > > > Hi Pierre-Emmanuel and Jeremy, > > > > > > Is there anything blocking the update? > > > > Nothing for me. pea@ can handle the commits

Re: PostgreSQL 13.1 Upgrade

2021-02-03 Thread Pierre-Emmanuel Andr??
On Mon, Feb 01, 2021 at 05:00:41PM -0800, Jeremy Evans wrote: > On 02/01 07:24, Daniel Jakots wrote: > > Hi Pierre-Emmanuel and Jeremy, > > > > Is there anything blocking the update? > > Nothing for me. pea@ can handle the commits whenever he sees fit, or if > he gives his OK, I can handle the c

Re: PostgreSQL 13.1 Upgrade

2021-02-01 Thread Jeremy Evans
On 02/01 07:24, Daniel Jakots wrote: > Hi Pierre-Emmanuel and Jeremy, > > Is there anything blocking the update? Nothing for me. pea@ can handle the commits whenever he sees fit, or if he gives his OK, I can handle the commits. Thanks, Jeremy

Re: PostgreSQL 13.1 Upgrade

2021-02-01 Thread Daniel Jakots
Hi Pierre-Emmanuel and Jeremy, Is there anything blocking the update? Cheers, Daniel

Re: PostgreSQL 13.1 Upgrade

2021-01-26 Thread Daniel Jakots
On Tue, 26 Jan 2021 11:03:25 +0100, Pierre-Emmanuel André wrote: > I made this small change to database/postgresql/Makefile to fix > WANTLIB: > > @@ -99,7 +98,7 @@ INSTALL_TARGET= install-world > LIB_DEPENDS-main= archivers/xz \ > converters/libiconv \ >

Re: PostgreSQL 13.1 Upgrade

2021-01-26 Thread Pierre-Emmanuel André
On Tue, Jan 26, 2021 at 09:20:55AM +0100, Pierre-Emmanuel André wrote: > On Mon, Jan 25, 2021 at 08:43:26PM -0500, Daniel Jakots wrote: > > On Fri, 20 Nov 2020 17:06:13 -0800, Jeremy Evans > > wrote: > > > > > Could we please have this tested in a bulk? Assuming there are no > > > problems in a

Re: PostgreSQL 13.1 Upgrade

2021-01-26 Thread Pierre-Emmanuel André
On Mon, Jan 25, 2021 at 08:43:26PM -0500, Daniel Jakots wrote: > On Fri, 20 Nov 2020 17:06:13 -0800, Jeremy Evans > wrote: > > > Could we please have this tested in a bulk? Assuming there are no > > problems in a bulk, OKs? > > Thanks for the diff! > I updated my server to it. It works fine for

Re: PostgreSQL 13.1 Upgrade

2021-01-25 Thread Daniel Jakots
On Fri, 20 Nov 2020 17:06:13 -0800, Jeremy Evans wrote: > Could we please have this tested in a bulk? Assuming there are no > problems in a bulk, OKs? Thanks for the diff! I updated my server to it. It works fine for me. There is: /usr/ports/databases/postgresql$ make port-lib-depends-check p

Re: PostgreSQL 13.1 Upgrade / update to TimescaleDB 2.0.0

2020-12-21 Thread Denis Fondras
Le Wed, Dec 02, 2020 at 10:15:48PM +0100, Denis Fondras a écrit : > > TimescaleDB's master branch still doesn't support PostgreSQL 13 (they > > also dropped support for <11): > > https://github.com/timescale/timescaledb/blob/master/CMakeLists.txt#L197 > > > > There is a work in progress pull reque

Re: PostgreSQL 13.1 Upgrade

2020-12-02 Thread Denis Fondras
On Wed, Dec 02, 2020 at 01:02:46PM -0800, Jeremy Evans wrote: > On 12/02 09:39, Christian Weisgerber wrote: > > Jeremy Evans: > > > > > Now that PostgreSQL 13.1 is out, I think we can consider upgrading to > > > it. The diff below was tested on amd64 on a partial bulk of the ports > > > depending

Re: PostgreSQL 13.1 Upgrade

2020-12-02 Thread Jeremy Evans
On 12/02 09:39, Christian Weisgerber wrote: > Jeremy Evans: > > > Now that PostgreSQL 13.1 is out, I think we can consider upgrading to > > it. The diff below was tested on amd64 on a partial bulk of the ports > > depending on PostgreSQL. > > > > Could we please have this tested in a bulk? > >

Re: PostgreSQL 13.1 Upgrade

2020-12-02 Thread Christian Weisgerber
Jeremy Evans: > Now that PostgreSQL 13.1 is out, I think we can consider upgrading to > it. The diff below was tested on amd64 on a partial bulk of the ports > depending on PostgreSQL. > > Could we please have this tested in a bulk? I ran this through a bulk build on amd64. Two build failures

skytools [was Re: PostgreSQL 13.1 Upgrade]

2020-11-21 Thread Stuart Henderson
On 2020/11/20 17:06, Jeremy Evans wrote: > skytools patch to fix build (dead upstream for about 3 years) it's still actively developed, but has been reorganized into separate projects (py-skytools, pgq, londiste, walmgr etc). Since the current distfile is no longer available here's an update to t

PostgreSQL 13.1 Upgrade

2020-11-20 Thread Jeremy Evans
Now that PostgreSQL 13.1 is out, I think we can consider upgrading to it. The diff below was tested on amd64 on a partial bulk of the ports depending on PostgreSQL. Thankfully, the changes were less extensive than in previous PostgreSQL major updates. Briefly, the changes: citus 9.0.1 -> 9.5.0