I am unable to connect from python3 on the web server to timescaleDB. See error below. I have trolled Stack Overflow and made some updates to the compose file without much luck. Any ideas?
# python3 loaddata.py Traceback (most recent call last): File "loaddata.py", line 88, in <module> upload_to_aws_efficiently(df_all) File "loaddata.py", line 46, in upload_to_aws_efficiently with psycopg2.connect( File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 127, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
bradpatton
commented
3 years ago
I am unable to connect from python3 on the web server to timescaleDB. See error below. I have trolled Stack Overflow and made some updates to the compose file without much luck. Any ideas?
# python3 loaddata.py Traceback (most recent call last): File "loaddata.py", line 88, in <module> upload_to_aws_efficiently(df_all) File "loaddata.py", line 46, in upload_to_aws_efficiently with psycopg2.connect( File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 127, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?