From: | Chaitanya bodlapati <chaitanya(dot)bodlapati4330(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | invalid byte sequence for encoding "UTF8": 0x95-while using PGP Encryption -PostgreSQL |
Date: | 2020-03-19 20:28:30 |
Message-ID: | CAEBzx_gmHgcOg8SALUZv5S+8QcQWwvwUN7jZFZoLUQA9xSQpqA@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 | Justin Pryzby | 2020-03-19 20:29:31 | Re: error context for vacuum to include block number |
Previous Message | Jeff Davis | 2020-03-19 20:16:26 | Re: Make MemoryContextMemAllocated() more precise |