Home / server / Questions / 176860
Accepted
Gnanam
Asked: 2010-09-02 01:54:19 +0800 CST

How do I redirect console output of command to a logfile?

  • 772

My OS is RHEL5.

I want to direct the console output produced by the following database command to a log/file.

psql mydb mydbuser -c "VACUUM ANALYZE VERBOSE"

I've tried out the following commands and is not working as expected. But it is printing output to the terminal console instead.

psql mydb mydbuser -c "VACUUM ANALYZE VERBOSE" > vacuum.log
psql mydb mydbuser -c "VACUUM ANALYZE VERBOSE" | tee vacuum.log

Here, in this case, is not the output produced by this command a standard input/output/error?

NOTE: psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results.

linux bash command-line-interface postgresql

1 Answers

  1. Best Answer

    Redirect stderr as well.

    psql mydb mydbuser -c "VACUUM ANALYZE VERBOSE" &> vacuum.log
    • 4