2025-01-05 17:37:53.998 UTC postmaster[39349] LOG: starting PostgreSQL 18devel on x86_64-linux, compiled by gcc-12.2.0, 64-bit 2025-01-05 17:37:53.998 UTC postmaster[39349] LOG: listening on Unix socket "/tmp/pg_regress-v2Y4pf/.s.PGSQL.40031" 2025-01-05 17:37:54.001 UTC startup[39352] LOG: database system was shut down at 2025-01-05 17:28:41 UTC 2025-01-05 17:37:54.005 UTC postmaster[39349] LOG: database system is ready to accept connections 2025-01-05 17:37:54.119 UTC client backend[39361] pg_regress/init ERROR: gen_salt: Unknown salt algorithm 2025-01-05 17:37:54.119 UTC client backend[39361] pg_regress/init STATEMENT: select gen_salt('foo'); 2025-01-05 17:37:54.120 UTC client backend[39361] pg_regress/init ERROR: Cannot use "foo": No such hash algorithm 2025-01-05 17:37:54.120 UTC client backend[39361] pg_regress/init STATEMENT: select digest('foo', 'foo'); 2025-01-05 17:37:54.120 UTC client backend[39361] pg_regress/init ERROR: Cannot use "foo": No such hash algorithm 2025-01-05 17:37:54.120 UTC client backend[39361] pg_regress/init STATEMENT: select hmac('foo', 'foo', 'foo'); 2025-01-05 17:37:54.120 UTC client backend[39361] pg_regress/init ERROR: Cannot use "foo": No such cipher algorithm 2025-01-05 17:37:54.120 UTC client backend[39361] pg_regress/init STATEMENT: select encrypt('foo', 'foo', 'foo'); 2025-01-05 17:37:54.203 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.203 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\x0000000000000000', '\x0000000000000000', 'bf-ecb/pad:none'); 2025-01-05 17:37:54.203 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.203 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\xffffffffffffffff', '\xffffffffffffffff', 'bf-ecb/pad:none'); 2025-01-05 17:37:54.203 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.203 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\x1000000000000001', '\x3000000000000000', 'bf-ecb/pad:none'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\x1111111111111111', '\x1111111111111111', 'bf-ecb/pad:none'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\x0123456789abcdef', '\xfedcba9876543210', 'bf-ecb/pad:none'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\x01a1d6d039776742', '\xfedcba9876543210', 'bf-ecb/pad:none'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\xffffffffffffffff', '\x0000000000000000', 'bf-ecb/pad:none'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\xfedcba9876543210', '\xf0e1d2c3b4a5968778695a4b3c2d1e0f', 'bf-ecb/pad:none'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\x01234567890123456789', '\x33443344334433443344334433443344', 'bf-ecb'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Key was too big 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\x6b77b4d63006dee605b156e27403979358deb9e7154616d959f1652bd5', '\x37363534333231204e6f77206973207468652074696d6520666f7220', 'bf-cbc'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Key was too big 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\x6b77b4d63006dee605b156e27403979358deb9e7154616d959f1652bd5ff92cc', '\x37363534333231204e6f77206973207468652074696d6520666f722000', 'bf-cbc'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Key was too big 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: SELECT encrypt('\xfedcba9876543210', '\xf0e1d2c3b4a5968778695a4b3c2d1e0f001122334455667704689104c2fd3b2f584023641aba61761f1f1f1f0e0e0e0effffffffffffffff', 'bf-ecb/pad:none'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: select encrypt('', 'foo', 'bf'); 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.204 UTC client backend[39381] pg_regress/blowfish STATEMENT: select encrypt('foo', '0123456789', 'bf'); 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Key was too big 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish STATEMENT: select encrypt('foo', '0123456789012345678901', 'bf'); 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish STATEMENT: select encode(decrypt(encrypt('foo', '0123456', 'bf'), '0123456', 'bf'), 'escape'); 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt_iv error: Cipher cannot be initialized 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish STATEMENT: select encrypt_iv('foo', '0123456', 'abcd', 'bf'); 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish ERROR: decrypt_iv error: Cipher cannot be initialized 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish STATEMENT: select encode(decrypt_iv('\x95c7e89322525d59', '0123456', 'abcd', 'bf'), 'escape'); 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish STATEMENT: select encrypt('Lets try a longer message.', '0123456789', 'bf'); 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.205 UTC client backend[39381] pg_regress/blowfish STATEMENT: select encode(decrypt(encrypt('Lets try a longer message.', '0123456789', 'bf'), '0123456789', 'bf'), 'escape'); 2025-01-05 17:37:54.223 UTC client backend[39387] pg_regress/rijndael ERROR: encrypt error: Encryption failed 2025-01-05 17:37:54.223 UTC client backend[39387] pg_regress/rijndael STATEMENT: SELECT encrypt( '\x00112233445566778899aabbccddeeff00', '\x000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f', 'aes-cbc/pad:none'); 2025-01-05 17:37:54.224 UTC client backend[39387] pg_regress/rijndael ERROR: decrypt error: Decryption failed 2025-01-05 17:37:54.224 UTC client backend[39387] pg_regress/rijndael STATEMENT: select encode(decrypt(encrypt('foo', '0123456', 'aes') || '\x00'::bytea, '0123456', 'aes'), 'escape'); 2025-01-05 17:37:54.224 UTC client backend[39387] pg_regress/rijndael ERROR: decrypt_iv error: Decryption failed 2025-01-05 17:37:54.224 UTC client backend[39387] pg_regress/rijndael STATEMENT: select encode(decrypt_iv('\xa21a9c15231465964e3396d32095e67eb52bab05f556a581621dee1b85385789', '0123456', 'abcd', 'aes'), 'escape'); 2025-01-05 17:37:54.258 UTC client backend[39395] pg_regress/des ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.258 UTC client backend[39395] pg_regress/des STATEMENT: SELECT encrypt('\x0123456789abcdef', '\xfedcba9876543210', 'des-ecb/pad:none'); 2025-01-05 17:37:54.258 UTC client backend[39395] pg_regress/des ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.258 UTC client backend[39395] pg_regress/des STATEMENT: select encrypt('', 'foo', 'des'); 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des STATEMENT: select encrypt('foo', '01234589', 'des'); 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des STATEMENT: select encode(decrypt(encrypt('foo', '0123456', 'des'), '0123456', 'des'), 'escape'); 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des ERROR: encrypt_iv error: Cipher cannot be initialized 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des STATEMENT: select encrypt_iv('foo', '0123456', 'abcd', 'des'); 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des ERROR: decrypt_iv error: Cipher cannot be initialized 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des STATEMENT: select encode(decrypt_iv('\x50735067b073bb93', '0123456', 'abcd', 'des'), 'escape'); 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des STATEMENT: select encrypt('Lets try a longer message.', '01234567', 'des'); 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.259 UTC client backend[39395] pg_regress/des STATEMENT: select encode(decrypt(encrypt('Lets try a longer message.', '01234567', 'des'), '01234567', 'des'), 'escape'); 2025-01-05 17:37:54.293 UTC client backend[39405] pg_regress/cast5 ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.293 UTC client backend[39405] pg_regress/cast5 STATEMENT: SELECT encrypt('\x0123456789ABCDEF', '\x0123456712345678234567893456789A', 'cast5-ecb/pad:none'); 2025-01-05 17:37:54.293 UTC client backend[39405] pg_regress/cast5 ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.293 UTC client backend[39405] pg_regress/cast5 STATEMENT: SELECT encrypt('\x0123456789ABCDEF', '\x01234567123456782345', 'cast5-ecb/pad:none'); 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 STATEMENT: SELECT encrypt('\x0123456789ABCDEF', '\x0123456712', 'cast5-ecb/pad:none'); 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 STATEMENT: select encrypt('', 'foo', 'cast5'); 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 STATEMENT: select encrypt('foo', '0123456789', 'cast5'); 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 STATEMENT: select encode(decrypt(encrypt('foo', '0123456', 'cast5'), '0123456', 'cast5'), 'escape'); 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 ERROR: encrypt_iv error: Cipher cannot be initialized 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 STATEMENT: select encrypt_iv('foo', '0123456', 'abcd', 'cast5'); 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 ERROR: decrypt_iv error: Cipher cannot be initialized 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 STATEMENT: select encode(decrypt_iv('\x384a970695ce016a', '0123456', 'abcd', 'cast5'), 'escape'); 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 STATEMENT: select encrypt('Lets try a longer message.', '0123456789', 'cast5'); 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 ERROR: encrypt error: Cipher cannot be initialized 2025-01-05 17:37:54.294 UTC client backend[39405] pg_regress/cast5 STATEMENT: select encode(decrypt(encrypt('Lets try a longer message.', '0123456789', 'cast5'), '0123456789', 'cast5'), 'escape'); 2025-01-05 17:37:54.312 UTC client backend[39411] pg_regress/crypt-des ERROR: invalid salt 2025-01-05 17:37:54.312 UTC client backend[39411] pg_regress/crypt-des STATEMENT: SELECT crypt('password', 'a'); 2025-01-05 17:37:54.363 UTC client backend[39419] pg_regress/crypt-blowfish ERROR: invalid salt 2025-01-05 17:37:54.363 UTC client backend[39419] pg_regress/crypt-blowfish STATEMENT: SELECT crypt('foox', '$2a$'); 2025-01-05 17:37:54.363 UTC client backend[39419] pg_regress/crypt-blowfish ERROR: invalid salt 2025-01-05 17:37:54.363 UTC client backend[39419] pg_regress/crypt-blowfish STATEMENT: SELECT crypt('foox', '$2a$40$RQiOJ.3ELirrXwxIZY8q0O'); 2025-01-05 17:37:54.364 UTC client backend[39419] pg_regress/crypt-blowfish ERROR: invalid salt 2025-01-05 17:37:54.364 UTC client backend[39419] pg_regress/crypt-blowfish STATEMENT: SELECT crypt('foox', '$2a$00$RQiOJ.3ELirrXwxIZY8q0O'); 2025-01-05 17:37:54.419 UTC client backend[39423] pg_regress/crypt-xdes ERROR: invalid salt 2025-01-05 17:37:54.419 UTC client backend[39423] pg_regress/crypt-xdes STATEMENT: SELECT crypt('foox', '_J9..BWH'); 2025-01-05 17:37:54.419 UTC client backend[39423] pg_regress/crypt-xdes ERROR: crypt(3) returned NULL 2025-01-05 17:37:54.419 UTC client backend[39423] pg_regress/crypt-xdes STATEMENT: SELECT crypt('password', '_........'); 2025-01-05 17:37:54.419 UTC client backend[39423] pg_regress/crypt-xdes ERROR: crypt(3) returned NULL 2025-01-05 17:37:54.419 UTC client backend[39423] pg_regress/crypt-xdes STATEMENT: SELECT crypt('password', '_..!!!!!!'); 2025-01-05 17:37:54.443 UTC client backend[39427] pg_regress/pgp-armor ERROR: Corrupt ascii-armor 2025-01-05 17:37:54.443 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select dearmor(' -----BEGIN PGP MESSAGE----- em9va2E= =ZZZZ -----END PGP MESSAGE----- '); 2025-01-05 17:37:54.443 UTC client backend[39427] pg_regress/pgp-armor ERROR: Corrupt ascii-armor 2025-01-05 17:37:54.443 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select * from pgp_armor_headers(' -----BEGIN PGP MESSAGE----- foo: em9va2E= =ZZZZ -----END PGP MESSAGE----- '); 2025-01-05 17:37:54.443 UTC client backend[39427] pg_regress/pgp-armor ERROR: Corrupt ascii-armor 2025-01-05 17:37:54.443 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select * from pgp_armor_headers(' -----BEGIN PGP MESSAGE----- em9va2E= =ZZZZ -----END PGP MESSAGE----- '); 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor ERROR: mismatched array dimensions 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array['too', 'many']); 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor ERROR: mismatched array dimensions 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select armor('', array['too', 'many'], array['foo']); 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor ERROR: wrong number of array subscripts 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select armor('', array[['']], array['foo']); 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor ERROR: wrong number of array subscripts 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array[['']]); 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor ERROR: null value not allowed for header key 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select armor('', array[null], array['foo']); 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor ERROR: null value not allowed for header value 2025-01-05 17:37:54.446 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array[null]); 2025-01-05 17:37:54.447 UTC client backend[39427] pg_regress/pgp-armor ERROR: header key must not contain newlines 2025-01-05 17:37:54.447 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select armor('', array[E'embedded\nnewline'], array['foo']); 2025-01-05 17:37:54.447 UTC client backend[39427] pg_regress/pgp-armor ERROR: header value must not contain newlines 2025-01-05 17:37:54.447 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array[E'embedded\nnewline']); 2025-01-05 17:37:54.447 UTC client backend[39427] pg_regress/pgp-armor ERROR: header key must not contain ": " 2025-01-05 17:37:54.447 UTC client backend[39427] pg_regress/pgp-armor STATEMENT: select armor('', array['embedded: colon+space'], array['foo']); 2025-01-05 17:37:54.463 UTC client backend[39431] pg_regress/pgp-decrypt ERROR: Wrong key or corrupt data 2025-01-05 17:37:54.463 UTC client backend[39431] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(dearmor(' -----BEGIN PGP MESSAGE----- Comment: dat1.blowfish.sha1.mdc.s2k3.z0 jA0EBAMCfFNwxnvodX9g0jwB4n4s26/g5VmKzVab1bX1SmwY7gvgvlWdF3jKisvS yA6Ce1QTMK3KdL2MPfamsTUSAML8huCJMwYQFfE= =JcP+ -----END PGP MESSAGE----- '), 'foobar'); 2025-01-05 17:37:54.475 UTC client backend[39431] pg_regress/pgp-decrypt ERROR: Wrong key or corrupt data 2025-01-05 17:37:54.475 UTC client backend[39431] 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-05 17:37:54.475 UTC client backend[39431] pg_regress/pgp-decrypt ERROR: Not text data 2025-01-05 17:37:54.475 UTC client backend[39431] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(pgp_sym_encrypt_bytea('P', 'key'), 'key', 'debug=1'); 2025-01-05 17:37:54.476 UTC client backend[39431] pg_regress/pgp-decrypt ERROR: Wrong key or corrupt data 2025-01-05 17:37:54.476 UTC client backend[39431] 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-05 17:37:54.476 UTC client backend[39431] pg_regress/pgp-decrypt ERROR: Unsupported compression algorithm 2025-01-05 17:37:54.476 UTC client backend[39431] 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-05 17:37:54.498 UTC client backend[39437] pg_regress/pgp-encrypt ERROR: Not text data 2025-01-05 17:37:54.498 UTC client backend[39437] pg_regress/pgp-encrypt STATEMENT: select pgp_sym_decrypt(pgp_sym_encrypt_bytea('Binary', 'baz'), 'baz'); 2025-01-05 17:37:54.831 UTC client backend[39445] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2025-01-05 17:37:54.831 UTC client backend[39445] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey)) from keytbl, encdata where keytbl.id=2 and encdata.id=2; 2025-01-05 17:37:54.837 UTC client backend[39445] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key 2025-01-05 17:37:54.837 UTC client backend[39445] 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-05 17:37:54.838 UTC client backend[39445] pg_regress/pgp-pubkey-decrypt ERROR: No encryption key found 2025-01-05 17:37:54.838 UTC client backend[39445] 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-05 17:37:54.838 UTC client backend[39445] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2025-01-05 17:37:54.838 UTC client backend[39445] 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-05 17:37:54.841 UTC client backend[39445] pg_regress/pgp-pubkey-decrypt ERROR: Need password for secret key 2025-01-05 17:37:54.841 UTC client backend[39445] 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-05 17:37:54.842 UTC client backend[39445] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2025-01-05 17:37:54.842 UTC client backend[39445] 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-05 17:37:54.845 UTC client backend[39445] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2025-01-05 17:37:54.845 UTC client backend[39445] 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-05 17:37:54.876 UTC client backend[39451] pg_regress/pgp-pubkey-encrypt ERROR: No encryption key found 2025-01-05 17:37:54.876 UTC client backend[39451] 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-05 17:37:54.876 UTC client backend[39451] pg_regress/pgp-pubkey-encrypt ERROR: Refusing to encrypt with secret key 2025-01-05 17:37:54.876 UTC client backend[39451] 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-05 17:37:54.878 UTC client backend[39451] pg_regress/pgp-pubkey-encrypt ERROR: Not text data 2025-01-05 17:37:54.878 UTC client backend[39451] 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-05 17:37:54.895 UTC client backend[39455] pg_regress/pgp-info ERROR: No encryption key found 2025-01-05 17:37:54.895 UTC client backend[39455] pg_regress/pgp-info STATEMENT: select pgp_key_id(dearmor(pubkey)) from keytbl where id=4; 2025-01-05 17:37:54.896 UTC client backend[39455] pg_regress/pgp-info ERROR: No encryption key found 2025-01-05 17:37:54.896 UTC client backend[39455] pg_regress/pgp-info STATEMENT: select pgp_key_id(dearmor(seckey)) from keytbl where id=4; 2025-01-05 17:37:54.936 UTC postmaster[39349] LOG: received fast shutdown request 2025-01-05 17:37:54.936 UTC postmaster[39349] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2896, PID: 39349 postgres(ExceptionalCondition+0x56)[0x5586b86e8da6] postgres(+0xed322a)[0x5586b82ff22a] postgres(+0xed3780)[0x5586b82ff780] postgres(+0xed4642)[0x5586b8300642] postgres(PostmasterMain+0x13f0)[0x5586b83020a1] postgres(main+0x28d)[0x5586b8136529] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7faea944624a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7faea9446305] postgres(_start+0x21)[0x5586b7cdf141]