git clone https://github.com/zabbix/zabbix-docker.git
cd zabbix-docker
git checkout 6.0
git pull
git clean -fdx
git reset --hard
docker-compose -f docker-compose_v3_alpine_pgsql_latest.yaml up -d
docker exec -ti zabbix-docker-postgres-server-1 psql -U zabbix -d zabbix

zabbix=#  ALTER SYSTEM SET default_transaction_read_only TO on;
zabbix=#  SELECT pg_reload_conf();
zabbix=#  SHOW default_transaction_read_only;

docker logs -f zabbix-docker-zabbix-server-1;

WARNING:  there is no transaction in progress
   240:20240529:190500.256 database is read-only: waiting for 10 seconds
   246:20240529:190500.326 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR:  cannot execute INSERT in a read-only transaction

WARNING:  there is no transaction in progress
   246:20240529:190500.346 database is read-only: waiting for 10 seconds
   228:20240529:190500.844 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  cannot execute SELECT FOR UPDATE in a read-only transaction
 [select ha_nodeid,name,status,lastaccess,address,port,ha_sessionid from ha_node order by ha_nodeid for update]
   228:20240529:190501.845 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  cannot execute SELECT FOR UPDATE in a read-only transaction
 [select ha_nodeid,name,status,lastaccess,address,port,ha_sessionid from ha_node order by ha_nodeid for update]
   228:20240529:190502.839 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  cannot execute SELECT FOR UPDATE in a read-only transaction
 [select ha_nodeid,name,status,lastaccess,address,port,ha_sessionid from ha_node order by ha_nodeid for update]
   228:20240529:190503.835 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  cannot execute SELECT FOR UPDATE in a read-only transaction
 [select ha_nodeid,name,status,lastaccess,address,port,ha_sessionid from ha_node order by ha_nodeid for update]
   244:20240529:190504.276 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR:  cannot execute INSERT in a read-only transaction