| 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: | Whole Thread | Raw Message | 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) |