pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jean-Paul Argudo <jpa@argudo.org>
To: pgsql-general@lists.postgresql.org
Subject: Re: Why the index is not used ?
Date: Mon, 08 Oct 2018 10:44:22 +0200
Message-ID: <3566caf6e5e20665c48b2b9b9e61df57e21fd83b.camel@argudo.org> (raw)
In-Reply-To: <a80acc9fa5494c6b8b27d586e76ddd51@PCYINTPEXMU001.NEOPROD.EDF.FR>
References: <dd1702f0a1b74ce79ca1e380ea4e63ee@PCYINTPEXMU001.NEOPROD.EDF.FR>
	<CAFj8pRAQ1Ctv5dkO1UuehXfws83czzZXpyv=rkmb_86agPt-PQ@mail.gmail.com>
	<74090066a33740ea8fc442cc70f8afa2@PCYINTPEXMU001.NEOPROD.EDF.FR>
	<CA+bJJbxJuM4RQ=qMwQOF4Gep+y4w6a0Ym_ta7e_NBZH0p1sC2w@mail.gmail.com>
	<3a14f7f8fbda4e868b663b31e8c5fa16@PCYINTPEXMU001.NEOPROD.EDF.FR>
	<064a89d526c44d45ae43a37556c6b5f1@USFKL11XG20CN01.mercer.com>
	<a80acc9fa5494c6b8b27d586e76ddd51@PCYINTPEXMU001.NEOPROD.EDF.FR>

Dear Didier,


Le lundi 08 octobre 2018 à 08:32 +0000, ROS Didier a écrit :
> Hi Virendra 
> 	You think that outside encryption of the database is the best solution	 ?
>                How do you manage the encryption key ?
> 	Can you give me some examples of this kind of solution.
> Best Regards
> Didier ROS

If I understand your need well, you need to store credit card information into your database.

This is ruled by the Payment Card Industry Data Security Standard (aka PCI DSS).

I attend some years ago a real good presentation from Denish Patel, a well known community member.

I saw this talk in pgconf 2015 in Moscow: https://pgconf.ru/media2015c/patel.pdf

I recommend you read it, if you had not already? It shows code examples, etc.


My 2 cents...


-- 
Jean-Paul Argudo





view thread (25+ messages)  latest in thread

Message-ID: <3566caf6e5e20665c48b2b9b9e61df57e21fd83b.camel@argudo.org>
Permalink:  ../3566caf6e5e20665c48b2b9b9e61df57e21fd83b.camel@argudo.org/
Also on:    postgresql.org/message-id/3566caf6e5e20665c48b2b9b9e61df57e21fd83b.camel@argudo.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jpa@argudo.org, pgsql-general@lists.postgresql.org
  Subject: Re: Why the index is not used ?
  In-Reply-To: <3566caf6e5e20665c48b2b9b9e61df57e21fd83b.camel@argudo.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox