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/1327500f-b4e7-4d68-84ab-c01e5017a165%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.

