Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1glb9d-0006uV-0q for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 15:06:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1glb9b-000802-N4 for pgsql-admin@arkaria.postgresql.org; Mon, 21 Jan 2019 15:06:23 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1glb9b-0007yw-Eb for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 15:06:23 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1glb9Z-000270-9E for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 15:06:23 +0000 Received: from eddie.ringways.co.uk ([10.1.1.115]) by ringways.co.uk with esmtp (Exim 4.91) (envelope-from ) id 1glb9Y-00029Z-6B for pgsql-admin@lists.postgresql.org; Mon, 21 Jan 2019 15:06:20 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@lists.postgresql.org Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 Date: Mon, 21 Jan 2019 15:06:19 +0000 User-Agent: KMail/1.9.10 References: <201901181429.51278.gary.stainburn@ringways.co.uk> <201901181642.45463.gary.stainburn@ringways.co.uk> <201901211503.23073.gary.stainburn@ringways.co.uk> In-Reply-To: <201901211503.23073.gary.stainburn@ringways.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201901211506.20023.gary.stainburn@ringways.co.uk> 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 Monday 21 January 2019 15:03:23 Gary Stainburn wrote: > After doing this the install worked perfectly. However, when I try to use > the crypt() function I get the following error. I can't see what I've > missed > > users=# select crypt('password','myhash'); > ERROR: function crypt(unknown, unknown) does not exist > LINE 1: select crypt('password','myhash'); > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > users=# [...] Content analysis details: (-50.8 points, 15.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -50 ALL_TRUSTED Passed through trusted hosts only via SMTP -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] 0.1 SCORE_RCPTS Adding score for each recipient 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 Monday 21 January 2019 15:03:23 Gary Stainburn wrote: > After doing this the install worked perfectly. However, when I try to use > the crypt() function I get the following error. I can't see what I've > missed > > users=# select crypt('password','myhash'); > ERROR: function crypt(unknown, unknown) does not exist > LINE 1: select crypt('password','myhash'); > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > users=# Sory folks, just found the answer. I need to run create extension pgcrypto; in each of my databases