| From: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
|---|---|
| To: | John Iliffe <john(dot)iliffe(at)iliffe(dot)ca> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Automated Database Backups |
| Date: | 2010-10-18 06:42:19 |
| Message-ID: | b2f4c490a5376c035c6829524085337a@smogura-softworks.eu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 15 Oct 2010 17:12:50 -0400, John Iliffe <john(dot)iliffe(at)iliffe(dot)ca>
wrote:
> Does anyone have a way to run pg_dump from cron in a way that doesn't
> require someone to enter the password on every run? I get the following
> error even when the backup user has read permissions on all application
> databases.
You can configure PSQL to use ident authentication, it should be
configured as default, so user "postgres" have full access to all
databases. Then assign home directory for this user, and create user
specified cron file. Then you will don't need to store password.
--
----------
Radosław Smogura
http://www.softperience.eu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Mamin | 2010-10-18 08:47:30 | Question on STABLE functions limitations |
| Previous Message | Craig Ringer | 2010-10-18 05:39:04 | Re: installing from source in Windows |