Thanks to those who replied to my post. I tried that and works a treat! Regards. John ====================================================== On Sat, 2010-16-10 at 17:18 +0100, Raymond O'Donnell wrote: > On 15/10/2010 22:12, John Iliffe 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 need to use a .pgpasss file: > > http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html > > You can instead specify the password in an environment variable, but > that potentially makes it visible to all users on the system, so the > .pgpass is better. > > HTH, > > Ray. > > > -- > Raymond O'Donnell :: Galway :: Ireland > rod@xxxxxx > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
