Can't Translate Host Name "postgres"

Technical Help
#1

Not sure if the houston connection is dropping due to late night working, 10pmPST/1amEST, or DB=usstock-1d (which I know updates nightly, but not backtesting through today's date). Reported after 3-4 differing attempts didn't resolve.

image
image1420×324 79 KB 

quantrocket_flightlog_1|2021-05-14 05:06:39 quantrocket.realtime: ERROR Traceback (most recent call last):
quantrocket_flightlog_1|2021-05-14 05:06:39 urllib3.connectionpool: DEBUG Resetting dropped connection: houston
quantrocket_flightlog_1|2021-05-14 05:06:39 urllib3.connectionpool: DEBUG http://houston:80 "GET /version HTTP/1.1" 200 20
 quantrocket_moonshot_1|  File "/opt/conda/lib/python3.8/site-packages/moonshot/strategies/base.py", line 1140, in backtest
 quantrocket_moonshot_1|    prices = self.get_prices(start_date, end_date, nlv=nlv, no_cache=no_cache)
 quantrocket_moonshot_1|  File "/opt/conda/lib/python3.8/site-packages/moonshot/strategies/base.py", line 1085, in get_prices
 quantrocket_moonshot_1|    prices = get_prices(**kwargs)
 quantrocket_moonshot_1|  File "/opt/conda/lib/python3.8/site-packages/quantrocket/price.py", line 205, in get_prices
 quantrocket_moonshot_1|    realtime_dbs = list_realtime_databases()
 quantrocket_moonshot_1|  File "/opt/conda/lib/python3.8/site-packages/quantrocket/realtime.py", line 395, in list_databases
 quantrocket_moonshot_1|    houston.raise_for_status_with_json(response)
 quantrocket_moonshot_1|  File "/opt/conda/lib/python3.8/site-packages/quantrocket/houston.py", line 206, in raise_for_status_with_json
 quantrocket_moonshot_1|    raise e
 quantrocket_moonshot_1|  File "/opt/conda/lib/python3.8/site-packages/quantrocket/houston.py", line 198, in raise_for_status_with_json
 quantrocket_moonshot_1|    response.raise_for_status()
 quantrocket_moonshot_1|  File "/opt/conda/lib/python3.8/site-packages/requests/models.py", line 941, in raise_for_status
 quantrocket_moonshot_1|    raise HTTPError(http_error_msg, response=self)
 quantrocket_moonshot_1|requests.exceptions.HTTPError: ('500 Server Error: Internal Server Error for url: http://houston/realtime/databases', {'status': 'error', 'msg': 'an unhandled exception occurred, please check flightlog for the traceback and notify support if the problem persists as this might be a bug', 'error': '(psycopg2.OperationalError) could not translate host name "postgres" to address: Name or service not known\n\n(Background on this error at: http://sqlalche.me/e/e3q8)'})
 quantrocket_moonshot_1|
 quantrocket_moonshot_1|...The work of process 178 is done. Seeya!
#2

This message gave me the insight to run !df -h, and did run out of room, needed to clean up and drop not used DB's.

  quantrocket_postgres_1|2021-05-14 20:24:04.502 UTC [1] FATAL:  could not write lock file "postmaster.pid": No space left on device
   quantrocket_postgres_1|
   quantrocket_postgres_1|PostgreSQL Database directory appears to contain a database; Skipping initialization
   quantrocket_postgres_1|
   quantrocket_postgres_1|2021-05-14 20:24:04.502 UTC [1] FATAL:  could not write lock file "postmaster.pid": No space left on device

For anyone else this was the doc reference I used. I had some databases using 1-2GB I didn't need.
Cleaned them up within /var/lib/quantrocket .

image
image832×199 33 KB