I don't want to have to sit there and watch the import go by, I want to run a command and then look in a file for any errors after the import is complete. I tried this command but it didn't work: gunzip -c cli_postDataInserts.sql.gz | psql cli_post -U system | grep "ERROR:*" > import_errors
Try something like: ... psql cli_post 2>import_errors
STDOUT is file-handle 1, STDERR is file-handle 2. You might also want to read up on the "tee" utility.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
