"Victor Yegorov" <viy@pirmabanka.lv> 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