Re: Error with plpython

Hello.

It is possible to upgrade without any downtime?.

Thank you.

-----Mensaje original-----
From: Adrian Klaver
Sent: Wednesday, July 11, 2012 3:01 PM
To: Efraín Déctor
Cc: Craig Ringer ; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Error with plpython

On 07/11/2012 06:32 AM, Efraín Déctor wrote:
> Hello. This is what returns the 2 servers:
>
> Production Server:
> ['/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg',
> '/usr/local/lib/python27.zip', '/usr/local/lib/python2.7',
> '/usr/local/lib/python2.7/plat-freebsd8',
> '/usr/local/lib/python2.7/lib-tk', '/usr/local/lib/python2.7/lib-old',
> '/usr/local/lib/python2.7/lib-dynload',
> '/usr/local/lib/python2.7/site-packages']
>
> Test Server:
> ['/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg',
> '/usr/local/lib/python27.zip', '/usr/local/lib/python2.7',
> '/usr/local/lib/python2.7/plat-freebsd9',
> '/usr/local/lib/python2.7/lib-tk', '/usr/local/lib/python2.7/lib-old',
> '/usr/local/lib/python2.7/lib-dynload',
> '/usr/local/lib/python2.7/site-packages']
>
> Craig: Sorry about the details.
>
> This is what we got:
>
> Production server:
> FreeBSD 8.2
> Postgresql 9.1.2
> Python 2.7.3 (default, Jul 10 2012, 21:36:33)
>
> Test server:
> FreeBSD 9
> Postgresql 9.1.3
> Python 2.7.2 (default, Mar 26 2012, 18:07:58)
>
> We tested on other server (it worked) that use
> FreeBSD 8.3
> Python 2.6.8 (unknown, Jul 4 2012, 00:49:01)
> PostgreSQL 9.1.3

Well both Postgres servers that worked are 9.1.3. From the release notes
for 9.1.3:

Allow use of threaded Python on FreeBSD (Chris Rees)

Our configure script previously believed that this combination wouldn't
work; but FreeBSD fixed the problem, so remove that error check.

Not sure if this has anything to do with what you are seeing, but it
might worth it to bump the production server to 9.1.3, if possible.

>
> Thank you
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com