天天看點

PostgreSQL13 安裝 psycopg2

目錄

  • 一、先安裝依賴包
    • 1、安裝postgreSQL13
    • 2、安裝postgresql13-devel依賴包
  • 二、安裝psycopg2
    • 1、直接安裝rpm包
    • 2、使用tar包安裝
  • 三、驗證

postgresql選取13.4版本

python分為python2.7與python3.7

psycopg2分為rpm包與tar源碼包

回到頂部

PostgreSQL13 安裝 psycopg2

 安裝步驟

rpm -ivh postgresql13-libs-13.4-1PGDG.rhel7.x86_64.rpm

rpm -ivh postgresql13-13.4-1PGDG.rhel7.x86_64.rpm

rpm -ivh postgresql13-server-13.4-1PGDG.rhel7.x86_64.rpm

rpm -ivh postgresql13-contrib-13.4-1PGDG.rhel7.x86_64.rpm

libicu-devel

llvm-toolset-7-clang

llvm5.0-devel

PostgreSQL13 安裝 psycopg2

yum -y install libicu-devel

llvm5.0-devel(沒有包)

llvm-toolset-7-clang(沒有包)

強制安裝postgresql13-devel

PostgreSQL13 安裝 psycopg2

PostgreSQL13 安裝 psycopg2

安裝後隻有python2.7能用

1)先安裝python3.7

安裝編譯相關工具包

yum -y groupinstall "Development tools"

yum -y install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel yum install libffi-devel -y

 下載下傳python3.7

wget https://www.python.org/ftp/python/3.7.0/Python-3.7.0.tar.xz

tar -xvJf Python-3.7.0.tar.xz

編譯安裝

mkdir /usr/local/python3 #建立編譯安裝目錄

cd Python-3.7.0

./configure --prefix=/usr/local/python3

make && make install

建立軟連接配接

ln -s /usr/local/python3/bin/python3 /usr/local/bin/python3

ln -s /usr/local/python3/bin/pip3 /usr/local/bin/pip3

2)下載下傳适配 python3.7 的tar包

tar -vzxf psycopg2-2.9.1.tar.gz

cd psycopg2-2.9.1/

PostgreSQL13 安裝 psycopg2

安裝前,需要配置 pg_config:

vim setup.cfg

配置 pg_config

PostgreSQL13 安裝 psycopg2

3)setup.py安裝

編譯:

python3 setup.py build

安裝:

python3 setup.py install

PostgreSQL13 安裝 psycopg2

import psycopg2

PostgreSQL13 安裝 psycopg2