On 19/09/2003 07:35 Deepa K wrote:
Hi all,
I want to take backup of our online system on daily basis using
crontab. But actually the pg_hba.conf is configured with password
security.
How I can take the backup without setting password. Or is their any
other
way to take backup.
You could su to the postgres superuser to do the backup or maybe use a .pgpass file (needs at least 7.3 IIRC).
HTH
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
