Обсуждение: pg_dump problem

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

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.