<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>No one had any reasons not to and I gave a +1.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I did a setup for docker-postgis in a separate branch. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="https://github.com/postgis/docker-postgis/tree/circleci-project-setup">https://github.com/postgis/docker-postgis/tree/circleci-project-setup</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m assuming all that needs to be done is create a circle-ci in the main repo? To complete the job<o:p></o:p></p><p class=MsoNormal>I assume Imre can use his working one for that.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Imre,<o:p></o:p></p><p class=MsoNormal>Let me know if I need to do anything else.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal>Regina<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> Regina Obe <lr@pcorp.us> <br><b>Sent:</b> Friday, August 25, 2023 6:19 PM<br><b>To:</b> 'PostGIS Development Discussion' <postgis-devel@lists.osgeo.org><br><b>Subject:</b> RE: [postgis-devel] PSC Vote: Circle CI signup for Free plan<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Imre,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks for taking the lead on the docker-postgis work. It’s been great to see it flourish under your guidance.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding Cirrus – we are already using that for postgis repo for testing MacOSX / FreeBSD.<o:p></o:p></p><p class=MsoNormal>I think we are already overtaxed on that so I’m fine with not using that for the docker-postgis repo.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I think our still best bet is to use CircleCI and use the work you have already put in it already in your tests and I think the<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>“Open source projects can access up to 400,000 credits per month (equivalent to 80,000 build minutes) to use on Linux, Arm, and Docker.”<o:p></o:p></i></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>Should be enough for our needs. The credits do seem more generous than Cirrus as I recall.<o:p></o:p></p><p class=MsoNormal>Travis was suggested as an option too by Even, but I think that is a no-go too since it would be more work to retool to work with that,<o:p></o:p></p><p class=MsoNormal>and moving the docker-postgis repo from postgis github org to osgeo github org, I see no benefit at this time in doing. <o:p></o:p></p><p class=MsoNormal>OSGeo org might make sense though for the geo bundle you were detailing since pgrouting, MobilityDB, and PostGIS are all OSGeo projects or community projects.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Both pgRouting and MobilityDB are still community projects, but pgrouting I think we are close to completing incubation work. <o:p></o:p></p><p class=MsoNormal>MobilityDB still has a ways to go, but is still an OSGeo community project.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>That said, I’ll give people one more week to express comments about this topic before I move forward with it.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal>Regina<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> postgis-devel <<a href="mailto:postgis-devel-bounces@lists.osgeo.org">postgis-devel-bounces@lists.osgeo.org</a>> <b>On Behalf Of </b>Imre Samu<br><b>Sent:</b> Friday, August 25, 2023 2:34 PM<br><b>To:</b> PostGIS Development Discussion <<a href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a>><br><b>Subject:</b> Re: [postgis-devel] PSC Vote: Circle CI signup for Free plan<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><div><p class=MsoNormal>Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> ezt írta (időpont: 2023. aug. 22., K, 21:04)<o:p></o:p></p></div></div><div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'><p class=MsoNormal>The docker-postgis sub-group wants to start shipping ARM docker containers<br>and the easiest route for that would be to use CircleCI.<o:p></o:p></p></blockquote><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I'm currently working on expanding the docker-postgis code.<o:p></o:p></p></div><div><p class=MsoNormal>One of the most requested features right now by users is the Arm64/v8 (Aarch64) based postgis docker image.<o:p></o:p></p></div><p class=MsoNormal>( <a href="https://github.com/postgis/docker-postgis/issues/216">https://github.com/postgis/docker-postgis/issues/216</a> )<o:p></o:p></p></div><div><p class=MsoNormal><br>I've already built a working prototype on CircleCI. <br>For further testing, we need to decide if we're going with this or if we need a different solution.<br><br>Comment: Because we need to give CircleCI access to Docker Hub for this, <o:p></o:p></p></div><div><p class=MsoNormal>and we want to keep the process secure, it wouldn't be ideal to use our own developer accounts to create the images.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Some other updates I'm working on:<o:p></o:p></p></div><div><p class=MsoNormal>- Adding 'bookworm' support while maintaining existing 'bullseye' support. ( 15-3.4-bookworm , 15-3.4-bullseye )<o:p></o:p></p></div><div><p class=MsoNormal> Later, we'll also support 2 alpine versions, similar to the upstream docker postgres repo we're building on. <o:p></o:p></p></div><div><p class=MsoNormal><br>- We'll have expanded docker image tagging. (15-3.4-bookworm, 15-3.4.0-bookworm, 15-3.4, latest )<br><br>- To keep the base postgis/postgis images small, I'm planning simple Debian-based (geo)bundle images built on them, <o:p></o:p></p></div><div><p class=MsoNormal> with features like pgRouting, MobilityDB, pg_h3, pgsql-gzip, pgsql-http, ogr-fdw, pointcloud, TimescaleDB, pgvector, etc. This area is still fluid though.<o:p></o:p></p></div><div><p class=MsoNormal> ( 15-3.4-bundle-bookworm )<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I've got a minimal working prototype:<o:p></o:p></p></div><div><p class=MsoNormal>- docker images: <a href="https://hub.docker.com/r/imresamu/postgis">https://hub.docker.com/r/imresamu/postgis</a><o:p></o:p></p></div><div><p class=MsoNormal>- code: <a href="https://github.com/ImreSamu/docker-postgis">https://github.com/ImreSamu/docker-postgis</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I'm trying to expand the system so that if there's demand, we can easily create older Postgis versions like 3.3, 3.2, 3.1 based on Alpine.<o:p></o:p></p></div><div><p class=MsoNormal>I'm also thinking about a weekly auto-updated "postgis/postgis:*-master" version to support testing of other osgeos projects built on postgis.<o:p></o:p></p></div><div><p class=MsoNormal><br>CircleCI provides about 80,000 build minutes/month for open source. This should likely cover the docker-postgis sub-project's needs.<o:p></o:p></p></div><div><p class=MsoNormal>My developer account on CircleCI also received the same amount of open source credits/minutes.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>In the <a href="https://circleci.com/pricing/" target="_blank">https://circleci.com/pricing/</a> FAQ:<o:p></o:p></p></div><div><div><p class=MsoNormal>"""<br>What if I am building open-source?<o:p></o:p></p></div><div><p class=MsoNormal><i>CircleCI offers free access to compute time and resources for organizations on our Free plan. </i><o:p></o:p></p></div><div><p class=MsoNormal><i>Open source projects can access up to 400,000 credits per month (equivalent to 80,000 build minutes) to use on Linux, Arm, and Docker.<br>Open source Windows and macOS builds or private repositories can use the 30,000 credits offered in our free plan.<br>If you are building a bigger open source project and would like the flexibility of our new plans, let us know how we can help you!<br></i>+ <a href="https://circleci.com/open-source/" target="_blank">https://circleci.com/open-source/</a> <o:p></o:p></p></div><p class=MsoNormal>"""<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Another Arm64 Alternative: <a href="https://cirrus-ci.org/features/">https://cirrus-ci.org/features/</a> <a href="https://cirrus-ci.org/blog/2023/07/17/limiting-free-usage-of-cirrus-ci/">https://cirrus-ci.org/blog/2023/07/17/limiting-free-usage-of-cirrus-ci/</a><o:p></o:p></p></div><div><p class=MsoNormal> I haven't tested it, but it seems promising.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>And there are other CI providers: <a href="https://wiki.postgresql.org/wiki/CI_Providers">https://wiki.postgresql.org/wiki/CI_Providers</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>If you have any related questions, I'm here to help.<br>Regards, <o:p></o:p></p></div><div><p class=MsoNormal> Imre <o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div></div></div></div></div></div></body></html>