On 07/11/2012 09:32 PM, 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)
Interesting that your production server has the oldest FreeBSD and the
newest Python. I'm still suspecting a library mismatch of some kind.
Is there anything vaguely informative in PostgreSQL's log files after
the error? I'm hoping for a message from Python about a dlopen() or
dlsym() error, or for a message from the dynamic linker.
If you redirect the postmaster's stderr to a file, it's possible dynamic
linker messages might appear there but not be captured by Pg for
logging. I don't see how you'd redirect that without stopping and
starting the server, which you don't want to do.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
