{"level":"info","ts":"2026-07-17T16:03:38.745826498Z","msg":"OS distribution is supported","logger":"instance-manager","logging_pod":"keycloak-db-2","entry":{"version":"13 (trixie)","deprecatedFrom":"2028-08-09T00:00:00Z","supportedUntil":"2030-06-30T00:00:00Z"}}
{"level":"info","ts":"2026-07-17T16:03:38.745988921Z","msg":"Starting CloudNativePG Instance Manager","logger":"instance-manager","logging_pod":"keycloak-db-2","version":"1.28.4","build":{"Version":"1.28.4","Commit":"f74344b4d","Date":"2026-06-29"},"skipNameValidation":false}
{"level":"info","ts":"2026-07-17T16:03:39.078845793Z","msg":"starting tablespace manager","logger":"instance-manager","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.078939735Z","msg":"starting external server manager","logger":"instance-manager","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.078971185Z","msg":"starting controller-runtime manager","logger":"instance-manager","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.07977336Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T16:03:39.081023085Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","source":"kind source: *v1.Subscription"}
{"level":"info","ts":"2026-07-17T16:03:39.081043845Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T16:03:39.081991443Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","source":"kind source: *v1.Database"}
{"level":"info","ts":"2026-07-17T16:03:39.082469362Z","logger":"roles_reconciler","msg":"starting up the runnable","logger":"instance-manager","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.083295679Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-2","address":"localhost:8010","hasTLS":false}
{"level":"info","ts":"2026-07-17T16:03:39.083690636Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T16:03:39.083623105Z","logger":"roles_reconciler","msg":"setting up RoleSynchronizer loop","logger":"instance-manager","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.083337089Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","source":"kind source: *v1.Publication"}
{"level":"info","ts":"2026-07-17T16:03:39.083789448Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-2","address":":8000","hasTLS":true}
{"level":"info","ts":"2026-07-17T16:03:39.083793568Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-2","address":":9187","hasTLS":false}
{"level":"info","ts":"2026-07-17T16:03:39.083118405Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T16:03:39.085678894Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T16:03:39.086197844Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"}
{"level":"info","ts":"2026-07-17T16:03:39.284811242Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"}
{"level":"info","ts":"2026-07-17T16:03:39.284893224Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription"}
{"level":"info","ts":"2026-07-17T16:03:39.284926365Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1}
{"level":"info","ts":"2026-07-17T16:03:39.284975645Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","worker count":1}
{"level":"info","ts":"2026-07-17T16:03:39.286035085Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"}
{"level":"info","ts":"2026-07-17T16:03:39.286148398Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1}
{"level":"info","ts":"2026-07-17T16:03:39.286137627Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database"}
{"level":"info","ts":"2026-07-17T16:03:39.286179598Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","worker count":1}
{"level":"info","ts":"2026-07-17T16:03:39.28626373Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication"}
{"level":"info","ts":"2026-07-17T16:03:39.28630524Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","worker count":1}
{"level":"info","ts":"2026-07-17T16:03:39.288409461Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"}
{"level":"info","ts":"2026-07-17T16:03:39.288472872Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1}
{"level":"info","ts":"2026-07-17T16:03:39.297887513Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"3e0c4526-f739-42ba-b264-c5ef6819a003","logging_pod":"keycloak-db-2","filename":"/controller/certificates/server.crt","secret":"keycloak-db-server"}
{"level":"info","ts":"2026-07-17T16:03:39.300485563Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"3e0c4526-f739-42ba-b264-c5ef6819a003","logging_pod":"keycloak-db-2","filename":"/controller/certificates/server.key","secret":"keycloak-db-server"}
{"level":"info","ts":"2026-07-17T16:03:39.305182663Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"3e0c4526-f739-42ba-b264-c5ef6819a003","logging_pod":"keycloak-db-2","filename":"/controller/certificates/streaming_replica.crt","secret":"keycloak-db-replication"}
{"level":"info","ts":"2026-07-17T16:03:39.308289432Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"3e0c4526-f739-42ba-b264-c5ef6819a003","logging_pod":"keycloak-db-2","filename":"/controller/certificates/streaming_replica.key","secret":"keycloak-db-replication"}
{"level":"info","ts":"2026-07-17T16:03:39.312165986Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"3e0c4526-f739-42ba-b264-c5ef6819a003","logging_pod":"keycloak-db-2","filename":"/controller/certificates/client-ca.crt","secret":"keycloak-db-ca"}
{"level":"info","ts":"2026-07-17T16:03:39.316026261Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"3e0c4526-f739-42ba-b264-c5ef6819a003","logging_pod":"keycloak-db-2","filename":"/controller/certificates/server-ca.crt","secret":"keycloak-db-ca"}
{"level":"info","ts":"2026-07-17T16:03:39.316464629Z","msg":"Detected running images","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"3e0c4526-f739-42ba-b264-c5ef6819a003","logging_pod":"keycloak-db-2","runningImages":["harbor.atmosphere.dev/ghcr.io/cloudnative-pg/postgresql:18.4-202606221003-minimal-trixie@sha256:538f1b327b8dc7621a94aac79c9c3e5c50dfa29115a6c291e19372a5b876f415"]}
{"level":"info","ts":"2026-07-17T16:03:39.327330668Z","msg":"Updated replication settings","logging_pod":"keycloak-db-2","filename":"override.conf"}
{"level":"info","ts":"2026-07-17T16:03:39.351071132Z","msg":"Extracting pg_controldata information","logger":"instance-manager","logging_pod":"keycloak-db-2","reason":"postmaster start up"}
{"level":"info","ts":"2026-07-17T16:03:39.353042581Z","logger":"pg_controldata","msg":"pg_control version number:            1800\nCatalog version number:               202506291\nDatabase system identifier:           7663528121255915547\nDatabase cluster state:               in production\npg_control last modified:             Fri Jul 17 16:03:31 2026\nLatest checkpoint location:           0/3000080\nLatest checkpoint's REDO location:    0/3000028\nLatest checkpoint's REDO WAL file:    000000010000000000000003\nLatest checkpoint's TimeLineID:       1\nLatest checkpoint's PrevTimeLineID:   1\nLatest checkpoint's full_page_writes: on\nLatest checkpoint's NextXID:          0:759\nLatest checkpoint's NextOID:          24578\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:  759\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 16:03:29 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:            9fb1a73145a3515263e1a655591b3447e0d5edfdda71b002c671cb68bb907e42\n","pipe":"stdout","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.353958268Z","msg":"postmaster started","logger":"instance-manager","logging_pod":"keycloak-db-2","postMasterPID":33}
{"level":"info","ts":"2026-07-17T16:03:39.373791308Z","msg":"Instance is still down, will retry in 1 second","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"3e0c4526-f739-42ba-b264-c5ef6819a003","instance":"keycloak-db-2","cluster":"keycloak-db","namespace":"auth-system","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.385553283Z","logger":"postgres","msg":"2026-07-17 16:03:39.385 UTC [33] LOG:  redirecting log output to logging collector process","pipe":"stderr","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.385625636Z","logger":"postgres","msg":"2026-07-17 16:03:39.385 UTC [33] HINT:  Future log output will appear in directory \"/controller/log\".","pipe":"stderr","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.3863731Z","logger":"postgres","msg":"2026-07-17 16:03:39.385 UTC [33] LOG:  ending log output to stderr","source":"/controller/log/postgres","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.386427431Z","logger":"postgres","msg":"2026-07-17 16:03:39.385 UTC [33] HINT:  Future log output will go to log destination \"csvlog\".","source":"/controller/log/postgres","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.386598294Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.385 UTC","process_id":"33","session_id":"6a5a525b.21","session_line_num":"1","session_start_time":"2026-07-17 16:03:39 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-17T16:03:39.38694797Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.385 UTC","process_id":"33","session_id":"6a5a525b.21","session_line_num":"2","session_start_time":"2026-07-17 16:03:39 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-17T16:03:39.386976331Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.385 UTC","process_id":"33","session_id":"6a5a525b.21","session_line_num":"3","session_start_time":"2026-07-17 16:03:39 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-17T16:03:39.387000751Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.385 UTC","process_id":"33","session_id":"6a5a525b.21","session_line_num":"4","session_start_time":"2026-07-17 16:03:39 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-17T16:03:39.390795584Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.390 UTC","process_id":"33","session_id":"6a5a525b.21","session_line_num":"5","session_start_time":"2026-07-17 16:03:39 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-17T16:03:39.398070114Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.397 UTC","process_id":"40","session_id":"6a5a525b.28","session_line_num":"1","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"database system was interrupted; last known up at 2026-07-17 16:03:31 UTC","backend_type":"startup","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:03:39.541151657Z","logger":"wal-restore","msg":"Refusing to restore future timeline history file","logging_pod":"keycloak-db-2","walName":"00000002.history","fileTimeline":2,"clusterTimeline":1}
{"level":"info","ts":"2026-07-17T16:03:39.645550328Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.645 UTC","process_id":"40","session_id":"6a5a525b.28","session_line_num":"2","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"starting backup recovery with redo LSN 0/3000028, checkpoint LSN 0/3000080, on timeline ID 1","backend_type":"startup","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:03:39.739325267Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.738 UTC","user_name":"postgres","database_name":"postgres","process_id":"68","connection_from":"[local]","session_id":"6a5a525b.44","session_line_num":"1","session_start_time":"2026-07-17 16:03:39 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-17T16:03:39.739391118Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.738 UTC","user_name":"postgres","database_name":"postgres","process_id":"69","connection_from":"[local]","session_id":"6a5a525b.45","session_line_num":"1","session_start_time":"2026-07-17 16:03:39 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-17T16:03:39.739434189Z","msg":"Instance is still down, will retry in 1 second","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"96567eca-b722-4e7d-935a-00af6db3b114","instance":"keycloak-db-2","cluster":"keycloak-db","namespace":"auth-system","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:03:39.753441417Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.753 UTC","user_name":"postgres","database_name":"postgres","process_id":"70","connection_from":"[local]","session_id":"6a5a525b.46","session_line_num":"1","session_start_time":"2026-07-17 16:03:39 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-17T16:03:39.7911432Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.790 UTC","process_id":"40","session_id":"6a5a525b.28","session_line_num":"3","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"entering standby mode","backend_type":"startup","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:03:39.796121586Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.796 UTC","process_id":"40","session_id":"6a5a525b.28","session_line_num":"4","session_start_time":"2026-07-17 16:03:39 UTC","virtual_transaction_id":"193/0","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"redo starts at 0/3000028","backend_type":"startup","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:03:39.810139724Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.809 UTC","user_name":"postgres","database_name":"postgres","process_id":"81","connection_from":"[local]","session_id":"6a5a525b.51","session_line_num":"1","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"FATAL","sql_state_code":"57P03","message":"the database system is not yet accepting connections","detail":"Consistent recovery state has not been yet reached.","backend_type":"client backend","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:03:39.940350101Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.940 UTC","process_id":"40","session_id":"6a5a525b.28","session_line_num":"5","session_start_time":"2026-07-17 16:03:39 UTC","virtual_transaction_id":"193/0","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"completed backup recovery with redo LSN 0/3000028 and end LSN 0/3000120","backend_type":"startup","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:03:39.940404162Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.940 UTC","process_id":"40","session_id":"6a5a525b.28","session_line_num":"6","session_start_time":"2026-07-17 16:03:39 UTC","virtual_transaction_id":"193/0","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"consistent recovery state reached at 0/3000120","backend_type":"startup","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:03:39.940729438Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:39.940 UTC","process_id":"33","session_id":"6a5a525b.21","session_line_num":"6","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"database system is ready to accept read-only connections","backend_type":"postmaster","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:03:40.103147663Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:03:40.102 UTC","process_id":"99","session_id":"6a5a525c.63","session_line_num":"1","session_start_time":"2026-07-17 16:03:40 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"started streaming WAL from primary at 0/4000000 on timeline 1","backend_type":"walreceiver","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:04:12.040003352Z","logger":"database_reconciler","msg":"Reconciling database","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"2e161019-c12d-4617-9659-e08dc7d6bea9","databaseName":"keycloak","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:04:12.040044693Z","logger":"database_reconciler","msg":"Reconciliation loop of database exited","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"2e161019-c12d-4617-9659-e08dc7d6bea9","databaseName":"keycloak","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:04:12.052145024Z","logger":"database_reconciler","msg":"Reconciling database","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"64150b7d-9c3a-4373-abd4-6d4ac431d05b","databaseName":"keycloak","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:04:12.052176925Z","logger":"database_reconciler","msg":"Reconciliation loop of database exited","logger":"instance-manager","logging_pod":"keycloak-db-2","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"64150b7d-9c3a-4373-abd4-6d4ac431d05b","databaseName":"keycloak","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:08:39.497785516Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:08:39.497 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"1","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint starting: time","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:11:28.949766266Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:11:28.949 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"2","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint complete: wrote 1692 buffers (10.3%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=169.384 s, sync=0.058 s, total=169.452 s; sync files=758, longest=0.003 s, average=0.001 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:11:28.949856717Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:11:28.949 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"3","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"recovery restart point at 0/5000028","detail":"Last completed transaction was at log time 2026-07-17 16:08:51.674654+00.","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:13:40.01674077Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:13:40.016 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"4","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint starting: time","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:13:40.432546992Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:13:40.432 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"5","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint complete: wrote 4 buffers (0.0%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.405 s, sync=0.002 s, total=0.416 s; sync files=4, longest=0.001 s, average=0.001 s; distance=26815 kB, estimate=32172 kB; lsn=0/7000098, redo lsn=0/6A2FF08","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:13:40.432645484Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:13:40.432 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"6","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"recovery restart point at 0/6A2FF08","detail":"Last completed transaction was at log time 2026-07-17 16:08:51.674654+00.","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:18:40.528700308Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:18:40.528 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"7","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint starting: time","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:18:40.562321828Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:18:40.561 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"8","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint complete: wrote 0 buffers (0.0%), wrote 0 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.034 s; sync files=0, longest=0.000 s, average=0.000 s; distance=5961 kB, estimate=29551 kB; lsn=0/8000060, redo lsn=0/7002418","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:18:40.562479761Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:18:40.562 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"9","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"recovery restart point at 0/7002418","detail":"Last completed transaction was at log time 2026-07-17 16:08:51.674654+00.","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:43:56.67668728Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:43:56.676 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"10","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint starting: time","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:43:56.925524917Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:43:56.924 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"11","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint complete: wrote 2 buffers (0.0%), wrote 1 SLRU buffers; 1 WAL file(s) added, 0 removed, 0 recycled; write=0.202 s, sync=0.002 s, total=0.249 s; sync files=3, longest=0.001 s, average=0.001 s; distance=32775 kB, estimate=32775 kB; lsn=0/90040B8, redo lsn=0/9004060","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:43:56.925620469Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:43:56.924 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"12","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"recovery restart point at 0/9004060","detail":"Last completed transaction was at log time 2026-07-17 16:41:41.063341+00.","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:48:07.546299658Z","msg":"readiness probe using cached cluster definition due to API server connectivity issue","apiServerReachable":false,"apiServerErr":"Get \"https://10.96.0.1:443/apis/postgresql.cnpg.io/v1/namespaces/auth-system/clusters/keycloak-db\": context deadline exceeded","logging_pod":"keycloak-db-2"}
{"level":"info","ts":"2026-07-17T16:48:57.024617469Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:48:57.024 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"13","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint starting: time","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:48:57.544876743Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:48:57.544 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"14","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint complete: wrote 5 buffers (0.0%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.506 s, sync=0.002 s, total=0.521 s; sync files=5, longest=0.001 s, average=0.001 s; distance=16385 kB, estimate=31136 kB; lsn=0/B000060, redo lsn=0/A0044C0","backend_type":"checkpointer","query_id":"0"}}
{"level":"info","ts":"2026-07-17T16:48:57.544951675Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-2","record":{"log_time":"2026-07-17 16:48:57.544 UTC","process_id":"38","session_id":"6a5a525b.26","session_line_num":"15","session_start_time":"2026-07-17 16:03:39 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"recovery restart point at 0/A0044C0","detail":"Last completed transaction was at log time 2026-07-17 16:44:41.128145+00.","backend_type":"checkpointer","query_id":"0"}}