025-07-10 12:49:00.836 CDT [14680534] LOG: starting PostgreSQL 16.9 on powerpc-ibm-aix7.2.5.0, compiled by gcc-12 (GCC) 12.3.0, 64-bit 2025-07-10 12:49:00.837 CDT [14680534] LOG: listening on Unix socket "/tmp/6JYaIWLWXo/.s.PGSQL.26272" 2025-07-10 12:49:00.843 CDT [19726748] LOG: database system was shut down at 2025-07-10 12:49:00 CDT 2025-07-10 12:49:00.855 CDT [14680534] LOG: database system is ready to accept connections 2025-07-10 12:49:00.905 CDT [21758208] [unknown] LOG: connection received: host=[local] 2025-07-10 12:49:00.906 CDT [21758208] [unknown] LOG: connection authorized: user=pgsql database=postgres application_name=001_password.pl 2025-07-10 12:49:00.919 CDT [21758208] 001_password.pl LOG: statement: SET password_encryption='scram-sha-256'; 2025-07-10 12:49:00.919 CDT [21758208] 001_password.pl LOG: statement: CREATE ROLE scram_role LOGIN PASSWORD 'pass'; 2025-07-10 12:49:00.984 CDT [27853256] [unknown] LOG: connection received: host=[local] 2025-07-10 12:49:00.985 CDT [27853256] [unknown] LOG: connection authorized: user=pgsql database=postgres application_name=001_password.pl 2025-07-10 12:49:00.988 CDT [27853256] 001_password.pl LOG: statement: SET password_encryption='md5'; 2025-07-10 12:49:00.988 CDT [27853256] 001_password.pl LOG: statement: CREATE ROLE md5_role LOGIN PASSWORD 'pass'; 2025-07-10 12:49:01.009 CDT [27853258] [unknown] LOG: connection received: host=[local] 2025-07-10 12:49:01.010 CDT [27853258] [unknown] LOG: connection authorized: user=pgsql database=postgres application_name=001_password.pl 2025-07-10 12:49:01.013 CDT [27853258] 001_password.pl LOG: statement: CREATE TABLE sysuser_data (n) AS SELECT NULL FROM generate_series(1, 10); 2025-07-10 12:49:01.020 CDT [27853258] 001_password.pl LOG: statement: GRANT ALL ON sysuser_data TO md5_role; 2025-07-10 12:49:01.041 CDT [27853260] [unknown] LOG: connection received: host=[local] 2025-07-10 12:49:01.042 CDT [27853260] [unknown] LOG: connection authorized: user=pgsql database=postgres application_name=001_password.pl 2025-07-10 12:49:01.045 CDT [27853260] 001_password.pl LOG: statement: SET password_encryption='md5'; 2025-07-10 12:49:01.045 CDT [27853260] 001_password.pl LOG: statement: CREATE ROLE "md5,role" LOGIN PASSWORD 'pass'; 2025-07-10 12:49:01.066 CDT [21758210] [unknown] LOG: connection received: host=[local] 2025-07-10 12:49:01.068 CDT [21758210] [unknown] LOG: connection authorized: user=pgsql database=postgres application_name=001_password.pl 2025-07-10 12:49:01.070 CDT [21758210] 001_password.pl LOG: statement: SET password_encryption='scram-sha-256'; 2025-07-10 12:49:01.071 CDT [21758210] 001_password.pl LOG: statement: SET scram_iterations=1024; 2025-07-10 12:49:01.071 CDT [21758210] 001_password.pl LOG: statement: CREATE ROLE scram_role_iter LOGIN PASSWORD 'pass'; 2025-07-10 12:49:01.083 CDT [21758210] 001_password.pl LOG: statement: RESET scram_iterations; 2025-07-10 12:49:01.106 CDT [21758212] [unknown] LOG: connection received: host=[local] 2025-07-10 12:49:01.107 CDT [21758212] [unknown] LOG: connection authorized: user=pgsql database=postgres application_name=001_password.pl 2025-07-10 12:49:01.110 CDT [21758212] 001_password.pl LOG: statement: SELECT substr(rolpassword,1,19) FROM pg_authid WHERE rolname = 'scram_role_iter' 2025-07-10 12:49:01.147 CDT [19923228] [unknown] LOG: connection received: host=[local] 2025-07-10 12:49:01.148 CDT [19923228] [unknown] LOG: connection authorized: user=pgsql database=postgres application_name=001_password.pl 2025-07-10 12:52:02.399 CDT [14680534] LOG: received immediate shutdown request 2025-07-10 12:52:02.419 CDT [14680534] LOG: database system is shut down