- Posted on
Mon Feb 05, 2018 4:46 pm
-
siclark
offline
-
- Posts: 1964
- Joined: Jun 13, 2017
- Location: UK
After a while, I have some spare time to attempt to move to Postgres again. I have Postgresapp setup, I pointed sqllogger to it, and it created the tables, and I can see them from SQLPro for Postgres so that all looks good.
However when I run the sql2postgres.py script I get this error
CREATDEFS 120.6@22:40 POSTGRES no information returned from postgres ".\d ..." querry
the command its running appears to be
CMD 120.0@22:40 /Applications/Postgres.app/Contents/Versions/10/bin/psql -U siclark indigo_history -t -A -F ' ' -c "\d ;" | grep ' table postgres' | awk '{print $2}'
Any ideas what is going wrong? I am guessing I need to change the commands on the psql slightly?
the parameters are
Parameters----------------------
CONVERSIONDirection SQLITE2POSTGRES
--------------------------------
debugLevel 5
userName siclark
POSTGRESuid siclark
PGMPATH /Users/siclark/Documents/convert/
TEMPPATH /Users/siclark/Documents/convert/temp/
POSTGRESPATH /Applications/Postgres.app/Contents/Versions/10/bin/
SQLITEPATH /usr/bin/
INDIGOPATHlog /Library/Application Support/Perceptive Automation/Indigo 7/Logs/
DUMPFILE indigo_history.dump
HISTfile indigo_history.sqlite
POSTGRESdb indigo_history
limitRecords 9999999999
deleteDestTable True
createDestTable True
deleteDB True
createDB True
purgeRecordsWithSameTime True
purgeDevice {}
useSQLITEifNoPOSTGRE False
testThisDeviceOnly device_history_1441572051
skipDevices []
STEPS---------------------------
stepCOPYDB True
stepMKDUMPFILE False
stepCREATDEFS True
stepCreateImport True
stepDoIMPORT True
stepREFRESHquerry True
stepREFRESHImport True