From: Gary Stainburn <gary.stainburn@ringways.co.uk>
To: pgsql-admin@lists.postgresql.org
Subject: Re: postgres encryption
Date: Thu, 22 Mar 2018 09:53:48 +0000
Message-ID: <201803220953.48306.gary.stainburn@ringways.co.uk> (raw)
In-Reply-To: <CAPecLkDA_hbCcyxS18FE+n9vJ6V-8ARmzK2VUQ5YZ0ELoEAA7w@mail.gmail.com>
References: <CAPecLkDA_hbCcyxS18FE+n9vJ6V-8ARmzK2VUQ5YZ0ELoEAA7w@mail.gmail.com>
On Thursday 22 March 2018 07:11:13 dbx postgres wrote:
> Hello Admins,
> I have a table in which one of the password column is encrypted. Is there a
> way I can decrypt or know what encryption type was used on the column to
> decrypt this password. I tried overriding this password with a new value
> but that value is being stored as plain text ad not encrypted. So my
> authentication is failing. How can i override this password ?
>
> Thanks in advance !
Hi
Purely a guess, but if you store a plain text and it appears in the table as
plain text, then the encryption is done at application level.
In order to work out what type of encryption is used, and *if* it can be
decrypted you would have to look at that program.
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-admin@postgresql.org
Cc: gary.stainburn@ringways.co.uk, pgsql-admin@lists.postgresql.org
Subject: Re: postgres encryption
In-Reply-To: <201803220953.48306.gary.stainburn@ringways.co.uk>
* 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