Обсуждение: psql invokation

Поиск
Список
Период
Сортировка

psql invokation

От
"Victor Yegorov"
Дата:
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
Дата:
"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