我正在尝试执行以下代码,但它没有运行。下面粘贴的错误日志。这个问题可能是由于导入PG而引起的,但我不知道如何解决此问题。
import pandas as pd
from sqlalchemy import create_engine, MetaData, Table, select, engine
from sqlalchemy.orm import sessionmaker
import datetime
import cx_Oracle
import dateutil.relativedelta
import configparser
import sys, os
from boto3.s3.transfer import S3Transfer
import boto3
import pg
try:
options = 'keepalives=1 keepalives_idle=200 keepalives_interval=200 keepalives_count=5'
connection_string = "host=%s port=%s dbname=%s user=%s password=%s %s" % (
'somehost', '8192', 'somedb', 'someuser', 'somepassword', options)
print(connection_string)
con = pg.connect(dbname=connection_string)
print('Connected to Redshift.Connection Detail : %s' % con)
except Exception as e:
print('Unable to Connect to Redshift')
print(e.message)
print('No')
sys.exit(1)
C:UsersolaaDesktopCWB> python .my.py Traceback (most recent call last): File ".my.py", line 11, in <module>
import pg File "C:UsersolaaAppDataLocalProgramsPythonPython36libsite-packagespg__init__.py", line 1, in <module>
from .core import ( File "C:UsersolaaAppDataLocalProgramsPythonPython36libsite-packagespgcore.py", line 6, in <module>
from . import glfw File "C:UsersolaaAppDataLocalProgramsPythonPython36libsite-packagespgglfw.py", line 138, in <module>
['', '/usr/lib', '/usr/local/lib', 'C:/Users/olaa/AppData/Local/Programs/Python/Python36/Lib/site-packages/pg/'],
_g lfw_get_version) File "C:UsersolaaAppDataLocalProgramsPythonPython36libsite-packagespgglfw.py", line 74, in _load_library
version = version_check_callback(filename) File "C:UsersolaaAppDataLocalProgramsPythonPython36libsite-packagespgglfw.py", line 130, in _glfw_get_versi on
out = process.communicate(_to_char_p(filename))[0] File "C:UsersolaaAppDataLocalProgramsPythonPython36libsubprocess.py", line 836, in communicate
stdout, stderr = self._communicate(input, endtime, timeout) File "C:UsersolaaAppDataLocalProgramsPythonPython36libsubprocess.py", line 1076, in _communicate
self._stdin_write(input) File "C:UsersolaaAppDataLocalProgramsPythonPython36libsubprocess.py", line 776, in _stdin_write
self.stdin.write(input) TypeError: write() argument must be str, not bytes
Traceback (most recent call last):
File "<string>", line 28, in <module>
EOFError: EOF when reading a line
import pg
这不是Postgres库。这是一个OpenGL图形库
即使该导入有效,它也会在con = pg.connect(
...
您正在尝试连接到Redshift/Postgres,因此请尝试使用实际的Postgres客户端之一
通常,Python用户想使用
psycopg2
,除非他们有强有力的理由尝试另一个驱动程序
https://wiki.postgresql.org/wiki/python