Using PL/Pythonu with virtualenv

Question

I am writing function in postgres in python using the PL/Pythonu extension in postgres. I would like postgres to use my virutal environment (I am using virtualenv) instead of the global install. How do I go about doing this?

Barry Steyn · Accepted Answer · 2012-06-13 16:34:55Z

4

As it turns out, one must add the path to where the libraries are found to the PYTHONPATH environment variable in postgres. Don't forget to quote your value eg:

PYTHONPATH='path to libraries'

answered Jun 13, 2012 at 16:34

Barry Steyn

1,6033 gold badges20 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ssc Over a year ago

As described in stackoverflow.com/q/9586331/217844, this only seems to work in certain OSs. Ideally, Postgres should have a VIRTUALENV configuration setting.

Community · Accepted Answer · 2017-05-23 12:08:28Z

2

Answered over at https://stackoverflow.com/a/24892335/5430

tl;dr - exec activate_this.py inside plpython function will set python interpretor for the life of the postgresql session.

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Jul 22, 2014 at 16:18

reedstrm

3821 silver badge9 bronze badges

Collectives™ on Stack Overflow

Using PL/Pythonu with virtualenv

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related