pg_dump problem

[Likit Younboon]

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

[Peter Eisentraut]

Post by Likit Younboon
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.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster