On 19/10/2011 22:10, Bobby Dewitt wrote: > I can not find a way to log ALL output from a psql session when running > a script. Basically, I'm running a large deployment script that has > thousands of SQL statements and I need to know which statements fail. I > want the output generated when running the script to be saved to a log > file so that I can grep through the output and look for errors. I don't > want the script to stop processing using the ON_ERROR_STOP variable. It > doesn't matter to me if the script is run interactively or not. > > I've tried redirecting the output to a log file, but this only gets the > SQL statements issued and their results and not the errors that may be > encountered: > psql -f test_psql_deployment_logging.sql > test_psql_deployment_logging.log > You need to redirect stderr as well - add "2>&1" to the end of the command. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
