I want to do auto backup for pg with cronjob.
The problem is it equesting for password.
I have tried with pgpass but still
it does not work. I created the pgpass as per below:
echo
your_host:5432:your_user:your_db:your_pass ~/.pgpass
bash$ chmod 600 ~/.pgpass
My cronjob entry is
When I issue the command it is asking for passwd which I cannot used for
cronjob to run at midnight.
Execute the task as user postgres (crontab for postgres, not root) and
modify pg_hba.conf to permit access in trust mode (without asking for
password)
e.g : local all postgres
I have tried with pgpass but still it do
es not work. I created the pgpass as per below:
Version? ~/.pgpass is supported since 7.3. Two more solutions are:
1) Set PGPASSWORD variable to avoid pg_dump asking for password
2) Set connection as trust in pg_hba.conf
regards,
bhuvaneswaran