I can’t look it up right now. But it is mentioned in one of the threads also the help text should give you a hint. You need to adapt to your version number.
If you have indigo utilities working it uses the same string.
I think I have successfully switched to PostgreSQL from SQLite in the SQL Logger. I have also been able to extract data from the PostgreSQL database using Indigo utilities after I set up the appropriate password for indigo_history in the .pgpass file in my home directory. For instance this is an extract from the utilities output for outside temperature - one of the items that I am plotting:
SQL command= /Library/PostgreSQL/10/bin/psql indigo_history postgres -c "SELECT id, to_char(ts,'YYYY-mm-dd-HH24:MI:ss') as ts,outdoorTemperature_F from device_history_56777626 WHERE ID > 0 LIMIT 10;"
SQL-OUTPUT:
id | ts | outdoortemperature_f
----+---------------------+----------------------
1 | 2018-03-25-23:59:21 | 53.5
2 | 2018-03-25-23:59:28 | 53.6
3 | 2018-03-26-00:00:01 | 53.5
4 | 2018-03-26-00:00:29 | 53.5
5 | 2018-03-26-00:00:33 | 53.5
6 | 2018-03-26-00:01:37 | 53.4
7 | 2018-03-26-00:02:09 | 53.4
8 | 2018-03-26-00:03:13 | 53.4
9 | 2018-03-26-00:04:18 | 53.4
10 | 2018-03-26-00:04:50 | 53.4
.
.
.
4954 | 2018-03-28-17:32:35 | 69.3
4955 | 2018-03-28-17:33:07 | 69.3
4956 | 2018-03-28-17:33:39 | 69.2
4957 | 2018-03-28-17:34:11 | 69.3
4958 | 2018-03-28-17:34:44 | 69.3
4959 | 2018-03-28-17:35:16 | 69.3
4960 | 2018-03-28-17:35:48 | 69.3
4961 | 2018-03-28-17:36:20 | 69.4
It appears that all of the appropriate temperature data is contained in the database. I have used the same postgre command string in INDIGOplotD that I used in Indigo utilities (/Library/PostgreSQL/10/bin/psql indigo_history postgres)
The problem is that the daily 2 day batch refresh at 16 minutes past midnight erases all of the plot information for the past two days and replaces it with empty data. The plots then begin refreshing from that time forward. Plots older than two days remain. The following is the event log associated with the daily refresh. I am at a loss regarding how to solve this problem.
2018-03-29 00:00:58.928 INDIGOplotD command: shift day done
2018-03-29 00:16:02.980 INDIGOplotD command: create Python code for PLOTs in /Users/grwilde/indigo/INDIGOplotD/py/RestoreConfigAndPlots-20180329-001602.py DONE
2018-03-29 00:16:06.156 INDIGOplotD Converted 0:00:00.005744 rateTime-value-average 18/ 5/ 18/ 387-rejec: 0/ 0/ 0/ 13/ 0/ 19
2018-03-29 00:16:06.184 INDIGOplotD Converted 0:00:00.033147 006 - Inside Garage Temperature-sensorValue-average 1572/ 1/ 1572/ 38193-rejec: 0/ 0/ 0/ 1572/ 0/ 4
2018-03-29 00:16:06.217 INDIGOplotD Converted 0:00:00.066636 003 - Downstairs Hall Temperature-sensorValue-average 1642/ 1/ 1642/ 39943-rejec: 0/ 0/ 0/ 1642/ 0/ 11
2018-03-29 00:16:06.273 INDIGOplotD Converted 0:00:00.122137 004 - Entry Hall Temperature-sensorValue-average 1746/ 1/ 1746/ 42543-rejec: 0/ 0/ 0/ 1746/ 0/ 3
2018-03-29 00:16:06.301 INDIGOplotD Converted 0:00:00.150298 005 - Upstairs Hall Temperature-sensorValue-average 1756/ 1/ 1756/ 42793-rejec: 0/ 0/ 0/ 1756/ 0/ 5
2018-03-29 00:16:06.374 INDIGOplotD Converted 0:00:00.223844 costPerHour-value-average 4326/ 1/ 4327/ 118730-rejec: 0/ 0/ 0/ 4326/ 0/ 18
2018-03-29 00:16:06.452 INDIGOplotD Converted 0:00:00.301588 Ecobee Thermostat-hvacFanIsOn-average 20842/ 1/ 42044/ 515487-rejec: 0/ 0/ 0/ 20842/ 0/ 9
2018-03-29 00:16:06.538 INDIGOplotD Converted 0:00:00.387716 Ecobee Thermostat-hvacCoolerIsOn-average 20844/ 1/ 42044/ 515537-rejec: 0/ 0/ 0/ 20844/ 0/ 8
2018-03-29 00:16:06.610 INDIGOplotD Converted 0:00:00.459643 Ecobee Thermostat-hvacHeaterIsOn-average 20844/ 1/ 42044/ 515538-rejec: 0/ 0/ 0/ 20844/ 0/ 7
2018-03-29 00:16:06.688 INDIGOplotD Converted 0:00:00.537266 Ecobee Thermostat-humidityInput1-average 20842/ 1/ 42044/ 536331-rejec: 0/ 0/ 0/ 20842/ 0/ 10
2018-03-29 00:16:06.792 INDIGOplotD Converted 0:00:00.641671 Ecobee Thermostat-temperatureInput1-average 20843/ 1/ 42044/ 536356-rejec: 0/ 0/ 0/ 20843/ 0/ 6
2018-03-29 00:16:06.945 INDIGOplotD Converted 0:00:00.794070 WeatherSnoop-windSpeed_mph-average 34007/ 1/ 34007/ 839071-rejec: 0/ 0/ 0/ 34007/ 0/ 16
2018-03-29 00:16:07.092 INDIGOplotD Converted 0:00:00.941021 WeatherSnoop-rainRate_in-average 34007/ 1/ 34007/ 840436-rejec: 0/ 0/ 0/ 34007/ 0/ 17
2018-03-29 00:16:07.237 INDIGOplotD Converted 0:00:01.086788 WeatherSnoop-outdoorTemperature_F-average 34007/ 1/ 34007/ 873076-rejec: 0/ 0/ 0/ 34007/ 0/ 12
2018-03-29 00:16:07.328 INDIGOplotD Converted 0:00:01.177008 WeatherSnoop-outdoorHumidity-average 34007/ 1/ 34007/ 873076-rejec: 0/ 0/ 0/ 34007/ 0/ 13
2018-03-29 00:16:07.422 INDIGOplotD Converted 0:00:01.270845 WeatherSnoop-indoorTemperature_F-average 34007/ 1/ 34007/ 873076-rejec: 0/ 0/ 0/ 34007/ 0/ 14
2018-03-29 00:16:07.547 INDIGOplotD Converted 0:00:01.396141 WeatherSnoop-relativeBarometricPressure_inHg-average 34007/ 1/ 34007/ 903496-rejec: 0/ 0/ 0/ 34007/ 0/ 15
2018-03-29 00:16:07.879 INDIGOplotD Converted 0:00:01.727841 TED 5000-PowerNow_MTU1-average 128686/ 1/ 659591/ 3568340-rejec: 0/ 0/ 0/ 128686/ 0/ 1
2018-03-29 00:16:08.189 INDIGOplotD Converted 0:00:02.038403 TED 5000-VoltageNow_MTU1-average 128676/ 1/ 659591/ 3582233-rejec: 0/ 0/ 0/ 128676/ 0/ 2
2018-03-29 00:16:08.373 INDIGOplotD SQL import 2018-03-29 00:16:08.372402 ... finished, total number of records imported: 23