imusmanmalik/cloudnative-pg-timescaledb-postgis-containers

Operand images for CloudNativePG containing PostgreSQL with TimescaleDB and PostGIS

---

---

🔝 Top Contributed Repo

---

💰 You can support me by Donating

cloudnative-pg-timescaledb-postgis-containers's Issues

Add Timescale Tagging

Consider adding the Timescale version to the image tag name. I am finding out (the hard way) that restoring a backup from running an image with and older version of Timescale is a challenge. Ideally the backup should restore to a server with the same Timescale version.

Add PG16

At first glance, it looks like it just requires the addition of a 16 folder. Is that correct?

timescaledb-postgis:16 for ARM64 not working

Docker manifest inspect provides an image availability for ARM64 arch.
However when run on "amzn2.aarch64" / m6g, the initdb returns exec format error, so it is probably built for AMD not ARM.

initdb Error: error while creating the PostgreSQL instance: fork/exec /usr/lib/postgresql/16/bin/initdb: exec format error 

➜  ~ docker manifest inspect ghcr.io/imusmanmalik/timescaledb-postgis:16  
{
   "schemaVersion": 2,
   "mediaType": "application/vnd.oci.image.index.v1+json",
   "manifests": [
      {
         "mediaType": "application/vnd.oci.image.manifest.v1+json",
         "size": 4666,
         "digest": "sha256:8da5df8587c1612e016efc47e2c21f16cb238f3b4d1f6a726272575fd74bda2c",
         "platform": {
            "architecture": "amd64",
            "os": "linux"
         }
      },
      {
         "mediaType": "application/vnd.oci.image.manifest.v1+json",
         "size": 4666,
         "digest": "sha256:df5eda79879c7a84373388ae0a3ef2bdfb0f4de7f6230c7d55acc3614035f68f",
         "platform": {
            "architecture": "arm64",
            "os": "linux"
         }
      },
      {
         "mediaType": "application/vnd.oci.image.manifest.v1+json",
         "size": 567,
         "digest": "sha256:be01511e6509f95cbdcd199c3fd15945b56461a497f80b3dc110e1be30d4744f",
         "platform": {
            "architecture": "unknown",
            "os": "unknown"
         }
      },
      {
         "mediaType": "application/vnd.oci.image.manifest.v1+json",
         "size": 567,
         "digest": "sha256:9b70bfd272398703c8c74de819a9efc245d4f32adcb861ff3b2444824017599c",
         "platform": {
            "architecture": "unknown",
            "os": "unknown"
         }
      }
   ]
}

Add Timescale Toolkit to Image

Add the timescale hyperfunction toolkit to the build
https://docs.timescale.com/self-hosted/latest/tooling/install-toolkit/#install-toolkit-on-ubuntu-and-other-debian-based-systems
#22

Dependency Dashboard

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

Open

These updates have all been created already. Click a checkbox below to force a retry/rebase of any.

• chore(deps): update postgis/postgis docker tag to v15

Detected dependencies

dockerfile

TimescaleDB-PostGIS/12/Dockerfile

• postgis/postgis 12-3.3

TimescaleDB-PostGIS/13/Dockerfile

• postgis/postgis 13-3.3

TimescaleDB-PostGIS/14/Dockerfile

• postgis/postgis 14-3.3

TimescaleDB-PostGIS/15/Dockerfile

• postgis/postgis 15-3.3

TimescaleDB-PostGIS/Dockerfile.template

github-actions

.github/workflows/build.yml

• actions/checkout v3
• actions/checkout v3
• docker/setup-qemu-action v2
• docker/setup-buildx-action v2
• docker/login-action v2
• docker/build-push-action v4
• erzz/dockle-action v1
• docker/build-push-action v4

.github/workflows/update.yml

• actions/checkout v3
• nick-fields/retry v2
• benjefferies/branch-protection-bot 1.0.7
• EndBug/add-and-commit v9
• benjefferies/branch-protection-bot 1.0.7

pip_requirements

TimescaleDB-PostGIS/12/requirements.txt

• argcomplete ==2.0.0
• azure-core ==1.26.3
• azure-identity ==1.12.0
• azure-storage-blob ==12.15.0
• barman ==3.4.0
• boto3 ==1.26.83
• botocore ==1.29.83
• cachetools ==5.3.0
• certifi ==2022.12.7
• cffi ==1.15.1
• charset-normalizer ==3.0.1
• cryptography ==39.0.2
• google-api-core ==2.11.0
• google-auth ==2.16.2
• google-cloud-core ==2.3.2
• google-cloud-storage ==2.7.0
• google-crc32c ==1.5.0
• google-resumable-media ==2.4.1
• googleapis-common-protos ==1.58.0
• idna ==3.4
• isodate ==0.6.1
• jmespath ==1.0.1
• msal ==1.21.0
• msal-extensions ==1.0.0
• portalocker ==2.7.0
• protobuf ==4.22.0
• pyasn1 ==0.4.8
• pyasn1-modules ==0.2.8
• pycparser ==2.21
• pyjwt ==2.6.0
• python-dateutil ==2.8.2
• python-snappy ==0.6.1
• requests ==2.28.2
• rsa ==4.9
• s3transfer ==0.6.0
• six ==1.16.0
• typing-extensions ==4.5.0
• urllib3 ==1.26.14

TimescaleDB-PostGIS/13/requirements.txt

• argcomplete ==2.0.0
• azure-core ==1.26.3
• azure-identity ==1.12.0
• azure-storage-blob ==12.15.0
• barman ==3.4.0
• boto3 ==1.26.83
• botocore ==1.29.83
• cachetools ==5.3.0
• certifi ==2022.12.7
• cffi ==1.15.1
• charset-normalizer ==3.0.1
• cryptography ==39.0.2
• google-api-core ==2.11.0
• google-auth ==2.16.2
• google-cloud-core ==2.3.2
• google-cloud-storage ==2.7.0
• google-crc32c ==1.5.0
• google-resumable-media ==2.4.1
• googleapis-common-protos ==1.58.0
• idna ==3.4
• isodate ==0.6.1
• jmespath ==1.0.1
• msal ==1.21.0
• msal-extensions ==1.0.0
• portalocker ==2.7.0
• protobuf ==4.22.0
• pyasn1 ==0.4.8
• pyasn1-modules ==0.2.8
• pycparser ==2.21
• pyjwt ==2.6.0
• python-dateutil ==2.8.2
• python-snappy ==0.6.1
• requests ==2.28.2
• rsa ==4.9
• s3transfer ==0.6.0
• six ==1.16.0
• typing-extensions ==4.5.0
• urllib3 ==1.26.14

TimescaleDB-PostGIS/14/requirements.txt

• argcomplete ==2.0.0
• azure-core ==1.26.3
• azure-identity ==1.12.0
• azure-storage-blob ==12.15.0
• barman ==3.4.0
• boto3 ==1.26.83
• botocore ==1.29.83
• cachetools ==5.3.0
• certifi ==2022.12.7
• cffi ==1.15.1
• charset-normalizer ==3.0.1
• cryptography ==39.0.2
• google-api-core ==2.11.0
• google-auth ==2.16.2
• google-cloud-core ==2.3.2
• google-cloud-storage ==2.7.0
• google-crc32c ==1.5.0
• google-resumable-media ==2.4.1
• googleapis-common-protos ==1.58.0
• idna ==3.4
• isodate ==0.6.1
• jmespath ==1.0.1
• msal ==1.21.0
• msal-extensions ==1.0.0
• portalocker ==2.7.0
• protobuf ==4.22.0
• pyasn1 ==0.4.8
• pyasn1-modules ==0.2.8
• pycparser ==2.21
• pyjwt ==2.6.0
• python-dateutil ==2.8.2
• python-snappy ==0.6.1
• requests ==2.28.2
• rsa ==4.9
• s3transfer ==0.6.0
• six ==1.16.0
• typing-extensions ==4.5.0
• urllib3 ==1.26.14

TimescaleDB-PostGIS/15/requirements.txt

• argcomplete ==2.0.0
• azure-core ==1.26.3
• azure-identity ==1.12.0
• azure-storage-blob ==12.15.0
• barman ==3.4.0
• boto3 ==1.26.83
• botocore ==1.29.83
• cachetools ==5.3.0
• certifi ==2022.12.7
• cffi ==1.15.1
• charset-normalizer ==3.0.1
• cryptography ==39.0.2
• google-api-core ==2.11.0
• google-auth ==2.16.2
• google-cloud-core ==2.3.2
• google-cloud-storage ==2.7.0
• google-crc32c ==1.5.0
• google-resumable-media ==2.4.1
• googleapis-common-protos ==1.58.0
• idna ==3.4
• isodate ==0.6.1
• jmespath ==1.0.1
• msal ==1.21.0
• msal-extensions ==1.0.0
• portalocker ==2.7.0
• protobuf ==4.22.0
• pyasn1 ==0.4.8
• pyasn1-modules ==0.2.8
• pycparser ==2.21
• pyjwt ==2.6.0
• python-dateutil ==2.8.2
• python-snappy ==0.6.1
• requests ==2.28.2
• rsa ==4.9
• s3transfer ==0.6.0
• six ==1.16.0
• typing-extensions ==4.5.0
• urllib3 ==1.26.14

TimescaleDB-PostGIS/src/requirements.txt

• argcomplete ==2.0.0
• azure-core ==1.26.3
• azure-identity ==1.12.0
• azure-storage-blob ==12.15.0
• barman ==3.4.0
• boto3 ==1.26.83
• botocore ==1.29.83
• cachetools ==5.3.0
• certifi ==2022.12.7
• cffi ==1.15.1
• charset-normalizer ==3.0.1
• cryptography ==39.0.2
• google-api-core ==2.11.0
• google-auth ==2.16.2
• google-cloud-core ==2.3.2
• google-cloud-storage ==2.7.0
• google-crc32c ==1.5.0
• google-resumable-media ==2.4.1
• googleapis-common-protos ==1.58.0
• idna ==3.4
• isodate ==0.6.1
• jmespath ==1.0.1
• msal ==1.21.0
• msal-extensions ==1.0.0
• portalocker ==2.7.0
• protobuf ==4.22.0
• pyasn1 ==0.4.8
• pyasn1-modules ==0.2.8
• pycparser ==2.21
• pyjwt ==2.6.0
• python-dateutil ==2.8.2
• python-snappy ==0.6.1
• requests ==2.28.2
• rsa ==4.9
• s3transfer ==0.6.0
• six ==1.16.0
• typing-extensions ==4.5.0
• urllib3 ==1.26.14

---

• Check this box to trigger a request for Renovate to run again on this repository