Re: About Pgdump

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   |
+------------------------------+---------------------------------------------+