Update/Add Postgres Version option

[PaulieScanlon]

Tool name

postgresql.service

Tool license

MIT

Add or update?

• Add
• Update

Desired version

postgresql 17

Approximate size

No response

Brief description of tool

I've been using postgresql.service to perform scheduled dump/restore of my postgres database and it works great with the built-in version. However. Since the built-in service is set to "latest" there might be cases where i'll hit mismatch errors.

It would be so good if, when using the built-in service i could set which version of Postgres to use. E. g

jobs:
  dump-and-restore:
    runs-on: ubuntu-latest

    steps:
      - name: Start PostgreSQL Service
        run: |
          sudo systemctl start postgresql.service -v 17 // i've added the -v 17 to show one way this could work

Watta you think?

URL for tool's homepage

No response

Provide a basic test case to validate the tool's functionality.

Platforms where you need the tool

• Azure DevOps
• GitHub Actions

Runner images where you need the tool

• Ubuntu 20.04
• Ubuntu 22.04
• Ubuntu 24.04
• macOS 13
• macOS 13 Arm64
• macOS 14
• macOS 14 Arm64
• macOS 15
• macOS 15 Arm64
• Windows Server 2019
• Windows Server 2022
• Windows Server 2025

Can this tool be installed during the build?

Tool installation time in runtime

No response

Are you willing to submit a PR?

No response

[lakshminarayana02]

Hi
We are validating your request and according to the description, we assume that it is required for latest Ubuntu version.

[PaulieScanlon]

Hi @lakshminarayana02, wow, thanks. Super quick.

Hmm, great question. I don't know enough about Ubuntu, but would it be safe to assume that "Ubuntu latest" would work with any version of PostgreSQL?

I suppose there might be a risk with providing a -v option for the version of PostgreSQL and then later running into issues because it can't run on whatever version of Ubuntu the runner is currently using.

What do you think?

[lakshminarayana02]

Hi
acknowledged, we'll keep you updated.

[PaulieScanlon]

Great, thanks @lakshminarayana02!

[lakshminarayana02]

Hi
We tested it, and changes are likely to be implemented in forthcoming deployments based on the internal process. Please bear with us.

[PaulieScanlon]

Hey @lakshminarayana02, super stuff. Thank you.!

[Prabhatkumar59]

Hi @PaulieScanlon - The requirement will be taken care under this announcement(#11723).
Thanks!