Re: pg_dump.. auto backup

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: Ganesan Kanavathy <ganesh(at)magnusquest(dot)com>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Rudi Starcevic'" <rudi(at)oasis(dot)net(dot)au>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_dump.. auto backup
Date: 2003-10-16 13:17:31
Message-ID: Pine.LNX.4.44.0310161844320.23099-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> I don't really understand this. How to put password in ~/.pgpass. What
> changes do I need to do on the script? How do I access to the password
> to authenticate?

Follow the below steps to automate your backup process.

bash$ echo your_host:5432:your_user:your_db:your_pass > ~/.pgpass
bash$ chmod 600 ~/.pgpass

Now, run your script and it must have been automated.

regards,
bhuvaneswaran

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Browne 2003-10-16 14:43:53 Re: pg_hba.conf
Previous Message Jeff 2003-10-16 11:50:27 Re: [PERFORM] backup/restore - another area.