Docker与PostgreSQL篇

docker容器启动PostgreSQL

# 拉取最新镜像镜像
docker pull postgres:latest
# 容器启动命令
docker run -d --restart=on-failure:5 \
--name=pgsql -p 7737:5432 \
-v D:\workspace\docker-data\posgresql\data:/var/lib/postgresql/data \
-e TZ="Asia/Shanghai" \
-e POSTGRES_PASSWORD=postgre \
postgres:latest

 Python类封装连接PostgreSQL

import psycopg2
import psycopg2.errors

class Database:
    def __init__(self, hostname=hostname, username=username, password=password,
                 dbname=database, port=port):
        self.hostname = hostname
        self.username = username
        self.password = password
        self.dbname = dbname
        self.port = port

        self._connection = None

    def __del__(self):
        if self._connection:
            self._connection.close()

    def create_connnection(self, retry=0)