On Fri, 15 Oct 2010 17:12:50 -0400, John Iliffe <john.iliffe@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
