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.