Encrypt geometry data in postgres

Question

I have a column with geometry data in postgres DB with postGIS enabled.Please help me with a way to encrypt/decrypt that column.

postgresql.org/docs/9.4/static/datatype-geometric.html - the column that i have can contain any of the geometry types. I need a way to encrypt the data while writing to the DB and way to decrypt it while reading the same data back

Thanks in advance

You need to give us more details, and the overall context could help. As such, I'm afraid your question cannot be answered. — kebs
– kebs, Commented Jul 28, 2015 at 11:02
postgresql.org/docs/9.4/static/datatype-geometric.html - the column that i have can contain any of the geometry types. I need a way to encrypt the data while writing to the DB and way to decrypt it while reading the same data back. — Karthik Ramiah
– Karthik Ramiah, Commented Jul 28, 2015 at 11:26
No no, I meant by editing the question (clic on "edit"), adding details in comments is not the correct way, the question must be fully understandable without the comments. — kebs
– kebs, Commented Jul 28, 2015 at 13:49

ByteWelder · Accepted Answer · 2015-07-28 14:24:23Z

1

There are several options:

PostgreSQL encryption

This can be done on many levels:

Encryption For Specific Columns
Data Partition Encryption
Encrypting Data Across A Network
etc.

Source

Application-level encryption

Encryption:

application: has geometric data into intermediary format (e.g. JSON)
application: encrypts intermediary format into binary data
application: persists binary data to database

Decryption:

application: reads binary data from database
application: decrypts binary data into intermediary format
application: now has usable geometric data

answered Jul 28, 2015 at 14:24

ByteWelder

5,6242 gold badges41 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Encrypt geometry data in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related