Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x7ZoW-00000000UVa-1EBu for pgsql-general@arkaria.postgresql.org; Fri, 18 Sep 2026 14:43:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x7ZoV-00000001cl4-2Y8x for pgsql-general@arkaria.postgresql.org; Fri, 18 Sep 2026 14:43:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x7ZoV-00000001cku-0YRv for pgsql-general@lists.postgresql.org; Fri, 18 Sep 2026 14:43:43 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x7ZoS-000000002ca-13g2 for pgsql-general@lists.postgresql.org; Fri, 18 Sep 2026 14:43:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1789742618; x=1790347418; i=karsten.hilbert@gmx.net; bh=BCTddmFkgPHygW8+NiUJYd+CawQcwcxYRsfmlQezqYU=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=Zwb7KLeATI2hU2bzMx0aGWNojW6W1HWYYK5pQdoJA7BJEOwaCywMZm6LdRJ3zd7F lfh26/o8ay+/3WYETKLF3HOpI3LZXA5OKYW9kJPmlMBVGIxqkKyagVJJIH1tV47sH q0XvowXT9SytKYXnU1d109fstnRkR8ihVr5w2cajBhOw/8M5PCJo1FyjkaBjFmERH q9Q6oNk0ioAT7vifEm/F1yFIyKFrQ7M8ct8JySI3uZTKgBIQ/ZospLdC6FypvJrZ5 uJz4/dTWwqKbnlCVoKPD1QTd3aKOWQWKE3RJbaP8guxcM7wcuK9Z9njJuYdVhSFAQ kf/l8HfR4UDBd5q4zw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1M3DJv-1x3zRX1gxZ-001TD3 for ; Fri, 18 Sep 2026 16:43:38 +0200 Received: from ncq by hermes with local (Exim 4.98.2) (envelope-from ) id 1x7ZoQ-0000000033z-0be7 for pgsql-general@lists.postgresql.org; Fri, 18 Sep 2026 16:43:38 +0200 Date: Fri, 18 Sep 2026 16:43:38 +0200 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: Error Creating pgcrypto Extension Message-ID: References: <947662.1789689902@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:2IHWOgxvyU2xFK+dhtT+X8WJnIll74QhGzJkB3fcT3olC6TIDKi 3TUQBMshbyG7Gey2r4UaGtAKi0SBPTgxbG+z1gs6q7SvAP+PNzZAH0LIPzYaGs3KCn8cwC2 ARHQs9WaclOpZmI9ToCUviJOYhI92IyMquA/9UApVrEN4xGR2Sm11hdvWz73LF3jIoV5Hxq SQs1e5N3BUTEurOw/wsyw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:THNoSKcs3yU=;QzOxbf0v1KVbqoGsXNZtSvSA389 vsiZbzMWAFQ7o9Ywo7krpBZ3ymkKBp6m5Aw2CjUFyb3/aNTYqpJLr8OT+LtNQLoyph1PtnApt yoEty3055WNF390Q+nEN35MdrehcMN97x9n5iwpdlAy0ESeuB487EZWKqiR1xFdyQjAJXmBjM 6BBJF8d7I2KNvEJT3UGx/xIE74WEf/1OlxHL122TcOsJuohksZVhrbk1/8br0hwmNFTAtj+w4 WIOqW/hkwZIDbsxI+F37sgCuZ33EOyZwnzIg5dWMRj3pwNeVmrotnda/QBgE7RqqZROiTZLu/ 37rvj6QDg5gJTBse5P1xYK3Gk1IVDqKnjvRsxGgxToEG38Y+61XPYZHSG6wMTFvisyM/XdrjP yKPoeys40VQkrYuKDOPfMhbR4i18V1l/+k084YZ0e2yKiArVKT8eL2pk5mP4sE0u5pb7UCpxk FMI9tsAW1s969VCx3HPCr9CRRt7ByVmS0yRU4JAOzrrA2C/6jGrsPFU40J1r+V7FZFfLPvwRo suZE/qNVAopBmcWvw/XJ3d+XW3dXMC6nSojyQ6x4j//jUHPJB3F8VKZnkF8Kphm9c6O5kd5Uu uue5L/hZ+fGwoRMmHTDUTbvGeOxK99kpOObY3f8lpLz9MyY1/KYluo1y6g/f1L7J/y5Yk7yWH af9BtmZQM2P5yOnJTCHUqKSEU1dcK0SCuy6LIpGI/Ruz6eoN3uHI2f1+dHeHKlQAUNYBKhgEN g/pA082zKO1ciibtvWO7d0rfXgLCPIe+ceSThLrGz7BCjCevMfvRswppkRguQkKsarVR1rsfC 1nE2HK8sAdvkiRudibCmjmTfchj1KftG+Ge44K3P12hx7yl/cfFtWDUHG4EDI9q/RkdMYvC8U fp/wPRE2OQYMdWcW5vlAKXXzTMHOgV8HkveWC1vGvnBieVU0bCSyoQTU4DO1mteN+aIW3H96o RCdpOJOgjlJbD7jmpht9hlIO98GLY0JDT59PwO1WUoDRZ383OTNaKGVz+aZmeGbQcSVfMRAKK UI0aUkIkbImtbEz0E5PkD7bBZzREEVIcpJri/n0BiPJBH/ubOcPApb9CGuYCK9hAQ6nP3es7t fIkv77CclqZJWyF/5h5G+TdChVlDpA7hTrkcw1lH4fSG+7VX0OPicaYjdPY+m4fgGuP5UdHZp zwafTHQLhfReGYwbGeAl+VfWRrhgE4Z+seNY1MOb/3Nk7F+WcsufuNmGHW68VrvvK7gu7VmW6 Bt7VgNRBnkj28KOVt4rxTmUY2YrfFXJXZ9Cv0EmeDG/RuPzBl9RVqJ62hDc1KUw98Me4m1qMB 7MPJAnFf1b9zRWf16wfULx8iR80w16u4h4STVX9ZQNKXNwqXS4vtG8rifm2/cg1qpemMmWBcM l6KYdAqy9uLRP3DY9v1oJbp3ECR+DVtGT/3iX50VD8M77M5LMHqRUHlxSKFumgx55kIP6R6S5 ZlxIBkoddcrL+hw8CkJXIHh8TaX6ilVRooziUfo1BaRTVd6QLsXKPkFg8mBPOuP51pXsn5BfK vc4FwbmEB91sAuCn+j60R5Hl/2aUcVs56Ucy7tdZeVVGDgufhiMNrjg5HrKjxBhRGCrxYTy0h SzDFekPmayca/0Mm/OjXrWFHK5/nKADojoGJDCHUvkVNTyZzUf5VVnugMcGzrM7q0IIRjHY89 rDXYn7rvY/Dg5qsJw1JEX/iYiItsHE7dnNSOBQvHSG51f8mlom119OTOs39XTZ+uDdbzwBMgE PYz1mB0oSGIUpwqfPGXt2jDElwYqgwaqMMz+czugzCAtqHxiXNIOqeHFwJrs1OEhney7WoYY2 mJs4QzP1n/QJPlwwYvZxKO8DPSMoGGDIS1o5TqalIKIdgpTpWWy4ntJNkaYFuaYxIxXgnDUwX UQfEKWetzdjaUGqa61NFZv/QtfYDJnz9siKNHKkBVpj4Rs8LSA93gqg9W2brDOYvKLODApkeT pp93nIkCK9VYUiZ1xlsc8Dse9BfGVgDcvErxwXFenGewNK2gultzYeheVJT2F7Pgs0bLbIvS7 pHWS14B0KX3rd0eX1JUn9uXFho0ngdsdQg28ewD4DoH7RRcSxKH2PNsyB28SzBkDlB9YuxyC9 FvvjrWbA33NQE/u45VFoxl3hHPZeizVNHf33qvckHjBsZy0oX1lTRUXg1HK8tiScxJcyfj5sv 28wHte9hkwVsaQWNhmqLJrKT/LOMnv6dYTj2L8wqXLXnIyjPGlquTeFFpxrIo+0C0XHPT49Es HmVxvmM+8KlPSK48ElC2NXFSW7R7GHboAgPMh45yyYONl/X/cDH4E8qPdafaeHCxItV1XtAM8 O6sQy8t/Prx+ipthdPPcQ28AqUcYSgDmxVxhLODVbU8OIuH8Vg4ZWn7t28JfhGsBNG7EgTQQT i5EgOZILzRbIpnxzD84Cf/9nVqrgpgxyEkIOFW7RVdf76Lcb232aaiuAgDS2oKu1bz+sy/ILz 1JLKSv8oJjDMhm9Q8LP1LeKDA9nojPOfBAdFTpFuVeJKrIKbjePUoNAGuLJRKCOWLhKUDjHTZ QSx7O378bMHHumhfc/GuK8Had55Ms1WYOZrqcYI7rDodZ9boA7cgL7TA939InyEj8rvMGTSYz NIGA6Hp4Tf3U8wwNiN9r4R5Fq+0agMxZnqxShWYHulCB2aES5PLvXayZeoLia1diqAhA/16U4 cUbbsC9GP7H0sigBlhPIbYZigN6vbqzqeHFkgEWbwph+RVtMqe88u8GwXXeHJoEymTsGj4kNF 9/F0TM7m+xyb0pJ9+IFu8uBboUBGb+jRBzRMbcFpVdFuCfDzpEMohkzb5lz1IleQLRgjp/fSV o0Z7s+oyJH3CvtNLFuWzBE2gJpS3RJhUwgIHtu0SZXprcvAoomrgAW3hPJn5cJ3bh3Z4GQKQn 4M7Bq+ZKaFmtvcOoqxzCZV8ryx+42IWllVxmWlzLkU6g9fLABjnlcHWuzN9aEnwQPIur6DYRk mpZMX6r3LHcisqPoxO+bPISGR3XZrG0hXu1W2L0ehEXsWkHopBfw5jwCUQ7C8HfgIKcn7lMox W0pJlS10wIckQ0Pv8pztWUnXIn0039gue9MKj5W1yRZyNLgK7mdwZcVV6kEKLTODhSUO4rosc k6zOXur49wavPpErEHhokivVLPs/xuYHvckJj2BFF85iOdWVULtuASJn7Vva27EYMNpKPUYFX etofeTsa+uCkxgAhYga2XtXDhi3I7CseYfID9NgLp9KGt3LncBVV72mLq3Vpt64BspV8khjev dVPcIYgy059Cq49lUKKWw2A0wzgHMkXIuGB+2NIYvjs3rXH1zT09305VsCBr06urOfY0xuFhc hG8YpMqBvzHFO74VVazsAJVU5H/D2k9vp1vdjmbol7WJNkQ6AFB73VsvWiooYQTiCjv6ghhWx FNwwX7Z/KJBKvsVcvIubLbPu6UeSEJIRt94mQvGoYIJplvlr7+iA6NeLdEBg9857jL9G7f9/T gWzvMHzu5l7D6vQBGASmEWcQqv+550HY2wNjBICsXSXAiiQxACx4VjGhAcUB/b3tq3N6jm4Gf wImTIc+zdQ6t+o5zyJ5roLz6J5jGNY0IwACJK0Wav3OQHkqtKvAjx1CkL5Uc7cV6yfsol9xB1 qRP8Qb95MoTEM3pl0+lbDR2Ja4Ge0m5nD+ZWGGFlqNQoKDWIQIMt6bbAfuzQqFOn7dszHmBf7 jyTu8v2VAYvxq31BVNDVHqZWIfWHrxVSJ43UcgOof6Xc5AtP2N+GS6hINtGUbOV/QpnWZhQFR FD4dm7n03I1oiHaCuNKZAgy/DC4Z9M7YnHitodrMwUyE0iCfL5pHh/zAWbNgR6hEKdZ6aBQbW KKzdfY8xwGAtzCzoy59wh5vWf/du7xM8v5CQPPgt0ef9WlhIdDySG563ewtETjnO4vQdWy6sX LmEzI0zjLIkikLZqaWe5+yywjUfY7WpfSar3/buu+R4N8kQuqd2p0aBPq9ckaCZdp7g/o4U2r YNnnsddvvLoxW3uzYfj3xExdSAehBkN5atjXTbevgOelbzaerZrr16uUGzd3T8eMHTzaOrGJx /nUn6fyr4WmEGoNUWcJTllPRBU8d8465JX/k3pPM9aArLnfraki+dz4Nh4AD9OOzpHXsGkc2Q IYunHrmBBzB3lN73XuHHDyrBneSUTfpstUnplbtHreV4RQKEE39uOP99y01TPBFqTwXcJ350c s9e9jaDxRyd/5RFwP5y2v+qJJvBTfugLaIhb8/Loin3RXUWL4DNO/kQmb0bLf/3b1WjP+QJEb YQG67rdD6r1w5AXvbJnf7NqXO7r8D05LlaigP1a0/lE98Ii+dRQF13Ek6J0n6ofRmMGxz7HZl XN5MNUWjZrly2GEIEHwa3Uge6khNvCuOY/SXpDbRYjCfk2dQ4UjFuBBMoOvJUZkhdaBs7lOau AabMZWCdtbpwCE7ZpFOnMiyRFzsH8lWqojgkivnc9SRj12n0N3RheS6xLo+yDQ/nAkH5ly/Cd cI+/E4NrFugXzyzxICK3T9qE+RVcX9V+1vfZTvB7HxLbPMOcTCn+FYbXmcvs3XaVRb+8SxY1X PxbqGFJgAoRYD+u4bz/b2YY02HaXf/yayL3nsiv5dpZ3/YZ8hfW2AKuLvHMWhEow1WTnYfShN l3DIqnQRA2HWqRhVSSZcIyvqFa88fbQHw2A0Rv+Rkh5a+5JP163naKICEi/J3OrRWLE672Pai C/rbfy2l6rX7l4wsSPJLOFpWKnp4VMKGUzo5B9jTlvkMr6e+o+8gr1leGgRoEfaS4iGkxQF/n gmp9miZn5bfyfqjLPbfwjUV6di22Xl/5lat50KWRUDu9VQcKh/pX5jmuOt0FzuMXGFy6MoWE9 jQD1v22V8h4UJq7deT9nF1aq7hWaQ7jKpvHnnRJaED3DAUm88scz560ygEBy4aSkCWi2F1fcC kBLaWLoHAIc1AdN817fKaQCugvDUpyYQPzxqM/tCQa18GuwxGaRXUW6OwV3hl9Jg6I51l5E1M CU3Q+SUqW1KIhYa34VHT0FYp/y8BXVGn7Iqc2cSRJSATW/++QvUIfURmtFGT+NNP6GNLdpcRs KA2KVhDi/JfdtoZ5Ka3n1uxRoCO4MZCldfW5XcedojiPez+aaCGHRoTAUfdzLKSo1LqCpzkUs KdqjYUkuGjd0sLnxyopkNXMyqX6GrU4/clIJh8nkDVXKtqSD7x+IWNbpkOz0eOrqlpuKBel4B Tnq3guu7BM4v2C1jU7+s0UKKc67VOesnC+wH51ForaC/udi/rh+KzJggis27YhfKnO1yAg+AK 9KDeQlTY0vug2Os11apl6UMlT2lkzn7F4AQ8j1aTBD4VQv5yr26q/r0O9CffHd/3+iPvra2d5 COUFN3fdLA5Ws/O2z+ZFoJtV1fjkAmvvEF8u5akilCVgomLNDOyJo7TPyK10+0EGOwqSjljOK dmEeRJLpl9gVeaql5nPpYoUdQM/eO11uDVWB4uIyJUjyaFuQOSJluUpWHbybjwvuMKxHei8IF W99sJ+WHYWc8AxQmHdmAithtCi5AyGzvYfFSFAhPTgT0tRZKu6J2vS46JSiDy6YEuMQlg7rJj 6tQHdaWqmGqv1lI9RJ8nipX6/ghrNG7L6QCAPqnUW8on8Knt7UNINYkwtKti0nbYeMY/n6RvS jlA8uX2pBr6+tAzVwQ2v4LM2JZxieq819mZsjnGEW1GrZ7TzgYHvQcdztuIEuemJdmP6+Gqwq kC69CBb93l6tVnWQpQkzR7bZvPCXhwnujus0/kPhAW6WvwJc82tFRuIVGfjleAJ3Nrqwtfb4y nu+QlBTin7wQXkOP4OPX9bPb7AP1VCqrfiBd7DECG/oyJn0qUQreakhKVL0PlJsRrskBQ7EMJ KOCyTXmTTP5+hDwNj88MXOOyJjOtacaQnPw2w7S36jjm8SLW/QlsToIF6K3+/c6MpOtPk9OZV aXVNLhYry0i0KXE9b2SlnkBVbavJ8N9AzyMdL4lA7h+AWRAHccj4aY024Mp7kqiJlJPR9/L9D j4y4ringMDwbryFf8a6dSSKOI2zBF0f0hYVDNOIiPVUAwCnl0oM7QAesOL Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Fri, Sep 18, 2026 at 02:33:33PM +0000 schrieb Phil Rau: > The question now becomes: Is there a way to set up an instance such tha= t any new databases created underneath it automatically get a given extens= ion (in this case pgcrypto)? What is the best practice to do this? Isn't the canonical way for that to install it into a template database from which new databases get created eventually ? Karsten =2D-=20 GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B