| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: About Pgdump |
| Date: | 2003-09-19 09:59:04 |
| Message-ID: | 20030919105904.G1582@bacon |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Christian Imbeault | 2003-09-19 10:09:33 | adding on delete cascade constraint? |
| Previous Message | Christoph Haller | 2003-09-19 09:36:35 | Re: change of table name - any help |