View Code? Open in Web Editor
NEW
An Ansible role for installing libraries that support PostgreSQL Ansible modules.
License: Apache License 2.0
ansible-postgresql-support's People
Stargazers
ansible-postgresql-support's Issues
As this role depends on azavea.python
, it uses python 2. Update to support python 3.
Install PostgreSQL driver for Python
step fails with unable to execute 'x86_64-linux-gnu-gcc': No such file or directory
.
Explicitly install gcc
as a build dependency.
TASK [azavea.postgresql-support : Install PostgreSQL driver for Python] ********
fatal: [database]: FAILED! => {"changed": false, "cmd": ["/usr/local/bin/pip2", "install", "psycopg2==2.6"], "msg": "stdout: Collecting psycopg2==2.6\n Downloading https://files.pythonhosted.org/packages/dd/c7/9016ff8ff69da269b1848276eebfb264af5badf6b38caad805426771f04d/psycopg2-2.6.tar.gz (367kB)\nBuilding wheels for collected packages: psycopg2\n Building wheel for psycopg2 (setup.py): started\n Building wheel for psycopg2 (setup.py): finished with status 'error'\n Running setup.py clean for psycopg2\nFailed to build psycopg2\nInstalling collected packages: psycopg2\n Running setup.py install for psycopg2: started\n Running setup.py install for psycopg2: finished with status 'error'\n\n:stderr: DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7. More details about Python 2 support in pip, can be found at https://pip.pypa.io/en/latest/development/release-process/#python-2-support\n ERROR: Command errored out with exit status 1:\n command: /usr/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'/tmp/pip-install-kSAGVZ/psycopg2/setup.py'\"'\"'; __file__='\"'\"'/tmp/pip-install-kSAGVZ/psycopg2/setup.py'\"'\"';f=getattr(tokenize, '\"'\"'open'\"'\"', open)(__file__);code=f.read().replace('\"'\"'\\r\\n'\"'\"', '\"'\"'\\n'\"'\"');f.close();exec(compile(code, __file__, '\"'\"'exec'\"'\"'))' bdist_wheel -d /tmp/pip-wheel-3Ug2GM --python-tag cp27\n cwd: /tmp/pip-install-kSAGVZ/psycopg2/\n Complete output (47 lines):\n running bdist_wheel\n running build\n running build_py\n creating build\n creating build/lib.linux-x86_64-2.7\n creating build/lib.linux-x86_64-2.7/psycopg2\n copying lib/tz.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/_range.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/pool.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/extensions.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/extras.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/psycopg1.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/errorcodes.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/_json.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/__init__.py -> build/lib.linux-x86_64-2.7/psycopg2\n creating build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_lobject.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_psycopg2_dbapi20.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_types_basic.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/dbapi20.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_copy.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_bug_gc.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_transaction.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_cursor.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_dates.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_types_extras.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_async.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_notify.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_green.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/testconfig.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_extras_dictcursor.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_module.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/testutils.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_quote.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_bugX000.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/dbapi20_tpc.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_with.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_cancel.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/__init__.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_connection.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n running build_ext\n building 'psycopg2._psycopg' extension\n creating build/temp.linux-x86_64-2.7\n creating build/temp.linux-x86_64-2.7/psycopg\n x86_64-linux-gnu-gcc -pthread -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fno-strict-aliasing -Wdate-time -D_FORTIFY_SOURCE=2 -g -fdebug-prefix-map=/build/python2.7-PPrPZj/python2.7-2.7.15=. -fstack-protector-strong -Wformat -Werror=format-security -fPIC -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION=\"2.6 (dt dec pq3 ext lo64)\" -DPG_VERSION_HEX=0x090513 -DHAVE_LO64=1 -I/usr/include/python2.7 -I. -I/usr/include/postgresql -I/usr/include/postgresql/9.5/server -c psycopg/psycopgmodule.c -o build/temp.linux-x86_64-2.7/psycopg/psycopgmodule.o -Wdeclaration-after-statement\n unable to execute 'x86_64-linux-gnu-gcc': No such file or directory\n error: command 'x86_64-linux-gnu-gcc' failed with exit status 1\n ----------------------------------------\n ERROR: Failed building wheel for psycopg2\n ERROR: Command errored out with exit status 1:\n command: /usr/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'/tmp/pip-install-kSAGVZ/psycopg2/setup.py'\"'\"'; __file__='\"'\"'/tmp/pip-install-kSAGVZ/psycopg2/setup.py'\"'\"';f=getattr(tokenize, '\"'\"'open'\"'\"', open)(__file__);code=f.read().replace('\"'\"'\\r\\n'\"'\"', '\"'\"'\\n'\"'\"');f.close();exec(compile(code, __file__, '\"'\"'exec'\"'\"'))' install --record /tmp/pip-record-iJpHrB/install-record.txt --single-version-externally-managed --compile\n cwd: /tmp/pip-install-kSAGVZ/psycopg2/\n Complete output (47 lines):\n running install\n running build\n running build_py\n creating build\n creating build/lib.linux-x86_64-2.7\n creating build/lib.linux-x86_64-2.7/psycopg2\n copying lib/tz.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/_range.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/pool.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/extensions.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/extras.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/psycopg1.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/errorcodes.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/_json.py -> build/lib.linux-x86_64-2.7/psycopg2\n copying lib/__init__.py -> build/lib.linux-x86_64-2.7/psycopg2\n creating build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_lobject.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_psycopg2_dbapi20.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_types_basic.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/dbapi20.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_copy.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_bug_gc.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_transaction.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_cursor.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_dates.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_types_extras.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_async.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_notify.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_green.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/testconfig.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_extras_dictcursor.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_module.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/testutils.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_quote.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_bugX000.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/dbapi20_tpc.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_with.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_cancel.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/__init__.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n copying tests/test_connection.py -> build/lib.linux-x86_64-2.7/psycopg2/tests\n running build_ext\n building 'psycopg2._psycopg' extension\n creating build/temp.linux-x86_64-2.7\n creating build/temp.linux-x86_64-2.7/psycopg\n x86_64-linux-gnu-gcc -pthread -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fno-strict-aliasing -Wdate-time -D_FORTIFY_SOURCE=2 -g -fdebug-prefix-map=/build/python2.7-PPrPZj/python2.7-2.7.15=. -fstack-protector-strong -Wformat -Werror=format-security -fPIC -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION=\"2.6 (dt dec pq3 ext lo64)\" -DPG_VERSION_HEX=0x090513 -DHAVE_LO64=1 -I/usr/include/python2.7 -I. -I/usr/include/postgresql -I/usr/include/postgresql/9.5/server -c psycopg/psycopgmodule.c -o build/temp.linux-x86_64-2.7/psycopg/psycopgmodule.o -Wdeclaration-after-statement\n unable to execute 'x86_64-linux-gnu-gcc': No such file or directory\n error: command 'x86_64-linux-gnu-gcc' failed with exit status 1\n ----------------------------------------\nERROR: Command errored out with exit status 1: /usr/bin/python -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'/tmp/pip-install-kSAGVZ/psycopg2/setup.py'\"'\"'; __file__='\"'\"'/tmp/pip-install-kSAGVZ/psycopg2/setup.py'\"'\"';f=getattr(tokenize, '\"'\"'open'\"'\"', open)(__file__);code=f.read().replace('\"'\"'\\r\\n'\"'\"', '\"'\"'\\n'\"'\"');f.close();exec(compile(code, __file__, '\"'\"'exec'\"'\"'))' install --record /tmp/pip-record-iJpHrB/install-record.txt --single-version-externally-managed --compile Check the logs for full command output.\n"}
PostgreSQL 9.5 (the default version) appears to no longer be available. It is now 9.6.
Also README needs to be updated (says current default is 9.3, but seems to be 9.5).