Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQV1V-0006Xa-8L for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 31 Jul 2023 15:41:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qQV0U-000lAP-IO for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 31 Jul 2023 15:40:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQV0U-000lAH-8T for pgsql-pkg-debian@lists.postgresql.org; Mon, 31 Jul 2023 15:40:27 +0000 Received: from mail-lf1-x136.google.com ([2a00:1450:4864:20::136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qQV0S-00017l-U3 for pgsql-pkg-debian@lists.postgresql.org; Mon, 31 Jul 2023 15:40:26 +0000 Received: by mail-lf1-x136.google.com with SMTP id 2adb3069b0e04-4fe3e88bd5fso447597e87.3 for ; Mon, 31 Jul 2023 08:40:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690818023; x=1691422823; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=d3OZLCrI3wbtmsuDVnELHFojNPwaBoQX91Hra9UOFIs=; b=j/wJicrKZFsKMxts8MONplLn+ay87kgeFbnEBpogb0upadUR+QGHFyfQDxHJruBTnH r/RR+sawcyiakiTk9Aaki5twzzU0b3vWB7pvMzmL1ZO8rEVATAuoL2FCEMl8enstuntz OHkP5MQwMtLZ/6MHGdVxa7J+hd0j4jb6CrgCoi5JrHgChkD1zbhQ88rsuRBvF7vVIUH3 x5nXXHa7YQZQvH63olLJrZ6PriiqWtFk6Pw31piqmV6uAo4brN1yqE7nUccFp3Zlaj8k dHlOjyzC34HDPfMzDZ14agnJ2urlsgU6t6TTJpX7N3jpvMLr4U4Qt1RSxkd566Y6eubl Onhg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690818023; x=1691422823; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=d3OZLCrI3wbtmsuDVnELHFojNPwaBoQX91Hra9UOFIs=; b=i36VQRiz1U7rpMtnP949kQOd/Q2/50TH/VJMixR5lcD0gJYG3N6tvoWfLAzVART+jr iCKgrdYE+RyzRJlnKbcXMwg6SbmgbfOnZMlhCQz4MLDY3x1txpRjbPaQSKX2K+qr5EvV IUUg0Rrx7icXc19mC5CuDHuO5i1rREzfRQWTqQEb5gkFf29GQdPIXeXhcCTV9hfh1NP2 4Dp/AMLYANU0h4E+XKWNX18G3y1tIlbP9T7qbfG45ss2jpkn5glvuHIdIEKmyvgYuRzO kUTbGSw5o0j+2OlTQnbhTQPJpCgIjbN+633DR0aSsVQVU8Ul1FWTayaCjgWRUPHD3Io5 hcMw== X-Gm-Message-State: ABy/qLa9qY7lwmcxrFRdlSZ6Xhw8O0tAhGVYezr2z0b+9GAJY/VjwK1V Maa5FG3QiCN9BXB8h3sQ8HfbaHp/A1n88Q5uTy4= X-Google-Smtp-Source: APBJJlGvVbJPZAEPtOr1JGgBGl1TdneunVk/m5z5m2mn3Xchx9yFfT9kbHx30JpCD50cXdqE7/kxXD5TYimKsnztTjM= X-Received: by 2002:a19:5003:0:b0:4fb:c0b5:63d4 with SMTP id e3-20020a195003000000b004fbc0b563d4mr126641lfb.43.1690818022941; Mon, 31 Jul 2023 08:40:22 -0700 (PDT) MIME-Version: 1.0 References: <75679669-4482-3f16-bd4d-6ec1f9950941@abcsql.com> In-Reply-To: From: Esteban Zimanyi Date: Mon, 31 Jul 2023 17:39:47 +0200 Message-ID: Subject: Re: Packaging request MobilityDB To: Christoph Berg Cc: Bradford Boyle , =?UTF-8?Q?C=C3=A9dric_Villemain?= , pgsql-pkg-debian@lists.postgresql.org, SCHOEMANS Maxime Content-Type: multipart/alternative; boundary="000000000000a32a360601ca3f63" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a32a360601ca3f63 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Many thanks Christoph for your work ! Regarding one of the request by Bradford, please notice that we have just created the following tag for facilitating the packaging https://github.com/MobilityDB/MobilityDB/releases/tag/v1.1.0-alpha On Mon, Jul 31, 2023 at 4:59=E2=80=AFPM Christoph Berg wr= ote: > > Hi, > > I've finally found the time to look at MobilityDB. > > Re: Bradford Boyle > > * Debian 13 (trixie/testing) > > - builds successfully > > - piuparts passes > > - autopkgtests fail for trixie (testing) > > * test failure looks to be an issue with the newer libproj (9.2.1) > > included in trixie > > When I run the tests on unstable I get this: > > $ debian/tests/installcheck > Creating new PostgreSQL cluster 15/regress ... > test 001_set ... *** /tmp/pg_virtualenv.ye3HhD/log/postgresql-15-regress.log (last 100 lines) **= * > 2023-07-31 14:44:57.593 UTC [321171] LOG: starting PostgreSQL 15.3 (Debian 15.3-0+deb12u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit > 2023-07-31 14:44:57.593 UTC [321171] LOG: listening on IPv4 address "127.0.0.1", port 5433 > 2023-07-31 14:44:57.594 UTC [321171] LOG: could not bind IPv4 address "127.0.0.1": Address already in use > 2023-07-31 14:44:57.594 UTC [321171] HINT: Is another postmaster already running on port 5433? If not, wait a few seconds and retry. > 2023-07-31 14:44:57.594 UTC [321171] LOG: listening on Unix socket "/tmp/.s.PGSQL.5433" > 2023-07-31 14:44:57.595 UTC [321174] LOG: database system was shut down at 2023-07-31 14:44:57 UTC > 2023-07-31 14:44:57.597 UTC [321171] LOG: database system is ready to accept connections > 2023-07-31 14:45:00.903 UTC [321209] myon@postgres ERROR: Could not parse the set: Missing open brace at character 29 > 2023-07-31 14:45:00.903 UTC [321209] myon@postgres STATEMENT: /* Errors */ > SELECT tstzset '2000-01-01, 2000-01-02'; > Dropping cluster 15/regress ... > > (After setting : ${AUTOPKGTEST_TMP:=3D/tmp} ) > > debian/copyright: LICENSE mentions the ULB - haven't checked the rest > of the source yet > > debian/tests/installcheck: Why is that .so trickery necessary? If > mobilitydb needs postgis that way, it should link against it. > > debian/control.in: This would be the first package to use PGVERSION in > the Build-Depends list. I'm slightly surprised it works, but > apparently I coded the logic in pg_buildext correctly. ;) > > Is the postgis version used at build time relevant? There is a > postgresql-postgis package that could be used instead. (If the version > is relevant, we need a solution that works when more than one version > is targeted.) > > Christoph --000000000000a32a360601ca3f63 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Many thanks Christoph for your work !
Regarding one of= the request by Bradford, please notice that we have just created the follo= wing tag for facilitating the packaging

On= Mon, Jul 31, 2023 at 4:59=E2=80=AFPM Christoph Berg <myon@debian.org> wrote:
>
> Hi,
>=
> I've finally found the time to look at MobilityDB.
>
= > Re: Bradford Boyle
> > * Debian 13 (trixie/testing)
> &= gt; - builds successfully
> > - piuparts passes
> > - aut= opkgtests fail for trixie (testing)
> > * test failure looks to be= an issue with the newer libproj (9.2.1)
> > included in trixie>
> When I run the tests on unstable I get this:
>
> = $ debian/tests/installcheck
> Creating new PostgreSQL cluster 15/regr= ess ...
> test 001_set =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0... *** /tmp/pg_virtualenv.ye3HhD/log/postgr= esql-15-regress.log (last 100 lines) ***
> 2023-07-31 14:44:57.593 UT= C [321171] LOG: =C2=A0starting PostgreSQL 15.3 (Debian 15.3-0+deb12u1) on x= 86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
&g= t; 2023-07-31 14:44:57.593 UTC [321171] LOG: =C2=A0listening on IPv4 addres= s "127.0.0.1", port 5433
> 2023-07-31 14:44:57.594 UTC [321= 171] LOG: =C2=A0could not bind IPv4 address "127.0.0.1": Address = already in use
> 2023-07-31 14:44:57.594 UTC [321171] HINT: =C2=A0Is = another postmaster already running on port 5433? If not, wait a few seconds= and retry.
> 2023-07-31 14:44:57.594 UTC [321171] LOG: =C2=A0listeni= ng on Unix socket "/tmp/.s.PGSQL.5433"
> 2023-07-31 14:44:5= 7.595 UTC [321174] LOG: =C2=A0database system was shut down at 2023-07-31 1= 4:44:57 UTC
> 2023-07-31 14:44:57.597 UTC [321171] LOG: =C2=A0databas= e system is ready to accept connections
> 2023-07-31 14:45:00.903 UTC= [321209] myon@postgres ERROR: =C2=A0Could not parse the set: Missing open = brace at character 29
> 2023-07-31 14:45:00.903 UTC [321209] myon@pos= tgres STATEMENT: =C2=A0/* Errors */
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 SEL= ECT tstzset '2000-01-01, 2000-01-02';
> Dropping cluster 15/r= egress ...
>
> (After setting : ${AUTOPKGTEST_TMP:=3D/tmp} )>
> debian/copyright: LICENSE mentions the ULB - haven't chec= ked the rest
> of the source yet
>
> debian/tests/install= check: Why is that .so trickery necessary? If
> mobilitydb needs post= gis that way, it should link against it.
>
> debian/control.in: This would be the first package to use P= GVERSION in
> the Build-Depends list. I'm slightly surprised it w= orks, but
> apparently I coded the logic in pg_buildext correctly. ;)=
>
> Is the postgis version used at build time relevant? There = is a
> postgresql-postgis package that could be used instead. (If the= version
> is relevant, we need a solution that works when more than = one version
> is targeted.)
>
> Christoph
--000000000000a32a360601ca3f63--