How to log the output along with error messages to a file while running a script on psql command line on Freebsd OS?

Question

On RHEL, the below command works: psql -h hostname -U username -p port_no -d database -f /tmp/myfile.sql &> logfile01.txt

On FreeBSD, this throws error: "Invalid null command"

Please suggest.

replace &> with 2>&1 stackoverflow.com/a/42666651/1135424 — nbari
– nbari, Commented May 5, 2019 at 7:52

ennox · Accepted Answer · 2019-05-02 12:25:42Z

2

If you use this only on the command line then there is no need to change the shell. To redirect stdout and stderr to a file in C-Shell synthax simply use ">& filename".

Different story is, if you want to write shell scripts. Bourne Shell and it's clones (like i.e. Bash) are better suited for writing script. See this Unix FAQ "Csh Programming Considered Harmful": http://www.faqs.org/faqs/unix-faq/shell/csh-whynot/

answered May 2, 2019 at 12:25

ennox

2261 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vladimir Botka · Accepted Answer · 2019-05-02 09:49:35Z

0

This redirection works in bash

&> logfile01.txt

, but it does not work in csh which is the default shell in FreeBSD.

# set | grep shell
shell   /bin/csh
# ls -la &> logfile01.txt
Invalid null command.

Bash is not installed by default. You can install it

pkg install bash

and configure it as the default shell.

edited May 2, 2019 at 9:49

answered May 2, 2019 at 9:42

Vladimir Botka

69.9k7 gold badges45 silver badges78 bronze badges

Collectives™ on Stack Overflow

How to log the output along with error messages to a file while running a script on psql command line on Freebsd OS?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related