{"level":"info","ts":"2026-07-17T15:59:36.593548448Z","msg":"OS distribution is supported","logger":"instance-manager","logging_pod":"keycloak-db-1","entry":{"version":"13 (trixie)","deprecatedFrom":"2028-08-09T00:00:00Z","supportedUntil":"2030-06-30T00:00:00Z"}}
{"level":"info","ts":"2026-07-17T15:59:36.593726363Z","msg":"Starting CloudNativePG Instance Manager","logger":"instance-manager","logging_pod":"keycloak-db-1","version":"1.28.4","build":{"Version":"1.28.4","Commit":"f74344b4d","Date":"2026-06-29"},"skipNameValidation":false}
{"level":"info","ts":"2026-07-17T15:59:36.929437869Z","msg":"starting tablespace manager","logger":"instance-manager","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:36.929525751Z","msg":"starting external server manager","logger":"instance-manager","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:36.929557112Z","msg":"starting controller-runtime manager","logger":"instance-manager","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:36.930473828Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T15:59:36.931775164Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T15:59:36.932125654Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","source":"kind source: *v1.Database"}
{"level":"info","ts":"2026-07-17T15:59:36.932382261Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","source":"kind source: *v1.Publication"}
{"level":"info","ts":"2026-07-17T15:59:36.932526705Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-1","address":"localhost:8010","hasTLS":false}
{"level":"info","ts":"2026-07-17T15:59:36.932820723Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T15:59:36.932369211Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T15:59:36.932290249Z","logger":"roles_reconciler","msg":"starting up the runnable","logger":"instance-manager","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:36.933283627Z","logger":"roles_reconciler","msg":"setting up RoleSynchronizer loop","logger":"instance-manager","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:36.933516813Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","source":"kind source: *v1.Subscription"}
{"level":"info","ts":"2026-07-17T15:59:36.933665797Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T15:59:36.933916054Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-1","address":":9187","hasTLS":false}
{"level":"info","ts":"2026-07-17T15:59:36.934023727Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-1","address":":8000","hasTLS":true}
{"level":"info","ts":"2026-07-17T15:59:36.934310295Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T15:59:36.941437205Z","msg":"Installed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","pgdata":"/var/lib/postgresql/data/pgdata","filename":"pg_ident.conf"}
{"level":"info","ts":"2026-07-17T15:59:37.131204032Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"}
{"level":"info","ts":"2026-07-17T15:59:37.131257963Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1}
{"level":"info","ts":"2026-07-17T15:59:37.134632218Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication"}
{"level":"info","ts":"2026-07-17T15:59:37.134718791Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","worker count":1}
{"level":"info","ts":"2026-07-17T15:59:37.135216204Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription"}
{"level":"info","ts":"2026-07-17T15:59:37.135275846Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","worker count":1}
{"level":"info","ts":"2026-07-17T15:59:37.135366889Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"}
{"level":"info","ts":"2026-07-17T15:59:37.135451431Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1}
{"level":"info","ts":"2026-07-17T15:59:37.135626746Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database"}
{"level":"info","ts":"2026-07-17T15:59:37.135738629Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","worker count":1}
{"level":"info","ts":"2026-07-17T15:59:37.137618692Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"}
{"level":"info","ts":"2026-07-17T15:59:37.137656033Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1}
{"level":"info","ts":"2026-07-17T15:59:37.145243965Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","filename":"/controller/certificates/server.crt","secret":"keycloak-db-server"}
{"level":"info","ts":"2026-07-17T15:59:37.148590129Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","filename":"/controller/certificates/server.key","secret":"keycloak-db-server"}
{"level":"info","ts":"2026-07-17T15:59:37.154149784Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","filename":"/controller/certificates/streaming_replica.crt","secret":"keycloak-db-replication"}
{"level":"info","ts":"2026-07-17T15:59:37.158238628Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","filename":"/controller/certificates/streaming_replica.key","secret":"keycloak-db-replication"}
{"level":"info","ts":"2026-07-17T15:59:37.168521457Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","filename":"/controller/certificates/client-ca.crt","secret":"keycloak-db-ca"}
{"level":"info","ts":"2026-07-17T15:59:37.175527772Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","filename":"/controller/certificates/server-ca.crt","secret":"keycloak-db-ca"}
{"level":"info","ts":"2026-07-17T15:59:37.178538297Z","msg":"Installed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","pgdata":"/var/lib/postgresql/data/pgdata","filename":"pg_hba.conf"}
{"level":"info","ts":"2026-07-17T15:59:37.178603368Z","msg":"Detected running images","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","runningImages":["harbor.atmosphere.dev/ghcr.io/cloudnative-pg/postgresql:18.4-202606221003-minimal-trixie@sha256:538f1b327b8dc7621a94aac79c9c3e5c50dfa29115a6c291e19372a5b876f415"]}
{"level":"info","ts":"2026-07-17T15:59:37.185937863Z","msg":"Installed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","pgdata":"/var/lib/postgresql/data/pgdata","filename":"custom.conf"}
{"level":"info","ts":"2026-07-17T15:59:37.186545731Z","msg":"Cluster status","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","currentPrimary":"","targetPrimary":"keycloak-db-1","isReplicaCluster":false}
{"level":"info","ts":"2026-07-17T15:59:37.186575532Z","msg":"First primary instance bootstrap, marking myself as primary","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","logging_pod":"keycloak-db-1","currentPrimary":"","targetPrimary":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:37.223581367Z","msg":"Extracting pg_controldata information","logger":"instance-manager","logging_pod":"keycloak-db-1","reason":"postmaster start up"}
{"level":"info","ts":"2026-07-17T15:59:37.225710647Z","logger":"pg_controldata","msg":"pg_control version number:            1800\nCatalog version number:               202506291\nDatabase system identifier:           7663527184128172057\nDatabase cluster state:               shut down\npg_control last modified:             Fri Jul 17 15:59:28 2026\nLatest checkpoint location:           0/2000028\nLatest checkpoint's REDO location:    0/2000028\nLatest checkpoint's REDO WAL file:    000000010000000000000002\nLatest checkpoint's TimeLineID:       1\nLatest checkpoint's PrevTimeLineID:   1\nLatest checkpoint's full_page_writes: on\nLatest checkpoint's NextXID:          0:754\nLatest checkpoint's NextOID:          16386\nLatest checkpoint's NextMultiXactId:  1\nLatest checkpoint's NextMultiOffset:  0\nLatest checkpoint's oldestXID:        744\nLatest checkpoint's oldestXID's DB:   1\nLatest checkpoint's oldestActiveXID:  0\nLatest checkpoint's oldestMultiXid:   1\nLatest checkpoint's oldestMulti's DB: 1\nLatest checkpoint's oldestCommitTsXid:0\nLatest checkpoint's newestCommitTsXid:0\nTime of latest checkpoint:            Fri Jul 17 15:59:28 2026\nFake LSN counter for unlogged rels:   0/3E8\nMinimum recovery ending location:     0/0\nMin recovery ending loc's timeline:   0\nBackup start location:                0/0\nBackup end location:                  0/0\nEnd-of-backup record required:        no\nwal_level setting:                    logical\nwal_log_hints setting:                on\nmax_connections setting:              100\nmax_worker_processes setting:         60\nmax_wal_senders setting:              10\nmax_prepared_xacts setting:           0\nmax_locks_per_xact setting:           64\ntrack_commit_timestamp setting:       off\nMaximum data alignment:               8\nDatabase block size:                  8192\nBlocks per segment of large relation: 131072\nWAL block size:                       8192\nBytes per WAL segment:                16777216\nMaximum length of identifiers:        64\nMaximum columns in an index:          32\nMaximum size of a TOAST chunk:        1996\nSize of a large-object chunk:         2048\nDate/time type storage:               64-bit integers\nFloat8 argument passing:              by value\nData page checksum version:           1\nDefault char data signedness:         signed\nMock authentication nonce:            c9c123fb1cf521fb0a4d7e1e3fea63d294287a56ff87f7c4dd9602c1b3e9be0c\n","pipe":"stdout","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:37.226841588Z","msg":"postmaster started","logger":"instance-manager","logging_pod":"keycloak-db-1","postMasterPID":27}
{"level":"info","ts":"2026-07-17T15:59:37.227191808Z","msg":"DB not available, will retry","logger":"instance-manager","logging_pod":"keycloak-db-1","err":"failed to connect to `user=postgres database=postgres`: /controller/run/.s.PGSQL.5432 (/controller/run): dial error: dial unix /controller/run/.s.PGSQL.5432: connect: no such file or directory"}
{"level":"info","ts":"2026-07-17T15:59:37.238410852Z","msg":"Instance is still down, will retry in 1 second","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"bd0e0b79-731c-4c10-b01d-797423b5c3b0","instance":"keycloak-db-1","cluster":"keycloak-db","namespace":"auth-system","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:37.272141865Z","logger":"postgres","msg":"2026-07-17 15:59:37.272 UTC [27] LOG:  redirecting log output to logging collector process","pipe":"stderr","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:37.272192107Z","logger":"postgres","msg":"2026-07-17 15:59:37.272 UTC [27] HINT:  Future log output will appear in directory \"/controller/log\".","pipe":"stderr","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:37.273523864Z","logger":"postgres","msg":"2026-07-17 15:59:37.272 UTC [27] LOG:  ending log output to stderr","source":"/controller/log/postgres","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:37.273621137Z","logger":"postgres","msg":"2026-07-17 15:59:37.272 UTC [27] HINT:  Future log output will go to log destination \"csvlog\".","source":"/controller/log/postgres","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:37.27445125Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:37.272 UTC","process_id":"27","session_id":"6a5a5169.1b","session_line_num":"1","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"ending log output to stderr","hint":"Future log output will go to log destination \"csvlog\".","backend_type":"postmaster","query_id":"0"}}
{"level":"info","ts":"2026-07-17T15:59:37.274621125Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:37.272 UTC","process_id":"27","session_id":"6a5a5169.1b","session_line_num":"2","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"starting PostgreSQL 18.4 (Debian 18.4-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit","backend_type":"postmaster","query_id":"0"}}
{"level":"info","ts":"2026-07-17T15:59:37.274634496Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:37.272 UTC","process_id":"27","session_id":"6a5a5169.1b","session_line_num":"3","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"listening on IPv4 address \"0.0.0.0\", port 5432","backend_type":"postmaster","query_id":"0"}}
{"level":"info","ts":"2026-07-17T15:59:37.274644356Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:37.272 UTC","process_id":"27","session_id":"6a5a5169.1b","session_line_num":"4","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"listening on IPv6 address \"::\", port 5432","backend_type":"postmaster","query_id":"0"}}
{"level":"info","ts":"2026-07-17T15:59:37.277930568Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:37.277 UTC","process_id":"27","session_id":"6a5a5169.1b","session_line_num":"5","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"listening on Unix socket \"/controller/run/.s.PGSQL.5432\"","backend_type":"postmaster","query_id":"0"}}
{"level":"info","ts":"2026-07-17T15:59:37.290276023Z","msg":"Instance is still down, will retry in 1 second","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"e4a82c47-3477-49bf-a494-6bf0ab899009","instance":"keycloak-db-1","cluster":"keycloak-db","namespace":"auth-system","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T15:59:37.292389532Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:37.288 UTC","process_id":"35","session_id":"6a5a5169.23","session_line_num":"1","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"database system was shut down at 2026-07-17 15:59:28 UTC","backend_type":"startup","query_id":"0"}}
{"level":"info","ts":"2026-07-17T15:59:37.292423543Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:37.289 UTC","user_name":"postgres","database_name":"postgres","process_id":"36","connection_from":"[local]","session_id":"6a5a5169.24","session_line_num":"1","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"FATAL","sql_state_code":"57P03","message":"the database system is starting up","backend_type":"client backend","query_id":"0"}}
{"level":"info","ts":"2026-07-17T15:59:37.32164535Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:37.321 UTC","process_id":"27","session_id":"6a5a5169.1b","session_line_num":"6","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"database system is ready to accept connections","backend_type":"postmaster","query_id":"0"}}
{"level":"info","ts":"2026-07-17T15:59:37.640019528Z","msg":"Triggered a managed role reconciliation","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"643ca666-3e37-4bcf-97da-bc6e1fae4c77","logging_pod":"keycloak-db-1","pending-roles":["keycloak"]}
{"level":"info","ts":"2026-07-17T15:59:51.671582849Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:51.671 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"1","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: force wait","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T15:59:53.841312148Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 15:59:53.841 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"2","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint complete: wrote 21 buffers (0.1%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=2.110 s, sync=0.043 s, total=2.170 s; sync files=21, longest=0.019 s, average=0.003 s; distance=16384 kB, estimate=16384 kB; lsn=0/30000B8, redo lsn=0/3000028","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:00:16.888399742Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:00:16.888 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"3","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: force wait","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:00:17.231333324Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:00:17.230 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"4","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint complete: wrote 0 buffers (0.0%), wrote 0 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.024 s, sync=0.001 s, total=0.342 s; sync files=0, longest=0.000 s, average=0.000 s; distance=32768 kB, estimate=32768 kB; lsn=0/5000080, redo lsn=0/5000028","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:00:35.078343749Z","logger":"database_reconciler","msg":"Reconciling database","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"cda0785f-b146-4f65-a8b8-3d3be81e1157","databaseName":"keycloak","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T16:00:35.188603881Z","logger":"database_reconciler","msg":"Reconciliation loop of database exited","logger":"instance-manager","logging_pod":"keycloak-db-1","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"cda0785f-b146-4f65-a8b8-3d3be81e1157","databaseName":"keycloak","logging_pod":"keycloak-db-1"}
{"level":"info","ts":"2026-07-17T16:01:36.011981736Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:01:36.011 UTC","user_name":"keycloak","database_name":"keycloak","process_id":"765","connection_from":"10.0.0.172:41412","session_id":"6a5a51de.2fd","session_line_num":"1","command_tag":"PARSE","session_start_time":"2026-07-17 16:01:34 UTC","virtual_transaction_id":"92/23","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42P01","message":"relation \"public.migration_model\" does not exist","query":"SELECT ID, VERSION FROM public.MIGRATION_MODEL ORDER BY UPDATE_TIME DESC","query_pos":"25","application_name":"PostgreSQL JDBC Driver","backend_type":"client backend","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:01:36.839466692Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:01:36.837 UTC","user_name":"keycloak","database_name":"keycloak","process_id":"765","connection_from":"10.0.0.172:41412","session_id":"6a5a51de.2fd","session_line_num":"2","command_tag":"PARSE","session_start_time":"2026-07-17 16:01:34 UTC","virtual_transaction_id":"92/24","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42P01","message":"relation \"public.databasechangelog\" does not exist","query":"SELECT COUNT(*) FROM public.databasechangelog","query_pos":"22","application_name":"PostgreSQL JDBC Driver","backend_type":"client backend","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:01:37.040912185Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:01:37.040 UTC","user_name":"keycloak","database_name":"keycloak","process_id":"766","connection_from":"10.0.0.172:41416","session_id":"6a5a51e0.2fe","session_line_num":"1","command_tag":"PARSE","session_start_time":"2026-07-17 16:01:36 UTC","virtual_transaction_id":"93/20","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42P01","message":"relation \"public.databasechangeloglock\" does not exist","query":"SELECT COUNT(*) FROM public.databasechangeloglock","query_pos":"22","application_name":"PostgreSQL JDBC Driver","backend_type":"client backend","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:01:37.083498103Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:01:37.081 UTC","user_name":"keycloak","database_name":"keycloak","process_id":"765","connection_from":"10.0.0.172:41412","session_id":"6a5a51de.2fd","session_line_num":"3","command_tag":"PARSE","session_start_time":"2026-07-17 16:01:34 UTC","virtual_transaction_id":"92/26","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42P01","message":"relation \"public.databasechangelog\" does not exist","query":"SELECT COUNT(*) FROM public.databasechangelog","query_pos":"22","application_name":"PostgreSQL JDBC Driver","backend_type":"client backend","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:05:16.363894967Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:05:16.363 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"5","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: time","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:07:44.780570104Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:07:44.780 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"6","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint complete: wrote 1478 buffers (9.0%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=148.353 s, sync=0.051 s, total=148.417 s; sync files=882, longest=0.005 s, average=0.001 s; distance=26789 kB, estimate=32170 kB; lsn=0/7035C98, redo lsn=0/6A296D0","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:10:16.879958511Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:10:16.879 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"7","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: time","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:10:23.618183837Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:10:23.616 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"8","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint complete: wrote 63 buffers (0.4%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=6.704 s, sync=0.014 s, total=6.738 s; sync files=52, longest=0.010 s, average=0.001 s; distance=6247 kB, estimate=29577 kB; lsn=0/8000098, redo lsn=0/7043638","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:15:16.71303649Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:15:16.712 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"9","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: time","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:15:21.750031838Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-1","record":{"log_time":"2026-07-17 16:15:21.749 UTC","process_id":"33","session_id":"6a5a5169.21","session_line_num":"10","session_start_time":"2026-07-17 15:59:37 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint complete: wrote 47 buffers (0.3%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=5.014 s, sync=0.008 s, total=5.038 s; sync files=40, longest=0.004 s, average=0.001 s; distance=16238 kB, estimate=28244 kB; lsn=0/9000098, redo lsn=0/801F190","backend_type":"checkpointer","query_id":"0"}}