pg_dump problem

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

pg_dump problem

От:
"Likit Younboon" <likity@ttt.co.th>
Дата:

Hi,

I use PostgreSQL and use backup command (pg_dump).

I use like this   $pg_dump -u -Fc -b databasename > backup.tar.gz

I need to backup with pg_dump by automatic with crontab, but pg_dump must input Username and Password.

How to bypass Username and Password for use pg_dump with crontab.


Please help me. I don't know how to solve problem.


Thank you.
Likit Younboon

Re: pg_dump problem

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
Likit Younboon wrote:
> How to bypass Username and Password for use pg_dump with crontab.

Preferrably, set your client authentication (pg_hba.conf) not to require 
passwords.  In newer versions you can also store user passwords in a 
file ~/.pgpass.

FAQ