#!/bin/bash
#Note review get version via cmd

pgver=17
pg_file="/etc/postgresql/${pgver}/main/postgresql.conf"

sudo -u postgres sed -i "/listen_addresses/c\listen_addresses = 'localhost,10.33.77.16'" ${pg_file}
sudo -u postgres sed -i "/max_connections/c\max_connections = 2000" ${pg_file}
sudo -u postgres sed -i "/shared_buffers/c\shared_buffers = 2GB" ${pg_file}
sudo -u postgres sed -i "/temp_buffers/c\temp_buffers = 256MB" ${pg_file}
sudo -u postgres sed -i "/work_mem/c\work_mem = 10MB" ${pg_file}
sudo -u postgres sed -i "/max_stack_depth/c\max_stack_depth = 5MB" ${pg_file}

sudo systemctl restart postgresql


# Add repository


# get pass

# `echo /bin/cat /home/ambagasdowa/credentials/db/postgresql/22116/pw`