)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":33696,"name":"Anjeev Kumar","email":"ak812x@att.com","username":"ak812x"},"change_message_id":"b0ee97374e344cbb04e965cc8ea29ee9ca536691","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":8,"id":"5003a469_fbe20646","updated":"2022-02-03 12:21:31.000000000","message":"re-check","commit_id":"412c01afa4bc9397606c67f5103ae3386bd71c4c"},{"author":{"_account_id":28719,"name":"Phil Sphicas","email":"phil.sphicas@att.com","username":"ps3910"},"change_message_id":"5740360ac4d855a85d8477b7c1a2c15e0a3e4d1b","unresolved":true,"context_lines":[],"source_content_type":"","patch_set":10,"id":"d90c353f_be4bae39","updated":"2022-02-18 17:38:56.000000000","message":"I updated my previous comment with something that seems to work.\nHowever, this change only cares for the postgres system database itself.\n\nDepending on the requirements, you may want to incorporate the changes here as well:\nhelm-toolkit/templates/scripts/_db-pg-init.sh.tpl","commit_id":"451ad4b15535c71d2f466a5ab07a30d621ef6279"},{"author":{"_account_id":28719,"name":"Phil Sphicas","email":"phil.sphicas@att.com","username":"ps3910"},"change_message_id":"5ced9a150cb56881ba13b70a76a63082ed40c18c","unresolved":true,"context_lines":[],"source_content_type":"","patch_set":10,"id":"272b34d9_867b458f","updated":"2022-02-18 17:24:14.000000000","message":"doesn\u0027t work as is, and would suggest not changing the chart default value for debug.","commit_id":"451ad4b15535c71d2f466a5ab07a30d621ef6279"},{"author":{"_account_id":33696,"name":"Anjeev Kumar","email":"ak812x@att.com","username":"ak812x"},"change_message_id":"56647052a7de850ae4aaaaab6537929c91e8f2ac","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":12,"id":"4524b64f_e6948d74","updated":"2022-02-21 14:29:24.000000000","message":"re-check","commit_id":"a963c08aa267e8463ca3ba2e21b700a66aa1db17"}],"postgresql/templates/bin/_start.sh.tpl":[{"author":{"_account_id":28719,"name":"Phil Sphicas","email":"phil.sphicas@att.com","username":"ps3910"},"change_message_id":"5ced9a150cb56881ba13b70a76a63082ed40c18c","unresolved":true,"context_lines":[{"line_number":28,"context_line":"if [[ -d \"$PGDATA\" \u0026\u0026 -s \"$PGDATA/PG_VERSION\" ]]"},{"line_number":29,"context_line":"then"},{"line_number":30,"context_line":"  postgres --single -D \"$PGDATA\" \"$POSTGRES_DB\" \u003c\u003cEOF"},{"line_number":31,"context_line":"psql -d $POSTGRES_DB -c \"CREATE EXTENSION IF NOT EXISTS pgcrypto\""},{"line_number":32,"context_line":"ALTER ROLE $POSTGRES_USER WITH PASSWORD \u0027$POSTGRES_PASSWORD\u0027"},{"line_number":33,"context_line":"EOF"},{"line_number":34,"context_line":""}],"source_content_type":"text/x-smarty","patch_set":10,"id":"dd3f3def_4d03b4a5","line":31,"range":{"start_line":31,"start_character":0,"end_line":31,"end_character":1},"updated":"2022-02-18 17:24:14.000000000","message":"this line is in the wrong place - `psql` is a standalone command, not input to the `postgres` command. (revision 8 of the patchset looked more plausible.)\n\nlogs show this error:\n\n    PostgreSQL stand-alone backend 9.6.23\n    ERROR:  syntax error at or near \"psql\" at character 1\n    STATEMENT:  psql -d postgres -c \"CREATE EXTENSION IF NOT EXISTS pgcrypto\"","commit_id":"451ad4b15535c71d2f466a5ab07a30d621ef6279"},{"author":{"_account_id":28719,"name":"Phil Sphicas","email":"phil.sphicas@att.com","username":"ps3910"},"change_message_id":"5740360ac4d855a85d8477b7c1a2c15e0a3e4d1b","unresolved":true,"context_lines":[{"line_number":28,"context_line":"if [[ -d \"$PGDATA\" \u0026\u0026 -s \"$PGDATA/PG_VERSION\" ]]"},{"line_number":29,"context_line":"then"},{"line_number":30,"context_line":"  postgres --single -D \"$PGDATA\" \"$POSTGRES_DB\" \u003c\u003cEOF"},{"line_number":31,"context_line":"psql -d $POSTGRES_DB -c \"CREATE EXTENSION IF NOT EXISTS pgcrypto\""},{"line_number":32,"context_line":"ALTER ROLE $POSTGRES_USER WITH PASSWORD \u0027$POSTGRES_PASSWORD\u0027"},{"line_number":33,"context_line":"EOF"},{"line_number":34,"context_line":""}],"source_content_type":"text/x-smarty","patch_set":10,"id":"6688a040_80deaabe","line":31,"range":{"start_line":31,"start_character":0,"end_line":31,"end_character":1},"in_reply_to":"dd3f3def_4d03b4a5","updated":"2022-02-18 17:38:56.000000000","message":"\u003e (revision 8 of the patchset looked more plausible.)\n\nactually that doesn\u0027t work either, sorry.\n\nthis version seems to be ok, but is only applicable to the main postgresql database:\n\n    if [[ -d \"$PGDATA\" \u0026\u0026 -s \"$PGDATA/PG_VERSION\" ]]\n    then\n      postgres --single -D \"$PGDATA\" \"$POSTGRES_DB\" \u003c\u003cEOF\n    ALTER ROLE $POSTGRES_USER WITH PASSWORD \u0027$POSTGRES_PASSWORD\u0027\n    CREATE EXTENSION IF NOT EXISTS pgcrypto\n    EOF","commit_id":"451ad4b15535c71d2f466a5ab07a30d621ef6279"}],"postgresql/values.yaml":[{"author":{"_account_id":28719,"name":"Phil Sphicas","email":"phil.sphicas@att.com","username":"ps3910"},"change_message_id":"5ced9a150cb56881ba13b70a76a63082ed40c18c","unresolved":true,"context_lines":[{"line_number":275,"context_line":"      - {}"},{"line_number":276,"context_line":""},{"line_number":277,"context_line":"conf:"},{"line_number":278,"context_line":"  debug: true"},{"line_number":279,"context_line":"  pg_hba: |"},{"line_number":280,"context_line":"    host all all 127.0.0.1/32 trust"},{"line_number":281,"context_line":"    host all all 0.0.0.0/0 md5"}],"source_content_type":"text/x-yaml","patch_set":10,"id":"6c6703ad_d1dfd2dd","line":278,"range":{"start_line":278,"start_character":2,"end_line":278,"end_character":13},"updated":"2022-02-18 17:24:14.000000000","message":"it may be better not to change the chart defaults.","commit_id":"451ad4b15535c71d2f466a5ab07a30d621ef6279"}]}