psql invokation

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

psql invokation

От:
"Victor Yegorov" <viy@pirmabanka.lv>
Дата:
Вложения:
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
FAQ