Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mhiyZ-0002Ki-7K for pgsql-admin@arkaria.postgresql.org; Tue, 02 Nov 2021 01:52:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mhiyW-0005xO-9h for pgsql-admin@arkaria.postgresql.org; Tue, 02 Nov 2021 01:52:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mhiyV-0005xF-Ti for pgsql-admin@lists.postgresql.org; Tue, 02 Nov 2021 01:52:32 +0000 Received: from mail-ot1-x331.google.com ([2607:f8b0:4864:20::331]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mhiyT-0001Jl-O8 for pgsql-admin@lists.postgresql.org; Tue, 02 Nov 2021 01:52:30 +0000 Received: by mail-ot1-x331.google.com with SMTP id s23-20020a056830125700b00553e2ca2dccso23044083otp.3 for ; Mon, 01 Nov 2021 18:52:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=xiIqH2l1Zz/v7YsgFKDjWDaFjMR31b+hr/ClCsMX5RY=; b=dUCz06Y4akXSmwKglmgIdTXhA9HRQcc49A/NdG9pMK+DjFiRjxP34cjiESKwxHKHBA EPAcj3QvZ1b92al4HsBRUC5aMwbMBtkow/cu0j3f+DWYSoQmMDN3QG3QQeFo/WkGGtOE qiLLnkpeX8RoMlxIzkPCA8u1JSrF7Fv8eDLF/FgFb0fg9C9WjNaLdDd+BUno3iEsBm3w PfhDTmVJFVaIKpWLebvkoMSngmeQIfOeDwXHM5TNk/DEKFG/t/724ovyYOFUSwWtt+DW PSokjvHbbhWQfBxoue6uu6ZH9kkfw847jFjCVHuo/Bx66wq7hu4ebJ/6WTeu06jRHsW4 DZxQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=xiIqH2l1Zz/v7YsgFKDjWDaFjMR31b+hr/ClCsMX5RY=; b=r2Q7jnqjOGOkjaGLcpzuetfQZdE0F5sGv2nx+MysIgF/eUke6uxv9+3bml8E7EkGXW jB3XVIcHvfLU0fGVKLshJ98f3hctLeQUH+JJSwfoFbxSNXUl7JPqFcfQg0DxNu4SvNY9 syPA7Ggu/nEmAceVd1eBJLJ5aHg3Xo4uJ9BGpc5hACsON6rsBEb/wwbT/DvDBPbaJWMS fvr1eLZSZgECiY8JKR0dvSbcFH7skgEEt0MwHIj1nrdlDwKiLDeAzykS80rEG5W7/l34 k0WYrCjHqejMey03J6UL4HdA3dfwTnkv7c5n3D+88PG0sldNvFZfhKmIowcqCscy5OBa bFRg== X-Gm-Message-State: AOAM53330CNejVUgvglM2QzC4QEwkDgsTfkWpBjo8q+wVjPO6bcl5JSm /ewy8tMyORiPnlMe2zqOcKz68NW1T6U= X-Google-Smtp-Source: ABdhPJzgftsLoGv6XOvJytijg/KHepXLpBpGJcshDz4AKwTKDzmCq/F5dhAH8OuNuOz2SZz8SHG84A== X-Received: by 2002:a9d:6010:: with SMTP id h16mr8762800otj.108.1635817948854; Mon, 01 Nov 2021 18:52:28 -0700 (PDT) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id w12sm773101ott.35.2021.11.01.18.52.28 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 01 Nov 2021 18:52:28 -0700 (PDT) Subject: Re: How to control which Python interpreter Postgres uses? To: pgsql-admin@lists.postgresql.org References: <1311504.1635804203@sss.pgh.pa.us> From: Ron Message-ID: <3ad0a272-3ed1-3a9b-dfd3-22157283e278@gmail.com> Date: Mon, 1 Nov 2021 20:52:27 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------D16F5EA01341B11E4E58D382" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------D16F5EA01341B11E4E58D382 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Why would recompiling Python affect what Postgresql points to? On 11/1/21 5:06 PM, Ni Ne wrote: > Would I recompile the plpython package or postgres itself? > > ---------------------------------------------------------------------------- > *From:* Tom Lane > *Sent:* Monday, November 1, 2021 4:03 PM > *To:* Ni Ne > *Cc:* pgsql-admin@lists.postgresql.org > *Subject:* Re: How to control which Python interpreter Postgres uses? > Ni Ne writes: > > How can I adjust my postgres settings to tell it which Python > interpreter binary to use? > > You'd have to recompile plpython against the particular libpython > you want to use. > >                         regards, tom lane -- Angular momentum makes the world go 'round. --------------D16F5EA01341B11E4E58D382 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit Why would recompiling Python affect what Postgresql points to?

On 11/1/21 5:06 PM, Ni Ne wrote:
Would I recompile the plpython package or postgres itself?

From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Monday, November 1, 2021 4:03 PM
To: Ni Ne <nineoften@hotmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: How to control which Python interpreter Postgres uses?
 
Ni Ne <nineoften@hotmail.com> writes:
> How can I adjust my postgres settings to tell it which Python interpreter binary to use?

You'd have to recompile plpython against the particular libpython
you want to use.

                        regards, tom lane

--
Angular momentum makes the world go 'round.
--------------D16F5EA01341B11E4E58D382--