| From: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: postgres encryption |
| Date: | 2018-03-22 09:53:48 |
| Message-ID: | 201803220953.48306.gary.stainburn@ringways.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Debraj Manna | 2018-03-22 12:45:38 | pg_stat_activity doubts |
| Previous Message | Fabio Pardi | 2018-03-22 08:26:59 | Re: Queries that are running in postgres most of the time |