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.
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) |