Fwd: invalid byte sequence for encoding "UTF8": 0x95-while using PGP Encryption -PostgreSQL

From: Chaitanya bodlapati <chaitanya(dot)bodlapati4330(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Fwd: invalid byte sequence for encoding "UTF8": 0x95-while using PGP Encryption -PostgreSQL
Date: 2020-03-19 22:11:55
Message-ID: CAEBzx_hMUMdbPaWofbqmwByYnipsFR6xmVHcY_QUvdZBPMRaQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I was working on Asymmetric encryption in postgres using pgcrypto . I have
generated the keys and stored in data folder and had inserted the data
using pgcrypto encrypt function .

here the problem comes, I was trying to decrypt the data but it was
throwing me the below error

ERROR: invalid byte sequence for encoding "UTF8": 0x95

Please find the below process which I followed

Generated the keys :
CREATE EXTENSION pgcrypto;

$ gpg --list-keys
/home/ec2-user/.gnupg/pubring.gpg
--------------------------------

pub 2048R/8GGGFF 2020-03-19
uid [ultimate] postgres
sub 2048R/GGGFF7 2020-03-19

create table users(username varchar(100),id integer,ssn bytea);

postgres=# INSERT INTO users
VALUES('randomname',7,pgp_pub_encrypt('434-88-8880',dearmor(pg_read_file('keys/public.key'))));

INSERT 0 1

postgres=# SELECT
pgp_pub_decrypt(ssn,dearmor(pg_read_file('keys/private.key'))) AS mydata
FROM users;

ERROR: invalid byte sequence for encoding "UTF8": 0x95

postgres=# show client_encoding;
client_encoding
-----------------
UTF8
(1 row)

postgres=# show server_encoding;
server_encoding
-----------------
UTF8
(1 row)

Can anyone please help me on this , I am not sure why I was getting this
error.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2020-03-19 22:17:03 Re: Berserk Autovacuum (let's save next Mandrill)
Previous Message Darafei Komяpa Praliaskouski 2020-03-19 22:11:23 Re: Berserk Autovacuum (let's save next Mandrill)