# Deployment of PostgreSQL SchedulerDB at CERN

**URL:** <https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413>\
**Category:** General Discussion\
**Created:** [24 November 2025 16:49 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413 "2025-11-24T16:49:04Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![george\_patargias](https://cta-community.web.cern.ch/letter_avatar_proxy/v4/letter/g/b9bd4f/32.png) [@george\_patargias](https://cta-community.web.cern.ch/u/george_patargias)\
**Post date:** [24 November 2025 16:49 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413/1 "2025-11-24T16:49:05Z")

</div>

Hello,

Can you please confirm the exact target year for deploying the PostgreSQL SchedulerDB in production at CERN?

I do recall from the CTA 2025 workshop that the aim is to have the new scheduler setup ready before the beginning of LHC Run 4. Does this mean 2029 or 2030?

Thanks,

George

---

<div class="post-metadata">

**Author:** ![mdavis](https://cta-community.web.cern.ch/user_avatar/cta-community.web.cern.ch/mdavis/32/16_2.png) [@mdavis](https://cta-community.web.cern.ch/u/mdavis)\
**Post date:** [25 November 2025 08:09 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413/2 "2025-11-25T08:09:23Z")

</div>

Hi George,

We are targetting Q1 2026 to deploy the PostgreSQL SchedulerDB on our **Repack** instance only.

All physics instances will stay on the objectstore SchedulerDB until end of Run-3. During the next year we will focus on scale/stress testing with the goal of full deployment in 2027.

Michael

---

<div class="post-metadata">

**Author:** ![george\_patargias](https://cta-community.web.cern.ch/letter_avatar_proxy/v4/letter/g/b9bd4f/32.png) [@george\_patargias](https://cta-community.web.cern.ch/u/george_patargias)\
**Post date:** [25 November 2025 12:12 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413/3 "2025-11-25T12:12:08Z")

</div>

Hi Michael,

Thanks for the clear timeline.

The context of my question is that our CTA Ceph nodes (purchased in 2019) are not any more under warranty and need to be replaced soon which means that we will be running an objectstore SchedulerDB past 2027. Are you going to support the Ceph object store (at least on the level of tickets) past this date?

Best,

George

---

<div class="post-metadata">

**Author:** ![mdavis](https://cta-community.web.cern.ch/user_avatar/cta-community.web.cern.ch/mdavis/32/16_2.png) [@mdavis](https://cta-community.web.cern.ch/u/mdavis)\
**Post date:** [26 November 2025 10:44 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413/4 "2025-11-26T10:44:23Z")

</div>

Hi George,

Once we have migrated to the PostgreSQL SchedulerDB we would like to deprecate the Ceph objectstore as soon as possible. One of the motivations to switch is to free ourselves from certain constraints of the objectstore. Future developments of the CTA scheduler are not guaranteed to be backwards compatible.

Once we have a stable production release of the PostgreSQL SchedulerDB we will be in contact with all CTA sites to work on a migration schedule. This is foreseen for 2027.

Cheers,  
Michael

---

<div class="post-metadata">

**Author:** ![george\_patargias](https://cta-community.web.cern.ch/letter_avatar_proxy/v4/letter/g/b9bd4f/32.png) [@george\_patargias](https://cta-community.web.cern.ch/u/george_patargias)\
**Post date:** [26 November 2025 15:09 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413/5 "2025-11-26T15:09:27Z")

</div>

Thanks for clarifying all this Michael.

Given that all sites will need to work on a migration schedule in 2027, I conclude that there is no point to purchase new Ceph nodes (that will arrive in 2026) with a 5-year lifetime.

---

<div class="post-metadata">

**Author:** ![george\_patargias](https://cta-community.web.cern.ch/letter_avatar_proxy/v4/letter/g/b9bd4f/32.png) [@george\_patargias](https://cta-community.web.cern.ch/u/george_patargias)\
**Post date:** [28 November 2025 10:57 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413/6 "2025-11-28T10:57:07Z")

</div>

One last question: what are the hardware provisioning requirements for a cluster/node that runs PostgreSQL SchedulerDB? Is there a need to have the spec of hosts running a standard PostgreSQL DB?

Best,

George

---

<div class="post-metadata">

**Author:** ![george\_patargias](https://cta-community.web.cern.ch/letter_avatar_proxy/v4/letter/g/b9bd4f/32.png) [@george\_patargias](https://cta-community.web.cern.ch/u/george_patargias)\
**Post date:** [28 November 2025 12:23 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413/7 "2025-11-28T12:23:55Z")

</div>

Feedback from our DB architect

> Our standard PostgreSQL high-availability (HA) configuration consists of three nodes: one primary, one secondary (replica), and one witness node for quorum and failover management. All PostgreSQL instances will run on Proxmox virtual machine hosts to ensure flexibility and resource efficiency.

---

<div class="post-metadata">

**Author:** ![mdavis](https://cta-community.web.cern.ch/user_avatar/cta-community.web.cern.ch/mdavis/32/16_2.png) [@mdavis](https://cta-community.web.cern.ch/u/mdavis)\
**Post date:** [28 November 2025 13:11 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413/8 "2025-11-28T13:11:49Z")

</div>

Hi George,

We do not yet have any information on hardware requirements. We plan to use the central IT department PostgreSQL service in the first instance, so we will not run the DB backend ourselves.

Once we have it running, we will collect telemetry and do stress testing and observe performance over time. In particular we want to observe whether VACUUM causes any performance penalty. At that point we should be able to give some informed advice.

I realise that you are ordering hardware now, so if you can’t wait, I can suggest asking the CERN DB team. Let me know if you need a contact.

Cheers,

Michael

---

<div class="post-metadata">

**Author:** ![george\_patargias](https://cta-community.web.cern.ch/letter_avatar_proxy/v4/letter/g/b9bd4f/32.png) [@george\_patargias](https://cta-community.web.cern.ch/u/george_patargias)\
**Post date:** [1 December 2025 12:50 UTC](https://cta-community.web.cern.ch/t/deployment-of-postgresql-schedulerdb-at-cern/413/9 "2025-12-01T12:50:25Z")

</div>

Hi Michael,

Thanks, I will not need a contact from the CERN DB team. As our DB team has confirmed that they will not be deploying PostgreSQL on physical hardware, I think it makes sense to wait until 2027 and pick up this issue when we will be working on the migration schedule with you.

Best,

George
