Renovate config for standard images

[srkoster]

I have migrated a first cluster to the standard image ghcr.io/cloudnative-pg/postgresql:17.5-202507210807-standard-bookworm

Today a new version was published 17.5-202507280807-standard-bookworm but it wasn't picked up by my Renovate job.

I have been struggling all evening but have failed to create a new working Renovate config for these new images. Did anybody succeed?

Here's my old customManager which worked for the legacy syntax.

{
  $schema: 'https://docs.renovatebot.com/renovate-schema.json',
  customManagers: [
    {
           customType: 'regex',
           description: ["Process CloudnativePG Postgresql version"],
           fileMatch: ["(^|/)kubernetes/.+\\.ya?ml$"],
           matchStrings: ["imageName: (?<depName>ghcr\\.io/cloudnative-pg/postgresql):(?<currentValue>.*\\-.*)"],
           datasourceTemplate: 'docker',
           versioningTemplate: 'redhat'
    }
  ]
}