2026-03-19 05:20:01.163 CET [3248] LOG:  checkpoint starting: time
2026-03-19 05:20:01.910 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.665 s, sync=0.020 s, total=0.747 s; sync files=5, longest=0.008 s, average=0.004 s; distance=24 kB, estimate=363 kB; lsn=19/6BD99BA8, redo lsn=19/6BD99B50
2026-03-19 05:25:01.893 CET [3248] LOG:  checkpoint starting: time
2026-03-19 05:25:02.956 CET [3248] LOG:  checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.995 s, sync=0.033 s, total=1.063 s; sync files=5, longest=0.011 s, average=0.007 s; distance=33 kB, estimate=330 kB; lsn=19/6BDA1FB0, redo lsn=19/6BDA1F58
2026-03-19 05:40:01.973 CET [3248] LOG:  checkpoint starting: time
2026-03-19 05:40:02.342 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.322 s, sync=0.015 s, total=0.370 s; sync files=4, longest=0.006 s, average=0.004 s; distance=14 kB, estimate=298 kB; lsn=19/6BDA59E0, redo lsn=19/6BDA5988
2026-03-19 05:45:01.340 CET [3248] LOG:  checkpoint starting: time
2026-03-19 05:45:02.068 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.653 s, sync=0.033 s, total=0.729 s; sync files=5, longest=0.015 s, average=0.007 s; distance=26 kB, estimate=271 kB; lsn=19/6BDAC1E8, redo lsn=19/6BDAC190
2026-03-19 05:50:01.059 CET [3248] LOG:  checkpoint starting: time
2026-03-19 05:50:01.774 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.655 s, sync=0.016 s, total=0.715 s; sync files=4, longest=0.005 s, average=0.004 s; distance=31 kB, estimate=247 kB; lsn=19/6BDB41D8, redo lsn=19/6BDB4180
2026-03-19 05:55:01.777 CET [3248] LOG:  checkpoint starting: time
2026-03-19 05:55:03.041 CET [3248] LOG:  checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.205 s, sync=0.020 s, total=1.265 s; sync files=5, longest=0.006 s, average=0.004 s; distance=56 kB, estimate=228 kB; lsn=19/6BDC22A8, redo lsn=19/6BDC2250
2026-03-19 06:00:01.044 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:00:06.825 CET [3248] LOG:  checkpoint complete: wrote 53 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.674 s, sync=0.054 s, total=5.781 s; sync files=13, longest=0.006 s, average=0.005 s; distance=295 kB, estimate=295 kB; lsn=19/6BE0C060, redo lsn=19/6BE0BFF0
2026-03-19 06:05:01.833 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:05:02.562 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.660 s, sync=0.024 s, total=0.729 s; sync files=5, longest=0.008 s, average=0.005 s; distance=43 kB, estimate=270 kB; lsn=19/6BE16F10, redo lsn=19/6BE16EB8
2026-03-19 06:10:01.565 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:10:02.405 CET [3248] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.766 s, sync=0.029 s, total=0.841 s; sync files=5, longest=0.009 s, average=0.006 s; distance=42 kB, estimate=247 kB; lsn=19/6BE21A70, redo lsn=19/6BE21A18
2026-03-19 06:15:01.401 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:15:02.133 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.662 s, sync=0.028 s, total=0.733 s; sync files=5, longest=0.012 s, average=0.006 s; distance=46 kB, estimate=227 kB; lsn=19/6BE2D660, redo lsn=19/6BE2D608
2026-03-19 06:20:01.127 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:20:01.958 CET [3248] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.761 s, sync=0.024 s, total=0.831 s; sync files=5, longest=0.007 s, average=0.005 s; distance=43 kB, estimate=209 kB; lsn=19/6BE38488, redo lsn=19/6BE38430
2026-03-19 06:24:07.224 CET [3744] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 06:24:07.224 CET [3744] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 06:24:07.638 CET [6364] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 06:24:07.638 CET [6364] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 06:25:01.954 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:25:02.570 CET [3248] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.550 s, sync=0.024 s, total=0.617 s; sync files=4, longest=0.010 s, average=0.006 s; distance=38 kB, estimate=192 kB; lsn=19/6BE41F80, redo lsn=19/6BE41F28
2026-03-19 06:37:14.460 CET [6480] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 06:37:14.460 CET [6480] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 06:39:29.528 CET [4188] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 06:39:29.528 CET [4188] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 06:40:01.568 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:40:02.771 CET [3248] LOG:  checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.092 s, sync=0.067 s, total=1.204 s; sync files=10, longest=0.014 s, average=0.007 s; distance=44 kB, estimate=177 kB; lsn=19/6BE4D1D8, redo lsn=19/6BE4D180
2026-03-19 06:41:40.364 CET [4188] ERROR:  function sonex.system_logs_add(actor_permission => text, category => unknown, action => unknown, entity_type => unknown, entity_key => text, details => jsonb) does not exist at character 8
2026-03-19 06:41:40.364 CET [4188] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2026-03-19 06:41:40.364 CET [4188] QUERY:  SELECT sonex.system_logs_add(
	        actor_permission := v_permission_constant,
	        category         := 'groups',
	        action           := 'rename',
	        entity_type      := 'group',
	        entity_key       := v_group_name_new,
	        details          := jsonb_build_object(
	            'group_name_old', v_group_name_old,
	            'group_name_new', v_group_name_new
	        )
	    )
2026-03-19 06:41:40.364 CET [4188] CONTEXT:  PL/pgSQL function administrator_groups_rename(text,text) line 80 at PERFORM
2026-03-19 06:41:40.364 CET [4188] STATEMENT:  SELECT sonex.administrator_groups_rename(
	    'group_accounts_administrator',
	    'group_accounts_admin'
	);
	
2026-03-19 06:43:54.725 CET [4188] ERROR:  Old and new group names are the same: group_accounts_administrator
2026-03-19 06:43:54.725 CET [4188] CONTEXT:  PL/pgSQL function administrator_groups_rename(text,text) line 37 at RAISE
2026-03-19 06:43:54.725 CET [4188] STATEMENT:  SELECT sonex.administrator_groups_rename(
	    'group_accounts_administrator',
	    'group_accounts_administrator'
	);
	
2026-03-19 06:45:01.755 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:45:06.406 CET [3248] LOG:  checkpoint complete: wrote 42 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.483 s, sync=0.127 s, total=4.652 s; sync files=32, longest=0.009 s, average=0.004 s; distance=160 kB, estimate=175 kB; lsn=19/6BE752D8, redo lsn=19/6BE75280
2026-03-19 06:45:09.021 CET [6480] ERROR:  cannot change return type of existing function
2026-03-19 06:45:09.021 CET [6480] HINT:  Use DROP FUNCTION sonex.administrator_groups_rename(text,text) first.
2026-03-19 06:45:09.021 CET [6480] STATEMENT:  CREATE OR REPLACE FUNCTION sonex.administrator_groups_rename(
	    p_group_name_old text,
	    p_group_name_new text
	)
	RETURNS boolean
	LANGUAGE plpgsql
	SECURITY DEFINER
	SET search_path = sonex, pg_temp
	AS $BODY$
	DECLARE
	    v_permission_constant constant text := 'permission_administrator_groups_edit';
	    v_group_name_old text;
	    v_group_name_new text;
	    v_exists boolean;
	BEGIN
	    IF NOT pg_has_role(CURRENT_USER, v_permission_constant, 'MEMBER') THEN
	        RAISE EXCEPTION 'Missing required permission: %', v_permission_constant;
	    END IF;
	
	    p_group_name_old := btrim(coalesce(p_group_name_old, ''));
	    p_group_name_new := btrim(coalesce(p_group_name_new, ''));
	
	    IF p_group_name_old = '' THEN
	        RAISE EXCEPTION 'Old group name cannot be empty';
	    END IF;
	
	    IF p_group_name_new = '' THEN
	        RAISE EXCEPTION 'New group name cannot be empty';
	    END IF;
	
	    v_group_name_old :=
	        CASE
	            WHEN p_group_name_old LIKE 'group\_%' ESCAPE '\' THEN p_group_name_old
	            ELSE 'group_' || p_group_name_old
	        END;
	
	    v_group_name_new :=
	        CASE
	            WHEN p_group_name_new LIKE 'group\_%' ESCAPE '\' THEN p_group_name_new
	            ELSE 'group_' || p_group_name_new
	        END;
	
	    IF v_group_name_old !~ '^group_[a-z][a-z0-9_]{0,57}$' THEN
	        RAISE EXCEPTION 'Invalid old group role name "%"', v_group_name_old;
	    END IF;
	
	    IF v_group_name_new !~ '^group_[a-z][a-z0-9_]{0,57}$' THEN
	        RAISE EXCEPTION 'Invalid new group role name "%"', v_group_name_new;
	    END IF;
	
	    IF v_group_name_old = v_group_name_new THEN
	        RAISE EXCEPTION 'Old and new group names are the same: "%"', v_group_name_old;
	    END IF;
	
	    SELECT EXISTS (
	        SELECT 1
	        FROM pg_catalog.pg_roles
	        WHERE rolname = v_group_name_old
	    )
	    INTO v_exists;
	
	    IF NOT v_exists THEN
	        RAISE EXCEPTION 'Group "%" does not exist', v_group_name_old;
	    END IF;
	
	    SELECT EXISTS (
	        SELECT 1
	        FROM pg_catalog.pg_roles
	        WHERE rolname = v_group_name_new
	    )
	    INTO v_exists;
	
	    IF v_exists THEN
	        RAISE EXCEPTION 'Target group name already exists: "%"', v_group_name_new;
	    END IF;
	
	    EXECUTE format(
	        'ALTER ROLE %I RENAME TO %I',
	        v_group_name_old,
	        v_group_name_new
	    );
	
	    PERFORM sonex.system_logs_add(
	        'groups',
	        'rename',
	        'group',
	        NULL,
	        v_group_name_new,
	        jsonb_build_object(
	            'group_name_old', v_group_name_old,
	            'group_name_new', v_group_name_new
	        ),
	        'info',
	        v_permission_constant
	    );
	
	    RETURN true;
	END;
	$BODY$;
	
	ALTER FUNCTION sonex.administrator_groups_rename(text, text)
	    OWNER TO postgres;
	
	GRANT EXECUTE ON FUNCTION sonex.administrator_groups_rename(text, text) TO permission_administrator_groups_edit;
	GRANT EXECUTE ON FUNCTION sonex.administrator_groups_rename(text, text) TO postgres;
	
	REVOKE ALL ON FUNCTION sonex.administrator_groups_rename(text, text) FROM PUBLIC;
2026-03-19 06:45:58.278 CET [4188] ERROR:  Group "group_accounts_admin" does not exist
2026-03-19 06:45:58.278 CET [4188] CONTEXT:  PL/pgSQL function administrator_groups_rename(text,text) line 55 at RAISE
2026-03-19 06:45:58.278 CET [4188] STATEMENT:  SELECT sonex.administrator_groups_rename(
	    'group_accounts_admin',
	    'group_accounts_administrator'
	);
	
2026-03-19 06:46:13.160 CET [4188] ERROR:  Old and new group names are the same: "group_accounts_administratora"
2026-03-19 06:46:13.160 CET [4188] CONTEXT:  PL/pgSQL function administrator_groups_rename(text,text) line 44 at RAISE
2026-03-19 06:46:13.160 CET [4188] STATEMENT:  SELECT sonex.administrator_groups_rename(
	    'group_accounts_administratora',
	    'group_accounts_administratora'
	);
	
2026-03-19 06:46:27.033 CET [4188] ERROR:  Invalid new group role name "group_accounts_administrator$"
2026-03-19 06:46:27.033 CET [4188] CONTEXT:  PL/pgSQL function administrator_groups_rename(text,text) line 40 at RAISE
2026-03-19 06:46:27.033 CET [4188] STATEMENT:  SELECT sonex.administrator_groups_rename(
	    'group_accounts_administrator',
	    'group_accounts_administrator$'
	);
	
2026-03-19 06:46:39.109 CET [4188] ERROR:  Old and new group names are the same: "group_accounts_administrator"
2026-03-19 06:46:39.109 CET [4188] CONTEXT:  PL/pgSQL function administrator_groups_rename(text,text) line 44 at RAISE
2026-03-19 06:46:39.109 CET [4188] STATEMENT:  SELECT sonex.administrator_groups_rename(
	    'group_accounts_administrator',
	    'group_accounts_administrator'
	);
	
2026-03-19 06:46:46.255 CET [4188] ERROR:  Group "group_accounts_administratora" does not exist
2026-03-19 06:46:46.255 CET [4188] CONTEXT:  PL/pgSQL function administrator_groups_rename(text,text) line 55 at RAISE
2026-03-19 06:46:46.255 CET [4188] STATEMENT:  SELECT sonex.administrator_groups_rename(
	    'group_accounts_administratora',
	    'group_accounts_administrator'
	);
	
2026-03-19 06:50:01.406 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:50:04.623 CET [3248] LOG:  checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.064 s, sync=0.105 s, total=3.218 s; sync files=25, longest=0.013 s, average=0.005 s; distance=103 kB, estimate=168 kB; lsn=19/6BE8F250, redo lsn=19/6BE8F1F8
2026-03-19 06:53:00.146 CET [5596] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 06:53:00.146 CET [5596] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 06:55:01.633 CET [3248] LOG:  checkpoint starting: time
2026-03-19 06:55:02.026 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.330 s, sync=0.022 s, total=0.393 s; sync files=4, longest=0.007 s, average=0.006 s; distance=14 kB, estimate=153 kB; lsn=19/6BE92D28, redo lsn=19/6BE92CD0
2026-03-19 07:00:01.029 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:00:06.575 CET [3248] LOG:  checkpoint complete: wrote 50 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.360 s, sync=0.142 s, total=5.547 s; sync files=36, longest=0.009 s, average=0.004 s; distance=206 kB, estimate=206 kB; lsn=19/6BEC6630, redo lsn=19/6BEC65D8
2026-03-19 07:03:40.677 CET [4188] ERROR:  cannot drop columns from view
2026-03-19 07:03:40.677 CET [4188] STATEMENT:  -- VIEW: sonex.accounts_with_groups_v
	
	-- DROP VIEW IF EXISTS sonex.accounts_with_groups_v;
	
	CREATE OR REPLACE VIEW sonex.accounts_with_groups_v
	AS
	WITH base_accounts AS (
	    SELECT
	        r.oid AS account_role_oid,
	        r.rolname AS account_name,
	        r.rolcanlogin AS is_enabled
	    FROM pg_catalog.pg_roles r
	    INNER JOIN pg_catalog.pg_auth_members m
	        ON m.member = r.oid
	    INNER JOIN pg_catalog.pg_roles parent_role
	        ON parent_role.oid = m.roleid
	    WHERE parent_role.rolname = 'account'
	),
	account_groups AS (
	    SELECT
	        m.member AS account_role_oid,
	        array_agg(grp.rolname ORDER BY grp.rolname) AS groups
	    FROM pg_catalog.pg_auth_members m
	    INNER JOIN pg_catalog.pg_roles grp
	        ON grp.oid = m.roleid
	    WHERE grp.rolname LIKE 'group\_%' ESCAPE '\'
	    GROUP BY m.member
	),
	direct_permissions AS (
	    SELECT
	        m.member AS account_role_oid,
	        array_agg(p.rolname ORDER BY p.rolname) AS permissions_direct
	    FROM pg_catalog.pg_auth_members m
	    INNER JOIN pg_catalog.pg_roles p
	        ON p.oid = m.roleid
	    WHERE p.rolname LIKE 'permission\_%' ESCAPE '\'
	    GROUP BY m.member
	),
	group_permissions_raw AS (
	    SELECT
	        account_members.member AS account_role_oid,
	        permission_role.rolname AS permission_name
	    FROM pg_catalog.pg_auth_members account_members
	    INNER JOIN pg_catalog.pg_roles group_role
	        ON group_role.oid = account_members.roleid
	    INNER JOIN pg_catalog.pg_auth_members group_members
	        ON group_members.member = group_role.oid
	    INNER JOIN pg_catalog.pg_roles permission_role
	        ON permission_role.oid = group_members.roleid
	    WHERE group_role.rolname LIKE 'group\_%' ESCAPE '\'
	      AND permission_role.rolname LIKE 'permission\_%' ESCAPE '\'
	),
	all_permissions AS (
	    SELECT
	        b.account_role_oid,
	        array_agg(p.permission_name ORDER BY p.permission_name) AS permissions_all
	    FROM base_accounts b
	    LEFT JOIN (
	        SELECT
	            d.account_role_oid,
	            unnest(d.permissions_direct) AS permission_name
	        FROM direct_permissions d
	
	        UNION
	
	        SELECT DISTINCT
	            g.account_role_oid,
	            g.permission_name
	        FROM group_permissions_raw g
	    ) p
	        ON p.account_role_oid = b.account_role_oid
	    GROUP BY b.account_role_oid
	)
	SELECT
	    a.id,
	    b.account_name,
	    a.first_name,
	    a.last_name,
	    a.initials,
	    a.email,
	    a.phone_number,
	    a.department,
	    a.job_title,
	    a.native_language,
	    a.other_languages,
	    a.account_locus_wms,
	    a.account_locus_terminal,
	    a.account_orp,
	    a.account_bk,
	    a.account_dpd,
	    a.account_xenos,
	    a.tags,
	    a.notes,
	    a.created_at,
	    a.updated_at,
	    b.is_enabled,
	    coalesce(g.groups, '{}'::text[]) AS groups,
	    coalesce(dp.permissions_direct, '{}'::text[]) AS permissions_direct,
	    coalesce(ap.permissions_all, '{}'::text[]) AS permissions_all
	FROM base_accounts b
	LEFT JOIN sonex.accounts a
	    ON a.account_name = b.account_name
	LEFT JOIN account_groups g
	    ON g.account_role_oid = b.account_role_oid
	LEFT JOIN direct_permissions dp
	    ON dp.account_role_oid = b.account_role_oid
	LEFT JOIN all_permissions ap
	    ON ap.account_role_oid = b.account_role_oid;
2026-03-19 07:05:01.575 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:05:06.595 CET [3248] LOG:  checkpoint complete: wrote 45 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.858 s, sync=0.117 s, total=5.021 s; sync files=30, longest=0.010 s, average=0.004 s; distance=223 kB, estimate=223 kB; lsn=19/6BEFE560, redo lsn=19/6BEFE508
2026-03-19 07:08:03.063 CET [5596] ERROR:  Account "samuel" does not exist
2026-03-19 07:08:03.063 CET [5596] CONTEXT:  PL/pgSQL function administrator_accounts_access_add(text,text) line 59 at RAISE
2026-03-19 07:08:03.063 CET [5596] STATEMENT:  SELECT sonex.administrator_accounts_access_add(
	    'samuel',
	    'group_accounts_administrator'
	);
2026-03-19 07:08:09.224 CET [5596] ERROR:  Account "sje" already has access role "group_accounts_administrator"
2026-03-19 07:08:09.224 CET [5596] CONTEXT:  PL/pgSQL function administrator_accounts_access_add(text,text) line 82 at RAISE
2026-03-19 07:08:09.224 CET [5596] STATEMENT:  SELECT sonex.administrator_accounts_access_add(
	    'sje',
	    'group_accounts_administrator'
	);
2026-03-19 07:08:28.624 CET [5596] ERROR:  Account "sje" already has access role "group_groups_administrator"
2026-03-19 07:08:28.624 CET [5596] CONTEXT:  PL/pgSQL function administrator_accounts_access_add(text,text) line 82 at RAISE
2026-03-19 07:08:28.624 CET [5596] STATEMENT:  SELECT sonex.administrator_accounts_access_add(
	    'sje',
	    'group_groups_administrator'
	);
2026-03-19 07:10:01.600 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:10:05.500 CET [3248] LOG:  checkpoint complete: wrote 35 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.725 s, sync=0.110 s, total=3.901 s; sync files=28, longest=0.009 s, average=0.004 s; distance=98 kB, estimate=211 kB; lsn=19/6BF16FE0, redo lsn=19/6BF16F88
2026-03-19 07:20:01.509 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:20:02.576 CET [3248] LOG:  checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.986 s, sync=0.037 s, total=1.067 s; sync files=5, longest=0.010 s, average=0.008 s; distance=60 kB, estimate=196 kB; lsn=19/6BF26340, redo lsn=19/6BF262E8
2026-03-19 07:25:01.568 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:25:02.283 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.655 s, sync=0.017 s, total=0.716 s; sync files=4, longest=0.007 s, average=0.005 s; distance=38 kB, estimate=180 kB; lsn=19/6BF2FCB0, redo lsn=19/6BF2FC58
2026-03-19 07:30:01.282 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:30:01.655 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.314 s, sync=0.020 s, total=0.374 s; sync files=4, longest=0.009 s, average=0.005 s; distance=16 kB, estimate=164 kB; lsn=19/6BF33EB8, redo lsn=19/6BF33E60
2026-03-19 07:35:01.666 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:35:02.061 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.329 s, sync=0.020 s, total=0.395 s; sync files=4, longest=0.008 s, average=0.005 s; distance=23 kB, estimate=150 kB; lsn=19/6BF39D10, redo lsn=19/6BF39CB8
2026-03-19 07:40:01.056 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:40:02.130 CET [3248] LOG:  checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.978 s, sync=0.044 s, total=1.075 s; sync files=9, longest=0.009 s, average=0.005 s; distance=45 kB, estimate=139 kB; lsn=19/6BF45310, redo lsn=19/6BF452B8
2026-03-19 07:42:20.757 CET [4188] ERROR:  Account "sje" does not have access role "group_accounts_administrator"
2026-03-19 07:42:20.757 CET [4188] CONTEXT:  PL/pgSQL function administrator_accounts_access_remove(text,text) line 78 at RAISE
2026-03-19 07:42:20.757 CET [4188] STATEMENT:  SELECT sonex.administrator_accounts_access_remove(
	    'sje',
	    'group_accounts_administrator'
	);
2026-03-19 07:43:20.490 CET [3500] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 07:43:20.490 CET [3500] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 07:43:39.911 CET [7044] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 07:43:39.911 CET [7044] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 07:44:17.337 CET [6364] ERROR:  cannot drop columns from view
2026-03-19 07:44:17.337 CET [6364] STATEMENT:  CREATE OR REPLACE VIEW sonex.accounts_with_groups_v
	    AS
	     WITH base_accounts AS (
	         SELECT r.oid AS account_role_oid,
	            r.rolname AS account_name,
	            r.rolcanlogin AS is_enabled
	           FROM pg_roles r
	             JOIN pg_auth_members m ON m.member = r.oid
	             JOIN pg_roles parent_role ON parent_role.oid = m.roleid
	          WHERE parent_role.rolname = 'account'::name
	        ), account_groups AS (
	         SELECT m.member AS account_role_oid,
	            array_agg(grp.rolname ORDER BY grp.rolname) AS groups
	           FROM pg_auth_members m
	             JOIN pg_roles grp ON grp.oid = m.roleid
	          WHERE grp.rolname ~~ like_escape('group\_%'::text, '\'::text)
	          GROUP BY m.member
	        ), direct_permissions AS (
	         SELECT m.member AS account_role_oid,
	            array_agg(p.rolname ORDER BY p.rolname) AS permissions_direct
	           FROM pg_auth_members m
	             JOIN pg_roles p ON p.oid = m.roleid
	          WHERE p.rolname ~~ like_escape('permission\_%'::text, '\'::text)
	          GROUP BY m.member
	        ), group_permissions_raw AS (
	         SELECT account_members.member AS account_role_oid,
	            permission_role.rolname AS permission_name
	           FROM pg_auth_members account_members
	             JOIN pg_roles group_role ON group_role.oid = account_members.roleid
	             JOIN pg_auth_members group_members ON group_members.member = group_role.oid
	             JOIN pg_roles permission_role ON permission_role.oid = group_members.roleid
	          WHERE group_role.rolname ~~ like_escape('group\_%'::text, '\'::text) AND permission_role.rolname ~~ like_escape('permission\_%'::text, '\'::text)
	        ), all_permissions AS (
	         SELECT b_1.account_role_oid,
	            array_agg(p.permission_name ORDER BY p.permission_name) AS permissions_all
	           FROM base_accounts b_1
	             LEFT JOIN ( SELECT d.account_role_oid,
	                    unnest(d.permissions_direct) AS permission_name
	                   FROM direct_permissions d
	                UNION
	                 SELECT DISTINCT g_1.account_role_oid,
	                    g_1.permission_name
	                   FROM group_permissions_raw g_1) p ON p.account_role_oid = b_1.account_role_oid
	          GROUP BY b_1.account_role_oid
	        )
	 SELECT a.id,
	    b.account_name,
	    a.first_name,
	    a.last_name,
	    a.email,
	    a.phone_number,
	    a.department,
	    a.job_title,
	    a.native_language,
	    a.other_languages,
	    a.account_locus_wms,
	    a.account_locus_terminal,
	    a.account_orp,
	    a.account_bk,
	    a.account_dpd,
	    a.account_xenos,
	    a.tags,
	    a.notes,
	    a.created_at,
	    a.updated_at,
	    b.is_enabled,
	    COALESCE(g.groups, '{}'::text[]::name[]) AS groups,
	    COALESCE(dp.permissions_direct, '{}'::text[]::name[]) AS permissions_direct,
	    COALESCE(ap.permissions_all, '{}'::text[]::name[]) AS permissions_all
	   FROM base_accounts b
	     LEFT JOIN sonex.accounts a ON a.account_name::text = b.account_name
	     LEFT JOIN account_groups g ON g.account_role_oid = b.account_role_oid
	     LEFT JOIN direct_permissions dp ON dp.account_role_oid = b.account_role_oid
	     LEFT JOIN all_permissions ap ON ap.account_role_oid = b.account_role_oid;
2026-03-19 07:45:01.126 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:45:03.565 CET [3248] LOG:  checkpoint complete: wrote 22 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.304 s, sync=0.093 s, total=2.439 s; sync files=20, longest=0.009 s, average=0.005 s; distance=49 kB, estimate=130 kB; lsn=19/6BF51AB8, redo lsn=19/6BF51A28
2026-03-19 07:50:01.557 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:50:02.521 CET [3248] LOG:  checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.881 s, sync=0.039 s, total=0.965 s; sync files=7, longest=0.008 s, average=0.006 s; distance=22 kB, estimate=119 kB; lsn=19/6BF57418, redo lsn=19/6BF573C0
2026-03-19 07:50:40.259 CET [3592] ERROR:  column "id" does not exist at character 8
2026-03-19 07:50:40.259 CET [3592] STATEMENT:  SELECT id, account_name, first_name, last_name, email, department, job_title, tags, created_at, updated_at, is_enabled
2026-03-19 07:51:20.465 CET [7044] ERROR:  column "id" does not exist at character 8
2026-03-19 07:51:20.465 CET [7044] STATEMENT:  SELECT id, account_name, first_name, last_name, email, department, job_title, tags, created_at, updated_at, is_enabled
2026-03-19 07:51:29.248 CET [7044] ERROR:  column "id" does not exist at character 8
2026-03-19 07:51:29.248 CET [7044] STATEMENT:  SELECT Id, account_name, first_name, last_name, email, department, job_title, tags, created_at, updated_at, is_enabled
2026-03-19 07:55:01.524 CET [3248] LOG:  checkpoint starting: time
2026-03-19 07:55:02.124 CET [3248] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.541 s, sync=0.019 s, total=0.600 s; sync files=4, longest=0.007 s, average=0.005 s; distance=25 kB, estimate=110 kB; lsn=19/6BF5DB10, redo lsn=19/6BF5DAB8
2026-03-19 08:00:01.130 CET [3248] LOG:  checkpoint starting: time
2026-03-19 08:00:01.526 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.324 s, sync=0.021 s, total=0.397 s; sync files=4, longest=0.007 s, average=0.006 s; distance=14 kB, estimate=100 kB; lsn=19/6BF61568, redo lsn=19/6BF61510
2026-03-19 08:10:01.524 CET [3248] LOG:  checkpoint starting: time
2026-03-19 08:10:01.920 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.331 s, sync=0.020 s, total=0.396 s; sync files=4, longest=0.007 s, average=0.005 s; distance=21 kB, estimate=92 kB; lsn=19/6BF66CD8, redo lsn=19/6BF66C80
2026-03-19 08:15:01.920 CET [3248] LOG:  checkpoint starting: time
2026-03-19 08:15:02.313 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.331 s, sync=0.019 s, total=0.394 s; sync files=4, longest=0.006 s, average=0.005 s; distance=20 kB, estimate=85 kB; lsn=19/6BF6BF68, redo lsn=19/6BF6BF10
2026-03-19 08:30:01.315 CET [3248] LOG:  checkpoint starting: time
2026-03-19 08:30:01.928 CET [3248] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.549 s, sync=0.019 s, total=0.614 s; sync files=5, longest=0.006 s, average=0.004 s; distance=22 kB, estimate=79 kB; lsn=19/6BF71970, redo lsn=19/6BF718E0
2026-03-19 08:35:01.935 CET [3248] LOG:  checkpoint starting: time
2026-03-19 08:35:02.440 CET [3248] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.437 s, sync=0.019 s, total=0.505 s; sync files=4, longest=0.006 s, average=0.005 s; distance=21 kB, estimate=73 kB; lsn=19/6BF77038, redo lsn=19/6BF76FE0
2026-03-19 09:08:59.937 CET [5596] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 09:15:01.482 CET [3248] LOG:  checkpoint starting: time
2026-03-19 09:15:01.877 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.332 s, sync=0.019 s, total=0.395 s; sync files=4, longest=0.006 s, average=0.005 s; distance=20 kB, estimate=68 kB; lsn=19/6BF7C0C0, redo lsn=19/6BF7C068
2026-03-19 09:19:09.743 CET [5884] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 09:19:09.743 CET [5884] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 09:19:28.566 CET [6416] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 09:19:28.566 CET [6416] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 09:42:49.427 CET [4188] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 09:43:30.712 CET [3500] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 09:44:16.349 CET [3744] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 09:51:39.244 CET [7044] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 10:15:01.935 CET [3248] LOG:  checkpoint starting: time
2026-03-19 10:15:02.662 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.658 s, sync=0.024 s, total=0.728 s; sync files=5, longest=0.007 s, average=0.005 s; distance=25 kB, estimate=63 kB; lsn=19/6BF82560, redo lsn=19/6BF82508
2026-03-19 10:16:10.693 CET [6364] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 10:20:01.665 CET [3248] LOG:  checkpoint starting: time
2026-03-19 10:20:02.176 CET [3248] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.439 s, sync=0.027 s, total=0.511 s; sync files=4, longest=0.009 s, average=0.007 s; distance=23 kB, estimate=59 kB; lsn=19/6BF88370, redo lsn=19/6BF88318
2026-03-19 10:25:01.178 CET [3248] LOG:  checkpoint starting: time
2026-03-19 10:25:01.571 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.332 s, sync=0.018 s, total=0.394 s; sync files=4, longest=0.006 s, average=0.005 s; distance=18 kB, estimate=55 kB; lsn=19/6BF8CDA0, redo lsn=19/6BF8CD48
2026-03-19 10:25:19.945 CET [4352] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 10:30:01.578 CET [3248] LOG:  checkpoint starting: time
2026-03-19 10:30:02.292 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.647 s, sync=0.020 s, total=0.714 s; sync files=5, longest=0.006 s, average=0.004 s; distance=29 kB, estimate=53 kB; lsn=19/6BF94598, redo lsn=19/6BF94540
2026-03-19 10:33:26.950 CET [4676] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 10:33:26.950 CET [4676] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 10:35:01.303 CET [3248] LOG:  checkpoint starting: time
2026-03-19 10:35:01.710 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.330 s, sync=0.024 s, total=0.407 s; sync files=4, longest=0.009 s, average=0.006 s; distance=20 kB, estimate=49 kB; lsn=19/6BF996B8, redo lsn=19/6BF99660
2026-03-19 10:40:01.705 CET [3248] LOG:  checkpoint starting: time
2026-03-19 10:40:02.986 CET [3248] LOG:  checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.205 s, sync=0.031 s, total=1.281 s; sync files=7, longest=0.007 s, average=0.005 s; distance=55 kB, estimate=55 kB; lsn=19/6BFA7598, redo lsn=19/6BFA7508
2026-03-19 10:43:24.846 CET [5560] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 10:43:24.846 CET [5560] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 10:43:49.799 CET [5560] ERROR:  column "szy" does not exist at character 44
2026-03-19 10:43:49.799 CET [5560] STATEMENT:  SELECT sonex.administrator_accounts_create(szy,
		same10,
		Sara,
		Szymczak
	)
2026-03-19 10:45:01.995 CET [3248] LOG:  checkpoint starting: time
2026-03-19 10:45:05.324 CET [3248] LOG:  checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.165 s, sync=0.119 s, total=3.329 s; sync files=27, longest=0.012 s, average=0.005 s; distance=41 kB, estimate=54 kB; lsn=19/6BFB1AB0, redo lsn=19/6BFB1A58
2026-03-19 10:50:01.324 CET [3248] LOG:  checkpoint starting: time
2026-03-19 10:50:02.162 CET [3248] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.768 s, sync=0.023 s, total=0.839 s; sync files=5, longest=0.005 s, average=0.005 s; distance=31 kB, estimate=51 kB; lsn=19/6BFB9890, redo lsn=19/6BFB9838
2026-03-19 10:55:50.632 CET [3520] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 10:55:50.632 CET [3520] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 10:56:33.097 CET [3520] ERROR:  cannot alter type of a column used by a view or rule
2026-03-19 10:56:33.097 CET [3520] DETAIL:  rule _RETURN on view sonex.accounts_with_groups_v depends on column "tags"
2026-03-19 10:56:33.097 CET [3520] STATEMENT:  BEGIN;
	
	-- 1. usuń stary indeks dla text[]
	DROP INDEX IF EXISTS sonex.idx_accounts_tags;
	
	-- 2. zmień kolumnę tags z text[] na text
	ALTER TABLE sonex.accounts
	    ALTER COLUMN tags DROP DEFAULT,
	    ALTER COLUMN tags TYPE text
	    USING array_to_string(tags, ', '),
	    ALTER COLUMN tags SET DEFAULT '';
	
	-- 3. opcjonalnie: jeśli chcesz wymusić NOT NULL + pusty string
	UPDATE sonex.accounts
	SET tags = ''
	WHERE tags IS NULL;
	
	ALTER TABLE sonex.accounts
	    ALTER COLUMN tags SET NOT NULL;
	
	-- 4. nowy indeks
	-- jeśli będziesz filtrować po dokładnej wartości:
	CREATE INDEX IF NOT EXISTS idx_accounts_tags
	    ON sonex.accounts USING btree (tags);
	
	COMMIT;
2026-03-19 10:57:06.185 CET [6628] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 10:57:06.185 CET [6628] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 11:00:01.167 CET [3248] LOG:  checkpoint starting: time
2026-03-19 11:00:08.197 CET [3248] LOG:  checkpoint complete: wrote 63 buffers (0.4%); 0 WAL file(s) added, 1 removed, 0 recycled; write=6.762 s, sync=0.183 s, total=7.031 s; sync files=44, longest=0.010 s, average=0.005 s; distance=336 kB, estimate=336 kB; lsn=19/6C00DB88, redo lsn=19/6C00DAF8
2026-03-19 11:05:01.203 CET [3248] LOG:  checkpoint starting: time
2026-03-19 11:05:01.704 CET [3248] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.430 s, sync=0.027 s, total=0.501 s; sync files=5, longest=0.009 s, average=0.006 s; distance=24 kB, estimate=305 kB; lsn=19/6C013D20, redo lsn=19/6C013CC8
2026-03-19 11:05:45.324 CET [6044] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 11:05:45.324 CET [6044] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 11:05:50.396 CET [5724] WARNING:  PID 7044 is not a PostgreSQL backend process
2026-03-19 11:05:57.574 CET [4636] WARNING:  PID 3500 is not a PostgreSQL backend process
2026-03-19 11:06:00.911 CET [6164] WARNING:  PID 5596 is not a PostgreSQL backend process
2026-03-19 11:06:04.081 CET [4264] WARNING:  PID 4188 is not a PostgreSQL backend process
2026-03-19 11:06:12.209 CET [2468] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 11:06:12.209 CET [2468] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 11:06:18.165 CET [232] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 11:06:18.165 CET [232] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 11:06:37.190 CET [6520] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 11:06:37.190 CET [6520] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 11:19:19.835 CET [5884] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 11:19:38.967 CET [6416] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 11:40:01.722 CET [3248] LOG:  checkpoint starting: time
2026-03-19 11:40:02.687 CET [3248] LOG:  checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.879 s, sync=0.041 s, total=0.966 s; sync files=6, longest=0.009 s, average=0.007 s; distance=27 kB, estimate=277 kB; lsn=19/6C01ACE8, redo lsn=19/6C01AC90
2026-03-19 11:45:01.674 CET [3248] LOG:  checkpoint starting: time
2026-03-19 11:45:01.845 CET [3248] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.113 s, sync=0.017 s, total=0.172 s; sync files=2, longest=0.010 s, average=0.009 s; distance=7 kB, estimate=250 kB; lsn=19/6C01CB98, redo lsn=19/6C01CB40
2026-03-19 12:35:01.895 CET [3248] LOG:  checkpoint starting: time
2026-03-19 12:35:02.300 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.327 s, sync=0.017 s, total=0.406 s; sync files=4, longest=0.007 s, average=0.005 s; distance=19 kB, estimate=227 kB; lsn=19/6C0218C0, redo lsn=19/6C021868
2026-03-19 12:50:01.297 CET [3248] LOG:  checkpoint starting: time
2026-03-19 12:50:02.031 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.659 s, sync=0.033 s, total=0.734 s; sync files=5, longest=0.008 s, average=0.007 s; distance=22 kB, estimate=207 kB; lsn=19/6C027210, redo lsn=19/6C0271B8
2026-03-19 12:55:01.034 CET [3248] LOG:  checkpoint starting: time
2026-03-19 12:55:01.736 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.646 s, sync=0.017 s, total=0.702 s; sync files=4, longest=0.006 s, average=0.005 s; distance=31 kB, estimate=189 kB; lsn=19/6C02F090, redo lsn=19/6C02F038
2026-03-19 13:00:01.733 CET [3248] LOG:  checkpoint starting: time
2026-03-19 13:00:02.342 CET [3248] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.533 s, sync=0.022 s, total=0.609 s; sync files=4, longest=0.008 s, average=0.006 s; distance=31 kB, estimate=173 kB; lsn=19/6C037068, redo lsn=19/6C037010
2026-03-19 13:06:39.907 CET [6044] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 13:06:47.016 CET [4676] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 13:07:18.291 CET [6520] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 13:10:01.352 CET [3248] LOG:  checkpoint starting: time
2026-03-19 13:10:01.744 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.330 s, sync=0.019 s, total=0.393 s; sync files=4, longest=0.006 s, average=0.005 s; distance=15 kB, estimate=157 kB; lsn=19/6C03AD30, redo lsn=19/6C03ACD8
2026-03-19 13:15:01.753 CET [3248] LOG:  checkpoint starting: time
2026-03-19 13:15:02.145 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.334 s, sync=0.018 s, total=0.393 s; sync files=4, longest=0.008 s, average=0.005 s; distance=21 kB, estimate=144 kB; lsn=19/6C0403C8, redo lsn=19/6C040370
2026-03-19 13:20:01.136 CET [3248] LOG:  checkpoint starting: time
2026-03-19 13:20:01.738 CET [3248] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.541 s, sync=0.019 s, total=0.602 s; sync files=4, longest=0.006 s, average=0.005 s; distance=24 kB, estimate=132 kB; lsn=19/6C0466A0, redo lsn=19/6C046648
2026-03-19 13:25:01.730 CET [3248] LOG:  checkpoint starting: time
2026-03-19 13:25:02.340 CET [3248] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.550 s, sync=0.019 s, total=0.610 s; sync files=4, longest=0.007 s, average=0.005 s; distance=23 kB, estimate=121 kB; lsn=19/6C04C560, redo lsn=19/6C04C508
2026-03-19 13:50:01.364 CET [3248] LOG:  checkpoint starting: time
2026-03-19 13:50:01.768 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.342 s, sync=0.020 s, total=0.404 s; sync files=4, longest=0.008 s, average=0.005 s; distance=25 kB, estimate=111 kB; lsn=19/6C052D20, redo lsn=19/6C052CC8
2026-03-19 14:00:01.780 CET [3248] LOG:  checkpoint starting: time
2026-03-19 14:00:02.172 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.320 s, sync=0.021 s, total=0.392 s; sync files=4, longest=0.008 s, average=0.006 s; distance=21 kB, estimate=102 kB; lsn=19/6C058418, redo lsn=19/6C0583C0
2026-03-19 14:35:01.212 CET [3248] LOG:  checkpoint starting: time
2026-03-19 14:35:01.724 CET [3248] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.450 s, sync=0.018 s, total=0.512 s; sync files=4, longest=0.006 s, average=0.005 s; distance=26 kB, estimate=95 kB; lsn=19/6C05ECB8, redo lsn=19/6C05EC28
2026-03-19 14:40:01.727 CET [3248] LOG:  checkpoint starting: time
2026-03-19 14:40:02.230 CET [3248] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.441 s, sync=0.020 s, total=0.503 s; sync files=4, longest=0.006 s, average=0.005 s; distance=26 kB, estimate=88 kB; lsn=19/6C065698, redo lsn=19/6C065640
2026-03-19 15:00:01.255 CET [3248] LOG:  checkpoint starting: time
2026-03-19 15:00:01.646 CET [3248] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.331 s, sync=0.018 s, total=0.392 s; sync files=4, longest=0.006 s, average=0.005 s; distance=24 kB, estimate=81 kB; lsn=19/6C06B6F8, redo lsn=19/6C06B6A0
2026-03-19 15:10:01.649 CET [3248] LOG:  checkpoint starting: time
2026-03-19 15:10:12.364 CET [3248] LOG:  checkpoint complete: wrote 98 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=10.602 s, sync=0.064 s, total=10.715 s; sync files=13, longest=0.012 s, average=0.005 s; distance=747 kB, estimate=747 kB; lsn=19/6C126440, redo lsn=19/6C1263B0
2026-03-19 15:37:46.054 CET [6344] FATAL:  password authentication failed for user "user_sje"
2026-03-19 15:37:46.054 CET [6344] DETAIL:  Role "user_sje" does not exist.
	Connection matched file "C:/Program Files/PostgreSQL/17/data/pg_hba.conf" line 119: "host    all             all             0.0.0.0/0               scram-sha-256"
2026-03-19 15:37:46.283 CET [7092] FATAL:  password authentication failed for user "user_sje"
2026-03-19 15:37:46.283 CET [7092] DETAIL:  Role "user_sje" does not exist.
	Connection matched file "C:/Program Files/PostgreSQL/17/data/pg_hba.conf" line 119: "host    all             all             0.0.0.0/0               scram-sha-256"
2026-03-19 15:51:33.094 CET [6072] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 15:51:33.094 CET [6072] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 15:54:44.959 CET [6472] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 15:54:44.959 CET [6472] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 15:54:44.971 CET [2724] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 15:54:44.971 CET [2724] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 15:58:14.795 CET [2724] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 15:58:14.795 CET [6072] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 15:58:14.795 CET [6472] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 18:48:15.248 CET [6700] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 18:48:15.248 CET [6700] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 18:50:07.735 CET [2704] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 18:50:07.735 CET [2704] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 18:50:07.809 CET [2232] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-03-19 18:50:07.809 CET [2232] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-03-19 19:05:01.523 CET [3248] LOG:  checkpoint starting: time
2026-03-19 19:05:02.254 CET [3248] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.654 s, sync=0.027 s, total=0.731 s; sync files=6, longest=0.006 s, average=0.005 s; distance=20 kB, estimate=674 kB; lsn=19/6C12B7D0, redo lsn=19/6C12B778
2026-03-19 19:10:01.246 CET [3248] LOG:  checkpoint starting: time
2026-03-19 19:10:02.197 CET [3248] LOG:  checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.876 s, sync=0.033 s, total=0.951 s; sync files=5, longest=0.009 s, average=0.007 s; distance=31 kB, estimate=610 kB; lsn=19/6C133678, redo lsn=19/6C133620
2026-03-19 19:15:01.188 CET [3248] LOG:  checkpoint starting: time
2026-03-19 19:15:01.782 CET [3248] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.537 s, sync=0.019 s, total=0.595 s; sync files=4, longest=0.006 s, average=0.005 s; distance=23 kB, estimate=551 kB; lsn=19/6C139450, redo lsn=19/6C1393F8
2026-03-19 20:25:01.819 CET [3248] LOG:  checkpoint starting: time
2026-03-19 20:25:03.004 CET [3248] LOG:  checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.086 s, sync=0.028 s, total=1.186 s; sync files=5, longest=0.007 s, average=0.006 s; distance=54 kB, estimate=501 kB; lsn=19/6C146E90, redo lsn=19/6C146E38
2026-03-19 20:49:38.173 CET [6700] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-03-19 20:50:17.947 CET [2232] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.