How to set ulimit (stack size) with a larger value about postgres-operator HOT 2 CLOSED

Hi @tjmoore4
I had this error when I called a stored procedure in postgresql database

Exception caught : org.postgresql.util.PSQLException: ERROR: stack depth limit exceeded
  Hint: Increase the configuration parameter "max_stack_depth" (currently 4096kB), after ensuring the platform's stack depth limit is adequate.

I think this is due to recursive calls coded in the stored procedure.
After modifying the max_stack_depth to 7MB, we get the same error but now with "max_stack_depth" (currently 7168kB).
So I am checking if ulimit -s can be modified easily in Crunchy postgres.

I will refer to issue 2532 to build my docker image.

Thank you.

from postgres-operator.

Hi @Eric-zch. Thanks for reaching out. To help me understand your issue a bit better, are you hitting a specific problem in your environment due to the default size setting? For example, #2532 specifically deals with ulimit updates in light of core file behavior.

from postgres-operator.