2025-01-25 11:15:22.749 GMT postmaster[4504] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-25 11:15:22.750 GMT postmaster[4504] LOG: listening on Unix socket "c:/cirrus/.s.PGSQL.40030" 2025-01-25 11:15:22.776 GMT startup[3988] LOG: database system was shut down at 2025-01-25 11:11:57 GMT 2025-01-25 11:15:22.804 GMT postmaster[4504] LOG: database system is ready to accept connections 2025-01-25 11:15:23.162 GMT client backend[3792] pg_regress/init ERROR: gen_salt: Unknown salt algorithm 2025-01-25 11:15:23.162 GMT client backend[3792] pg_regress/init STATEMENT: select gen_salt('foo'); 2025-01-25 11:15:23.170 GMT client backend[3792] pg_regress/init ERROR: Cannot use "foo": No such hash algorithm 2025-01-25 11:15:23.170 GMT client backend[3792] pg_regress/init STATEMENT: select digest('foo', 'foo'); 2025-01-25 11:15:23.170 GMT client backend[3792] pg_regress/init ERROR: Cannot use "foo": No such hash algorithm 2025-01-25 11:15:23.170 GMT client backend[3792] pg_regress/init STATEMENT: select hmac('foo', 'foo', 'foo'); 2025-01-25 11:15:23.171 GMT client backend[3792] pg_regress/init ERROR: Cannot use "foo": No such cipher algorithm 2025-01-25 11:15:23.171 GMT client backend[3792] pg_regress/init STATEMENT: select encrypt('foo', 'foo', 'foo'); 2025-01-25 11:15:24.609 GMT client backend[2840] pg_regress/rijndael ERROR: encrypt error: Encryption failed 2025-01-25 11:15:24.609 GMT client backend[2840] pg_regress/rijndael STATEMENT: SELECT encrypt( '\x00112233445566778899aabbccddeeff00', '\x000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f', 'aes-cbc/pad:none'); 2025-01-25 11:15:24.611 GMT client backend[2840] pg_regress/rijndael ERROR: decrypt error: Decryption failed 2025-01-25 11:15:24.611 GMT client backend[2840] pg_regress/rijndael STATEMENT: select encode(decrypt(encrypt('foo', '0123456', 'aes') || '\x00'::bytea, '0123456', 'aes'), 'escape'); 2025-01-25 11:15:24.612 GMT client backend[2840] pg_regress/rijndael ERROR: decrypt_iv error: Decryption failed 2025-01-25 11:15:24.612 GMT client backend[2840] pg_regress/rijndael STATEMENT: select encode(decrypt_iv('\xa21a9c15231465964e3396d32095e67eb52bab05f556a581621dee1b85385789', '0123456', 'abcd', 'aes'), 'escape'); 2025-01-25 11:15:26.596 GMT client backend[6176] pg_regress/crypt-des ERROR: invalid salt 2025-01-25 11:15:26.596 GMT client backend[6176] pg_regress/crypt-des STATEMENT: SELECT crypt('password', 'a'); 2025-01-25 11:15:26.605 GMT client backend[6176] pg_regress/crypt-des ERROR: use of built-in crypto functions is disabled 2025-01-25 11:15:26.605 GMT client backend[6176] pg_regress/crypt-des STATEMENT: UPDATE ctest SET salt = gen_salt('des'); 2025-01-25 11:15:26.605 GMT client backend[6176] pg_regress/crypt-des ERROR: use of built-in crypto functions is disabled 2025-01-25 11:15:26.605 GMT client backend[6176] pg_regress/crypt-des STATEMENT: UPDATE ctest SET res = crypt(data, salt); 2025-01-25 11:15:27.253 GMT client backend[1656] pg_regress/crypt-blowfish ERROR: invalid salt 2025-01-25 11:15:27.253 GMT client backend[1656] pg_regress/crypt-blowfish STATEMENT: SELECT crypt('foox', '$2a$'); 2025-01-25 11:15:27.253 GMT client backend[1656] pg_regress/crypt-blowfish ERROR: invalid salt 2025-01-25 11:15:27.253 GMT client backend[1656] pg_regress/crypt-blowfish STATEMENT: SELECT crypt('foox', '$2a$40$RQiOJ.3ELirrXwxIZY8q0O'); 2025-01-25 11:15:27.253 GMT client backend[1656] pg_regress/crypt-blowfish ERROR: invalid salt 2025-01-25 11:15:27.253 GMT client backend[1656] pg_regress/crypt-blowfish STATEMENT: SELECT crypt('foox', '$2a$00$RQiOJ.3ELirrXwxIZY8q0O'); 2025-01-25 11:15:27.613 GMT client backend[5328] pg_regress/crypt-xdes ERROR: invalid salt 2025-01-25 11:15:27.613 GMT client backend[5328] pg_regress/crypt-xdes STATEMENT: SELECT crypt('foox', '_J9..BWH'); 2025-01-25 11:15:27.614 GMT client backend[5328] pg_regress/crypt-xdes ERROR: crypt(3) returned NULL 2025-01-25 11:15:27.614 GMT client backend[5328] pg_regress/crypt-xdes STATEMENT: SELECT crypt('password', '_........'); 2025-01-25 11:15:27.614 GMT client backend[5328] pg_regress/crypt-xdes ERROR: crypt(3) returned NULL 2025-01-25 11:15:27.614 GMT client backend[5328] pg_regress/crypt-xdes STATEMENT: SELECT crypt('password', '_..!!!!!!'); 2025-01-25 11:15:27.811 GMT client backend[1548] pg_regress/pgp-armor ERROR: Corrupt ascii-armor 2025-01-25 11:15:27.811 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select dearmor(' -----BEGIN PGP MESSAGE----- em9va2E= =ZZZZ -----END PGP MESSAGE----- '); 2025-01-25 11:15:27.811 GMT client backend[1548] pg_regress/pgp-armor ERROR: Corrupt ascii-armor 2025-01-25 11:15:27.811 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select * from pgp_armor_headers(' -----BEGIN PGP MESSAGE----- foo: em9va2E= =ZZZZ -----END PGP MESSAGE----- '); 2025-01-25 11:15:27.812 GMT client backend[1548] pg_regress/pgp-armor ERROR: Corrupt ascii-armor 2025-01-25 11:15:27.812 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select * from pgp_armor_headers(' -----BEGIN PGP MESSAGE----- em9va2E= =ZZZZ -----END PGP MESSAGE----- '); 2025-01-25 11:15:27.817 GMT client backend[1548] pg_regress/pgp-armor ERROR: mismatched array dimensions 2025-01-25 11:15:27.817 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array['too', 'many']); 2025-01-25 11:15:27.817 GMT client backend[1548] pg_regress/pgp-armor ERROR: mismatched array dimensions 2025-01-25 11:15:27.817 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select armor('', array['too', 'many'], array['foo']); 2025-01-25 11:15:27.817 GMT client backend[1548] pg_regress/pgp-armor ERROR: wrong number of array subscripts 2025-01-25 11:15:27.817 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select armor('', array[['']], array['foo']); 2025-01-25 11:15:27.817 GMT client backend[1548] pg_regress/pgp-armor ERROR: wrong number of array subscripts 2025-01-25 11:15:27.817 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array[['']]); 2025-01-25 11:15:27.818 GMT client backend[1548] pg_regress/pgp-armor ERROR: null value not allowed for header key 2025-01-25 11:15:27.818 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select armor('', array[null], array['foo']); 2025-01-25 11:15:27.818 GMT client backend[1548] pg_regress/pgp-armor ERROR: null value not allowed for header value 2025-01-25 11:15:27.818 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array[null]); 2025-01-25 11:15:27.818 GMT client backend[1548] pg_regress/pgp-armor ERROR: header key must not contain newlines 2025-01-25 11:15:27.818 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select armor('', array[E'embedded\nnewline'], array['foo']); 2025-01-25 11:15:27.819 GMT client backend[1548] pg_regress/pgp-armor ERROR: header value must not contain newlines 2025-01-25 11:15:27.819 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array[E'embedded\nnewline']); 2025-01-25 11:15:27.819 GMT client backend[1548] pg_regress/pgp-armor ERROR: header key must not contain ": " 2025-01-25 11:15:27.819 GMT client backend[1548] pg_regress/pgp-armor STATEMENT: select armor('', array['embedded: colon+space'], array['foo']); 2025-01-25 11:15:28.114 GMT client backend[5152] pg_regress/pgp-decrypt ERROR: Wrong key or corrupt data 2025-01-25 11:15:28.114 GMT client backend[5152] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(dearmor(' -----BEGIN PGP MESSAGE----- ww0EBwMCxf8PTrQBmJdl0jcB6y2joE7GSLKRv7trbNsF5Z8ou5NISLUg31llVH/S0B2wl4bvzZjV VsxxqLSPzNLAeIspJk5G =mSd/ -----END PGP MESSAGE----- '), 'wrong-key', 'debug=1'); 2025-01-25 11:15:28.116 GMT client backend[5152] pg_regress/pgp-decrypt ERROR: Not text data 2025-01-25 11:15:28.116 GMT client backend[5152] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(pgp_sym_encrypt_bytea('P', 'key'), 'key', 'debug=1'); 2025-01-25 11:15:28.116 GMT client backend[5152] pg_regress/pgp-decrypt ERROR: Wrong key or corrupt data 2025-01-25 11:15:28.116 GMT client backend[5152] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(dearmor(' -----BEGIN PGP MESSAGE----- ww0EBwMC9rK/dMkF5Zlt0jcBlzAQ1mQY2qYbKYbw8h3EZ5Jk0K2IiY92R82TRhWzBIF/8cmXDPtP GXsd65oYJZp3Khz0qfyn =Nmpq -----END PGP MESSAGE----- '), 'wrong-key', 'debug=1'); 2025-01-25 11:15:28.117 GMT client backend[5152] pg_regress/pgp-decrypt ERROR: Unsupported compression algorithm 2025-01-25 11:15:28.117 GMT client backend[5152] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(dearmor(' -----BEGIN PGP MESSAGE----- jA0EBwMCRhFrAKNcLVJg0mMBLJG1cCASNk/x/3dt1zJ+2eo7jHfjgg3N6wpB3XIe QCwkWJwlBG5pzbO5gu7xuPQN+TbPJ7aQ2sLx3bAHhtYb0i3vV9RO10Gw++yUyd4R UCAAw2JRIISttRHMfDpDuZJpvYo= =AZ9M -----END PGP MESSAGE----- '), 'key', 'debug=1'); 2025-01-25 11:15:28.591 GMT client backend[640] pg_regress/pgp-encrypt ERROR: Not text data 2025-01-25 11:15:28.591 GMT client backend[640] pg_regress/pgp-encrypt STATEMENT: select pgp_sym_decrypt(pgp_sym_encrypt_bytea('Binary', 'baz'), 'baz'); 2025-01-25 11:15:30.546 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key 2025-01-25 11:15:30.546 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey)) from keytbl, encdata where keytbl.id=2 and encdata.id=1; 2025-01-25 11:15:30.547 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt ERROR: No encryption key found 2025-01-25 11:15:30.547 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey)) from keytbl, encdata where keytbl.id=4 and encdata.id=1; 2025-01-25 11:15:30.548 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2025-01-25 11:15:30.548 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey), '123') from keytbl, encdata where keytbl.id=7 and encdata.id=4; 2025-01-25 11:15:30.552 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt ERROR: Need password for secret key 2025-01-25 11:15:30.552 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey)) from keytbl, encdata where keytbl.id=5 and encdata.id=1; 2025-01-25 11:15:30.553 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2025-01-25 11:15:30.553 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey), 'foo') from keytbl, encdata where keytbl.id=5 and encdata.id=1; 2025-01-25 11:15:30.556 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2025-01-25 11:15:30.556 GMT client backend[1772] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey)) from keytbl, encdata where keytbl.id=6 and encdata.id=5; 2025-01-25 11:15:30.840 GMT client backend[6964] pg_regress/pgp-pubkey-encrypt ERROR: No encryption key found 2025-01-25 11:15:30.840 GMT client backend[6964] pg_regress/pgp-pubkey-encrypt STATEMENT: select pgp_pub_decrypt( pgp_pub_encrypt('Secret msg', dearmor(pubkey)), dearmor(seckey)) from keytbl where keytbl.id=4; 2025-01-25 11:15:30.840 GMT client backend[6964] pg_regress/pgp-pubkey-encrypt ERROR: Refusing to encrypt with secret key 2025-01-25 11:15:30.840 GMT client backend[6964] pg_regress/pgp-pubkey-encrypt STATEMENT: select pgp_pub_decrypt( pgp_pub_encrypt('Secret msg', dearmor(seckey)), dearmor(seckey)) from keytbl where keytbl.id=1; 2025-01-25 11:15:30.842 GMT client backend[6964] pg_regress/pgp-pubkey-encrypt ERROR: Not text data 2025-01-25 11:15:30.842 GMT client backend[6964] pg_regress/pgp-pubkey-encrypt STATEMENT: select pgp_pub_decrypt( pgp_pub_encrypt_bytea('Secret msg', dearmor(pubkey)), dearmor(seckey)) from keytbl where keytbl.id=1; 2025-01-25 11:15:31.254 GMT client backend[2364] pg_regress/pgp-info ERROR: No encryption key found 2025-01-25 11:15:31.254 GMT client backend[2364] pg_regress/pgp-info STATEMENT: select pgp_key_id(dearmor(pubkey)) from keytbl where id=4; 2025-01-25 11:15:31.257 GMT client backend[2364] pg_regress/pgp-info ERROR: No encryption key found 2025-01-25 11:15:31.257 GMT client backend[2364] pg_regress/pgp-info STATEMENT: select pgp_key_id(dearmor(seckey)) from keytbl where id=4; 2025-01-25 11:15:31.989 GMT postmaster[4504] LOG: received fast shutdown request 2025-01-25 11:15:31.990 GMT postmaster[4504] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2964, PID: 4504 abort() has been called