supabase-postgres.git / summary / log / commit / refs

commit    600e0507e70cc53da34d9d025fc31836cbf92c9e
Author:   Douglas J Hunley <doug.hunley@gmail.com>
Commit:   GitHub <noreply@github.com>
Date:     Wed Jun 17 19:58:25 2026 +0000

    refactor(ansible): relocate net.core.somaxconn to postgresql tuned profile (#2202)


 ansible/tasks/setup-system.yml |  5 -----
 ansible/tasks/setup-tuned.yml  | 13 +++++++++++++
 2 files changed, 13 insertions(+), 5 deletions(-)

diff --git a/ansible/tasks/setup-system.yml b/ansible/tasks/setup-system.yml
index 780d1337..5ce84760 100644
--- a/ansible/tasks/setup-system.yml
+++ b/ansible/tasks/setup-system.yml
@@ -165,8 +165,3 @@
     group: 'root'
   when:
     - (debpkg_mode or stage2_nix)
-
-- name: configure system
-  ansible.posix.sysctl:
-    name: 'net.core.somaxconn'
-    value: 16834
diff --git a/ansible/tasks/setup-tuned.yml b/ansible/tasks/setup-tuned.yml
index 55df36fb..5db45f51 100644
--- a/ansible/tasks/setup-tuned.yml
+++ b/ansible/tasks/setup-tuned.yml
@@ -176,6 +176,19 @@
       when:
         - (debpkg_mode or nixpkg_mode)
 
+    - name: tuned - Set net.core.somaxconn
+      become: true
+      community.general.ini_file:
+        create: true
+        group: 'root'
+        mode: '0644'
+        no_extra_spaces: true
+        option: 'net.core.somaxconn'
+        path: '/etc/tuned/profiles/postgresql/tuned.conf'
+        section: 'sysctl'
+        state: 'present'
+        value: 16834
+
     - name: tuned - Enable zswap if swap is present
       when:
         - ansible_facts['swaptotal_mb'] > 0