Hi Dave, I've faced the same problem trying to add psycopg2 on MacOs binaries with python 2.7. Following some advices, I've resolved it by installing unixodbc (with brew) before it.
I hope it helps, Nico Il giorno sab 1 giu 2019 alle ore 00:09 Dave S <[email protected]> ha scritto: > Help! > > /dps > > On Thursday, May 16, 2019 at 6:37:42 PM UTC-7, Dave S wrote: >> >> >> >> On Wednesday, May 15, 2019 at 10:26:39 AM UTC-7, Dave S wrote: >>> >>> >>> >>> On Monday, May 13, 2019 at 3:48:39 PM UTC-7, Dave S wrote: >>>> >>>> >>>> >>>> On Monday, May 13, 2019 at 2:31:33 PM UTC-7, Dave S wrote: >>>>> >>>>> When I check Last week I ended up making the move to Postgres on the >>>>> busier of my production servers, and the changeover appears to be >>>>> successful (imported existing data via CSV). I was interested to see that >>>>> the import preserved some gaps in the id field, and that Postgres was >>>>> filling some of those gaps and holding off on using id's above the >>>>> imported >>>>> max(id). But I'm also getting errors about 'ERROR 23505, duplicate key >>>>> value value viotlates unique contraint "updreq_y_pkey". Key(id)=(23681) >>>>> already exists.' >>>>> >>>>> Looking at this made me realize I was running pg8000 (still supplied >>>>> in contrib in 2.15.4), and I wanted to switch to pscyopg2. So I tried >>>>> pip install psycopg2 >>>>> >>>>> and that was progressing fine until it got to copying the built module >>>>> into /usr/lib64/python2.7/dist-packages/psycogpg2 -- permission denied >>>>> (not >>>>> too surprising). So I tired the obvious: >>>>> sudo pip install psycopg2 >>>>> Which ends abruptly with >>>>> [traceback excerpt] >>>>> The 'pip==9.0.3' distribution was not found and required by the >>>>> application >>>>> [...] >>>>> >>>> >>>> >>>>> What can I do now? >>>>> (AWS Linux, up to date, OS_VERSION says "2018.03") >>>>> >>>>> >>>>> >>>> >>>> Okay, I found the -t option, and from the web2py directory specified >>>> site-packages >>>> Now, how do I get web2py.py to find the driver? >>>> >>>> >>> Is site-packages the wrong location? >>> >>> That's web2py/applications/myapp/site-packages >> >> /dps >> >> > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/b2aecb42-d28c-42a7-84fe-1de80100f735%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/b2aecb42-d28c-42a7-84fe-1de80100f735%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAAE8D_AUFZhDw4ZSh9%3DsEvR8hKn9DA8%2BtOwRu53ACiaSgdRjCA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
