Resolved 500 Error with postgresql in Gitlab

Step-1:   I found This error in /var/log/gitlab/postgresql

~#  tail -f /var/log/gitlab/postgresql/current

 This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter.  You can either reduce the request size or reconfigure the kernel with larger SHMMAX.  To reduce the request size (currently 8625250304 bytes), reduce PostgreSQL's shared memory usage, perhaps by reducing shared_buffers or max_connections.

 -----------------------------------------------Solution --------------------------------

Step-2  We  changed   shared_buffers = 8019MB  to  shared_buffers = 128kB

 Go to /var/opt/gitlab/postgresql/data

 ~#:cd  /var/opt/gitlab/postgresql/data

~#:/var/opt/gitlab/postgresql/data# vi postgresql.conf

 # - Memory -

shared_buffers = 8019MB # min 128kB

          # (change requires restart)

#temp_buffers = 8MB     # min 800kB

#max_prepared_transactions = 0    # zero disables the feature

          # (change requires restart)

New Changes Below 

 # - Memory -

shared_buffers = 128kB # min 128kB

          # (change requires restart)

#temp_buffers = 8MB     # min 800kB

#max_prepared_transactions = 0    # zero disables the feature

          # (change requires restart)  

 

  

  

  

---------------------------------------  

Step-3 After that restart gitlab

  

~# gitlab-ctl restart

  

Now its working fine.

Thanks&Regards,

Bhargava Batchu.