psql invokation
psql invokation
Hello. Is it possible to invoke psql from a script (executed via cron) and connect to remote server? Actually, problem is that psql asks password and ignores any pipes I try. Thanks. -- Victor Yegorov
Re: psql invokation
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Victor Yegorov" writes: > Is it possible to invoke psql from a script (executed via cron) and connect > to remote server? Sure. > Actually, problem is that psql asks password and ignores any pipes I try. In PG 7.3, the preferred way to deal with this is to keep passwords in ~/.pgpass. Note that this file cannot be found by psql unless HOME is set in your environment --- which some crons don't set for you. If the script works "by hand" and not from cron, suspect missing environment values. regards, tom lane