Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eywuw-0002mB-MP for pgsql-admin@arkaria.postgresql.org; Thu, 22 Mar 2018 09:53:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eywuv-0008RW-Kf for pgsql-admin@arkaria.postgresql.org; Thu, 22 Mar 2018 09:53:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eywuv-0008RJ-DX for pgsql-admin@lists.postgresql.org; Thu, 22 Mar 2018 09:53:53 +0000 Received: from hub.ringways.co.uk ([88.211.105.30] helo=ringways.co.uk) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eywus-00024Q-OO for pgsql-admin@lists.postgresql.org; Thu, 22 Mar 2018 09:53:52 +0000 Received: from eddie.ringways.co.uk ([10.1.1.115]) by ringways.co.uk with esmtp (Exim 4.89) (envelope-from ) id 1eywuq-0000jE-Hd for pgsql-admin@lists.postgresql.org; Thu, 22 Mar 2018 09:53:49 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@lists.postgresql.org Subject: Re: postgres encryption Date: Thu, 22 Mar 2018 09:53:48 +0000 User-Agent: KMail/1.9.10 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201803220953.48306.gary.stainburn@ringways.co.uk> X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 122769 [Mar 22 2018] X-KLMS-AntiSpam-Version: 5.7.102.0 X-KLMS-AntiSpam-Envelope-From: gary.stainburn@ringways.co.uk X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Info: LuaCore: 116 116 b2a1731c58eb95775fc85f6609ada01d59e91a6a, {msgid_created_by_recepient}, eddie.ringways.co.uk:7.1.1;d41d8cd98f00b204e9800998ecf8427e.com:7.1.1;127.0.0.199:7.1.2;ringways.co.uk:7.1.1, DmarcAF: none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2018/03/21 15:11:53 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2018/03/22 00:21:00 #11332413 X-KLMS-AntiVirus-Status: Clean, skipped X-Spam-Score: -50.8 (--------------------------------------------------) X-Spam-Report: Spam detection software, running on the system "ollie2.ringways.co.uk", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see Gary Stainburn for details. Content preview: 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 ! [...] Content analysis details: (-50.8 points, 15.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -50 ALL_TRUSTED Passed through trusted hosts only via SMTP 0.1 SCORE_RCPTS Adding score for each recipient -0.0 T_RP_MATCHES_RCVD Envelope sender domain matches handover relay domain -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] 1.0 RING_SAFE No description available. X-forward-disable: yes List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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.