- Posted on
Fri Jan 15, 2021 11:03 pm
-
bjmouton
offline
-
- Posts: 65
- Joined: Jul 23, 2017
Yes, That is the path I have in the config, but there is an error in the log (see below). Also, there is no file in that path's bin directory named "psql indigo_history postgres", the closest is just "psql".
15 22:52:30 logger enabled for THREADDEBUG
15 22:52:30 logger enabled for DEBUG
22:52:30 logger enabled for INFO
22:52:30 logger enabled for WARNING
2021-01-15 22:52:30.717 ERROR Plugin.__init__ logger enabled for ERROR
2021-01-15 22:52:30.717 CRITICAL Plugin.__init__ logger enabled for CRITICAL
22:52:30 -myLogSet setting parameters -- logFileActive= indigo; logFile= /Library/Application Support/Perceptive Automation/Indigo 7.5/Logs/com.karlwachs.minMax/plugin.log; debugLevel= [u'Sql', u'Setup']
22:52:30 Configuration: ... date format: %Y-%m-%d-%H:%M:%S ==> 2021-01-15-22:52:30
22:52:30 Dev/Var-Name----- ID State ignoreLess ignoreGreater format tracking measures: -------
22:52:30 Deck Door Sensor 364274916 onOffState -9876543210 9876543210 '%.1f' lastDay- Count1
thisDay- Count1
22:52:30 Aeotec_Temperature 1774580169 value -9876543210 9876543210 '%.1f' thisHour- Min Max Ave
lastHour- Min Max Ave
lastDay- DateMax Min Max DateMin Ave
thisDay- Min Max Ave
22:52:30 Front Door Sensor 18622376 onOffState -9876543210 9876543210 '%.1f' lastDay- Count1
thisDay- Count1
22:52:30 AmbientTemperature 729752752 value -9876543210 9876543210 '%.1f' thisHour- Min Max Ave
lastHour- Min Max Ave
22:52:30 Patio Door Sensor 61344331 onOffState -9876543210 9876543210 '%.1f' lastDay- Count1
thisDay- Count1
15 22:52:30 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgre -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), onOffState from device_history_364274916 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2020-11-30-00:52:30' ORDER by id ;"
15 22:52:30 data-out:
15 22:52:30 err-out: psql: error: FATAL: role "postgre" does not exist
15 22:52:30 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgre -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), value from variable_history_1774580169 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2020-11-30-00:52:30' ORDER by id ;"
15 22:52:30 data-out:
15 22:52:30 err-out: psql: error: FATAL: role "postgre" does not exist
15 22:52:31 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgre -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), onOffState from device_history_18622376 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2020-11-30-00:52:30' ORDER by id ;"
15 22:52:31 data-out:
15 22:52:31 err-out: psql: error: FATAL: role "postgre" does not exist
15 22:52:31 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgre -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), value from variable_history_729752752 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2020-11-30-00:52:30' ORDER by id ;"
15 22:52:31 data-out:
15 22:52:31 err-out: psql: error: FATAL: role "postgre" does not exist
15 22:52:31 /Applications/Postgres.app/Contents/Versions/latest/bin/psql indigo_history postgre -t -A -F ';' -c "SELECT to_char(ts,'YYYY-mm-dd-HH24:MI:ss'), onOffState from device_history_61344331 where to_char(ts,'YYYY-mm-dd-HH24:MI:ss') > '2020-11-30-00:52:30' ORDER by id ;"
15 22:52:31 data-out:
15 22:52:31 err-out: psql: error: FATAL: role "postgre" does not exist
22:52:51 subscribing to device changes
22:52:51 subscribing to variable changes