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 When I check pip's version pip --version gives pip 18.0 for /usr/.../pip (python2.7) and sudo pip --version gives the 9.0.3 not found message. What can I do now? (AWS Linux, up to date, OS_VERSION says "2018.03") /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/a2d7f346-a200-4095-ab67-bac2b1700319%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
