{"level":"info","ts":"2026-07-17T13:14:45.725837449Z","msg":"OS distribution is supported","logger":"instance-manager","logging_pod":"keycloak-db-3","entry":{"version":"13 (trixie)","deprecatedFrom":"2028-08-09T00:00:00Z","supportedUntil":"2030-06-30T00:00:00Z"}} {"level":"info","ts":"2026-07-17T13:14:45.726173725Z","msg":"Starting CloudNativePG Instance Manager","logger":"instance-manager","logging_pod":"keycloak-db-3","version":"1.28.4","build":{"Version":"1.28.4","Commit":"f74344b4d","Date":"2026-06-29"},"skipNameValidation":false} {"level":"info","ts":"2026-07-17T13:14:46.08148193Z","msg":"starting tablespace manager","logger":"instance-manager","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.081557661Z","msg":"starting external server manager","logger":"instance-manager","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.081628852Z","msg":"starting controller-runtime manager","logger":"instance-manager","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.082712032Z","logger":"roles_reconciler","msg":"starting up the runnable","logger":"instance-manager","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.082853216Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-3","address":":8000","hasTLS":true} {"level":"info","ts":"2026-07-17T13:14:46.082943267Z","logger":"roles_reconciler","msg":"setting up RoleSynchronizer loop","logger":"instance-manager","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.082960417Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:14:46.082774863Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:14:46.083174821Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:14:46.083233892Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:14:46.083328424Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","source":"kind source: *v1.Database"} {"level":"info","ts":"2026-07-17T13:14:46.082703882Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-3","address":"localhost:8010","hasTLS":false} {"level":"info","ts":"2026-07-17T13:14:46.08308157Z","msg":"Starting webserver","logger":"instance-manager","logging_pod":"keycloak-db-3","address":":9187","hasTLS":false} {"level":"info","ts":"2026-07-17T13:14:46.083050609Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:14:46.083766192Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","source":"kind source: *v1.Publication"} {"level":"info","ts":"2026-07-17T13:14:46.083824013Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","source":"kind source: *v1.Cluster"} {"level":"info","ts":"2026-07-17T13:14:46.083953035Z","msg":"Starting EventSource","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","source":"kind source: *v1.Subscription"} {"level":"info","ts":"2026-07-17T13:14:46.285896936Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database"} {"level":"info","ts":"2026-07-17T13:14:46.285972577Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","worker count":1} {"level":"info","ts":"2026-07-17T13:14:46.285889436Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication"} {"level":"info","ts":"2026-07-17T13:14:46.286046378Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-publication","controllerGroup":"postgresql.cnpg.io","controllerKind":"Publication","worker count":1} {"level":"info","ts":"2026-07-17T13:14:46.286021168Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"} {"level":"info","ts":"2026-07-17T13:14:46.285979407Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription"} {"level":"info","ts":"2026-07-17T13:14:46.286082589Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-subscription","controllerGroup":"postgresql.cnpg.io","controllerKind":"Subscription","worker count":1} {"level":"info","ts":"2026-07-17T13:14:46.286070159Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-external-server","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1} {"level":"info","ts":"2026-07-17T13:14:46.286103309Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"} {"level":"info","ts":"2026-07-17T13:14:46.286169381Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-tablespaces","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1} {"level":"info","ts":"2026-07-17T13:14:46.285991877Z","msg":"Starting Controller","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster"} {"level":"info","ts":"2026-07-17T13:14:46.286240492Z","msg":"Starting workers","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","worker count":1} {"level":"info","ts":"2026-07-17T13:14:46.300909662Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"0949ca7a-57e1-4300-b127-49cc242e7b7a","logging_pod":"keycloak-db-3","filename":"/controller/certificates/server.crt","secret":"keycloak-db-server"} {"level":"info","ts":"2026-07-17T13:14:46.304022439Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"0949ca7a-57e1-4300-b127-49cc242e7b7a","logging_pod":"keycloak-db-3","filename":"/controller/certificates/server.key","secret":"keycloak-db-server"} {"level":"info","ts":"2026-07-17T13:14:46.309656073Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"0949ca7a-57e1-4300-b127-49cc242e7b7a","logging_pod":"keycloak-db-3","filename":"/controller/certificates/streaming_replica.crt","secret":"keycloak-db-replication"} {"level":"info","ts":"2026-07-17T13:14:46.311533238Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"0949ca7a-57e1-4300-b127-49cc242e7b7a","logging_pod":"keycloak-db-3","filename":"/controller/certificates/streaming_replica.key","secret":"keycloak-db-replication"} {"level":"info","ts":"2026-07-17T13:14:46.315917119Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"0949ca7a-57e1-4300-b127-49cc242e7b7a","logging_pod":"keycloak-db-3","filename":"/controller/certificates/client-ca.crt","secret":"keycloak-db-ca"} {"level":"info","ts":"2026-07-17T13:14:46.319599066Z","msg":"Refreshed configuration file","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"0949ca7a-57e1-4300-b127-49cc242e7b7a","logging_pod":"keycloak-db-3","filename":"/controller/certificates/server-ca.crt","secret":"keycloak-db-ca"} {"level":"info","ts":"2026-07-17T13:14:46.319745879Z","msg":"Detected running images","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"0949ca7a-57e1-4300-b127-49cc242e7b7a","logging_pod":"keycloak-db-3","runningImages":["harbor.atmosphere.dev/ghcr.io/cloudnative-pg/postgresql:18.4-202606221003-minimal-trixie@sha256:538f1b327b8dc7621a94aac79c9c3e5c50dfa29115a6c291e19372a5b876f415"]} {"level":"info","ts":"2026-07-17T13:14:46.324435546Z","msg":"Updated replication settings","logging_pod":"keycloak-db-3","filename":"override.conf"} {"level":"info","ts":"2026-07-17T13:14:46.342677282Z","msg":"Extracting pg_controldata information","logger":"instance-manager","logging_pod":"keycloak-db-3","reason":"postmaster start up"} {"level":"info","ts":"2026-07-17T13:14:46.343872204Z","logger":"pg_controldata","msg":"pg_control version number: 1800\nCatalog version number: 202506291\nDatabase system identifier: 7663484514088775704\nDatabase cluster state: in production\npg_control last modified: Fri Jul 17 13:14:39 2026\nLatest checkpoint location: 0/5000080\nLatest checkpoint's REDO location: 0/5000028\nLatest checkpoint's REDO WAL file: 000000010000000000000005\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 13:14:39 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: bbd7b869131a6ce1e5c527ad967e84cf55d81f64a3409d090b8439a1a89bbfc1\n","pipe":"stdout","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.344405814Z","msg":"postmaster started","logger":"instance-manager","logging_pod":"keycloak-db-3","postMasterPID":26} {"level":"info","ts":"2026-07-17T13:14:46.364479683Z","msg":"Instance is still down, will retry in 1 second","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"0949ca7a-57e1-4300-b127-49cc242e7b7a","instance":"keycloak-db-3","cluster":"keycloak-db","namespace":"auth-system","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.373403068Z","logger":"postgres","msg":"2026-07-17 13:14:46.373 UTC [26] LOG: redirecting log output to logging collector process","pipe":"stderr","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.373465009Z","logger":"postgres","msg":"2026-07-17 13:14:46.373 UTC [26] HINT: Future log output will appear in directory \"/controller/log\".","pipe":"stderr","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.374010199Z","logger":"postgres","msg":"2026-07-17 13:14:46.373 UTC [26] LOG: ending log output to stderr","source":"/controller/log/postgres","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.374028419Z","logger":"postgres","msg":"2026-07-17 13:14:46.373 UTC [26] HINT: Future log output will go to log destination \"csvlog\".","source":"/controller/log/postgres","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.374058259Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.373 UTC","process_id":"26","session_id":"6a5a2ac6.1a","session_line_num":"1","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.374261004Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.373 UTC","process_id":"26","session_id":"6a5a2ac6.1a","session_line_num":"2","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.374274064Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.373 UTC","process_id":"26","session_id":"6a5a2ac6.1a","session_line_num":"3","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.374283894Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.373 UTC","process_id":"26","session_id":"6a5a2ac6.1a","session_line_num":"4","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.377468893Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.377 UTC","process_id":"26","session_id":"6a5a2ac6.1a","session_line_num":"5","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.383135767Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.382 UTC","process_id":"33","session_id":"6a5a2ac6.21","session_line_num":"1","session_start_time":"2026-07-17 13:14:46 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"database system was interrupted; last known up at 2026-07-17 13:14:39 UTC","backend_type":"startup","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:14:46.47339784Z","logger":"wal-restore","msg":"Refusing to restore future timeline history file","logging_pod":"keycloak-db-3","walName":"00000002.history","fileTimeline":2,"clusterTimeline":1} {"level":"info","ts":"2026-07-17T13:14:46.577811053Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.577 UTC","process_id":"33","session_id":"6a5a2ac6.21","session_line_num":"2","session_start_time":"2026-07-17 13:14:46 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"starting backup recovery with redo LSN 0/5000028, checkpoint LSN 0/5000080, on timeline ID 1","backend_type":"startup","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:14:46.68561633Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.685 UTC","user_name":"postgres","database_name":"postgres","process_id":"54","connection_from":"[local]","session_id":"6a5a2ac6.36","session_line_num":"1","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.6861583Z","msg":"Instance is still down, will retry in 1 second","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-cluster","controllerGroup":"postgresql.cnpg.io","controllerKind":"Cluster","Cluster":{"name":"keycloak-db","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak-db","reconcileID":"a16b997f-5b68-451c-8edf-7c79e4c490e9","instance":"keycloak-db-3","cluster":"keycloak-db","namespace":"auth-system","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:46.714592383Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.714 UTC","process_id":"33","session_id":"6a5a2ac6.21","session_line_num":"3","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.71709023Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.716 UTC","user_name":"postgres","database_name":"postgres","process_id":"55","connection_from":"[local]","session_id":"6a5a2ac6.37","session_line_num":"1","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.720885069Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.720 UTC","process_id":"33","session_id":"6a5a2ac6.21","session_line_num":"4","session_start_time":"2026-07-17 13:14:46 UTC","virtual_transaction_id":"193/0","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"redo starts at 0/5000028","backend_type":"startup","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:14:46.730308004Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.730 UTC","user_name":"postgres","database_name":"postgres","process_id":"62","connection_from":"[local]","session_id":"6a5a2ac6.3e","session_line_num":"1","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.78388175Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.783 UTC","user_name":"postgres","database_name":"postgres","process_id":"68","connection_from":"[local]","session_id":"6a5a2ac6.44","session_line_num":"1","session_start_time":"2026-07-17 13:14:46 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-17T13:14:46.860267367Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.860 UTC","process_id":"33","session_id":"6a5a2ac6.21","session_line_num":"5","session_start_time":"2026-07-17 13:14:46 UTC","virtual_transaction_id":"193/0","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"completed backup recovery with redo LSN 0/5000028 and end LSN 0/5000120","backend_type":"startup","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:14:46.860326638Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.860 UTC","process_id":"33","session_id":"6a5a2ac6.21","session_line_num":"6","session_start_time":"2026-07-17 13:14:46 UTC","virtual_transaction_id":"193/0","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"consistent recovery state reached at 0/5000120","backend_type":"startup","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:14:46.860345649Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:46.860 UTC","process_id":"26","session_id":"6a5a2ac6.1a","session_line_num":"6","session_start_time":"2026-07-17 13:14:46 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-17T13:14:47.03029957Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:14:47.030 UTC","process_id":"80","session_id":"6a5a2ac7.50","session_line_num":"1","session_start_time":"2026-07-17 13:14:47 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"started streaming WAL from primary at 0/6000000 on timeline 1","backend_type":"walreceiver","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:14:56.461818254Z","logger":"database_reconciler","msg":"Reconciling database","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"10239077-6fc6-429d-8092-fd0fc193c267","databaseName":"keycloak","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:56.461912857Z","logger":"database_reconciler","msg":"Reconciliation loop of database exited","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"10239077-6fc6-429d-8092-fd0fc193c267","databaseName":"keycloak","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:56.473736481Z","logger":"database_reconciler","msg":"Reconciling database","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"021e1b7b-57c8-4e3a-b7a1-781eccc1f099","databaseName":"keycloak","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:14:56.473779922Z","logger":"database_reconciler","msg":"Reconciliation loop of database exited","logger":"instance-manager","logging_pod":"keycloak-db-3","controller":"instance-database","controllerGroup":"postgresql.cnpg.io","controllerKind":"Database","Database":{"name":"keycloak","namespace":"auth-system"},"namespace":"auth-system","name":"keycloak","reconcileID":"021e1b7b-57c8-4e3a-b7a1-781eccc1f099","databaseName":"keycloak","logging_pod":"keycloak-db-3"} {"level":"info","ts":"2026-07-17T13:22:16.598234347Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:22:16.597 UTC","process_id":"31","session_id":"6a5a2ac6.1f","session_line_num":"1","session_start_time":"2026-07-17 13:14:46 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-17T13:25:05.485784377Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:25:05.485 UTC","process_id":"31","session_id":"6a5a2ac6.1f","session_line_num":"2","session_start_time":"2026-07-17 13:14:46 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint complete: wrote 1686 buffers (10.3%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=168.846 s, sync=0.029 s, total=168.888 s; sync files=765, longest=0.002 s, average=0.001 s; distance=26859 kB, estimate=26859 kB; lsn=0/7028068, redo lsn=0/6A3AEE8","backend_type":"checkpointer","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:25:05.485831308Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:25:05.485 UTC","process_id":"31","session_id":"6a5a2ac6.1f","session_line_num":"3","session_start_time":"2026-07-17 13:14:46 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"recovery restart point at 0/6A3AEE8","detail":"Last completed transaction was at log time 2026-07-17 13:22:35.209648+00.","backend_type":"checkpointer","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:27:16.588374825Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:27:16.586 UTC","process_id":"31","session_id":"6a5a2ac6.1f","session_line_num":"4","session_start_time":"2026-07-17 13:14:46 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-17T13:27:20.116403279Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:27:20.116 UTC","process_id":"31","session_id":"6a5a2ac6.1f","session_line_num":"5","session_start_time":"2026-07-17 13:14:46 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"restartpoint complete: wrote 35 buffers (0.2%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=3.515 s, sync=0.005 s, total=3.530 s; sync files=30, longest=0.003 s, average=0.001 s; distance=6098 kB, estimate=24783 kB; lsn=0/8000060, redo lsn=0/702FA40","backend_type":"checkpointer","query_id":"0"}} {"level":"info","ts":"2026-07-17T13:27:20.11647462Z","logger":"postgres","msg":"record","logging_pod":"keycloak-db-3","record":{"log_time":"2026-07-17 13:27:20.116 UTC","process_id":"31","session_id":"6a5a2ac6.1f","session_line_num":"6","session_start_time":"2026-07-17 13:14:46 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"recovery restart point at 0/702FA40","detail":"Last completed transaction was at log time 2026-07-17 13:26:34.342319+00.","backend_type":"checkpointer","query_id":"0"}}