PostgreSQL

04 October 2024 09:59

If it's a message, just reply /report to it.

If it's a user, share us the username and why (in PM or here)

PostgreSQL

04 October 2024 09:56

Any one has postgresql DBA resume please share with me 🙏🙏

PostgreSQL

03 October 2024 23:26

in every important group there’s an Italian guy with an high social status such as admin or someone who replies frequently to people

PostgreSQL

03 October 2024 20:24

I am looking for postgres expert who provide issue based assistance

PostgreSQL

03 October 2024 10:07

Any one has postgresql DBA resume please share with me 🙏🙏

PostgreSQL

02 October 2024 05:15

Looking postgresql proxy support in Texas

PostgreSQL

01 October 2024 23:10

Props to all working hard to make this work 👏

PostgreSQL

01 October 2024 19:28

Ok then how can I restore database if any issues occur. Can I get the database in local

PostgreSQL

01 October 2024 17:45

U can schedule it on AWS to take snapshot daily at ur preference window

PostgreSQL

01 October 2024 16:37

You accidentally just pointed out the main problem of the topic. And the reason why so many snake oil approaches are out there...

People finding *working* with encryption "too complex" get to decide the encryption architecture. Which usually results in "solutions" that "tick the box", make everyone's life harder, but don't improve the security at all. Adding insult to injury, it costs development time which then is missing in e.g. implementing proper session handling etc.

And at some point some millenial (sorry, youngsters, no offence! 😉) decides that it's much more comfortable to just cache everything (s)he gets from the DB in a text file in an S3 bucket or something like that.

PostgreSQL

01 October 2024 15:47

I did it on database level though

PostgreSQL

01 October 2024 15:39

The "Caveats" and "Approaches to Avoid" paragraphs there are pretty important... maybe read them first, might make you think about if encrypting columns is really what you want.
My NSHO is that the time and money is better spent for implementing proper security, esp. in the frontend application...

PostgreSQL

01 October 2024 15:34

GNU PG (GNU Privacy Guard) tool, gpg in generating the pair of keys if you opt for encryption using keys whether asymmetric or symmetric, then use the pgcrypto extention on the database

PostgreSQL

01 October 2024 12:36

That's a very complex topic. Partly because there's metric tons of snake oil "solutions" out there.

Check out https://www.youtube.com/watch?v=guoXpBBo8qc

PostgreSQL

01 October 2024 11:36

Thanks a lot . It worked now

PostgreSQL

04 October 2024 09:58

how should I report someone in this group

PostgreSQL

03 October 2024 23:26

im proud of my country

PostgreSQL

03 October 2024 21:37

WTF just happened here?!?

PostgreSQL

03 October 2024 18:03

I'm looking for an online trainer postgresql & Ms sql please let me know any leads thank you

PostgreSQL

02 October 2024 18:10

Yes, I agree. This is a perfect case for Public Key/Private Key Encryption. We have a trigger that encrypts some columns (non searchable) with the Public Key.

Only some users, running the client, have access (without knowing it, even) to the Private key, and they can forcibly decrypt a field (or in some cases it can be transparent to them).

Having that in the client that takes good care of the Private key is great. The data is always safe. And the existing security system in the client application can revoke the decryption feature from specific users.

PostgreSQL

01 October 2024 23:11

What help do you need?

PostgreSQL

01 October 2024 23:08

I was sad that bitemporal tables couldn’t ship in v17, but this helps. I at least understand why now.

PostgreSQL

01 October 2024 18:56

Hi All ,
please let me know if anyone can provide Support for  MSSQL& postgresql

PostgreSQL

01 October 2024 17:02

Hi guys

How do we manage database backup in cloud postgresql (AWS aurora)

PostgreSQL

01 October 2024 15:51

Some of developers they are completely not aware of this and find it too complex to use the key within the application layer and to have their code embedded with keys and functions all over. I mean it is already applicable to have this on the database level and to automate that by having triggers or so

PostgreSQL

01 October 2024 15:46

... which may very well include encrypting data in certain columns, but on *application* level. ☝️

PostgreSQL

01 October 2024 15:35

How to Encrypt Data Columns in PostgreSQL | Vultr Docs
https://docs.vultr.com/how-to-encrypt-data-columns-in-postgresql

PostgreSQL

01 October 2024 15:28

How would you use that in postgresql?

PostgreSQL

01 October 2024 12:19

Hi everyone.
I need some information about
Row level encryption any concept in postgreSQL. Please guide me or provide document if available

Advance
Thanks lot

PostgreSQL

01 October 2024 11:33

If you want your query to be case insensitive, use ILIKE