Search Postgresql Archives

Re: Automated Database Backups

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



John,

> 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 use the .pgpass file in the backup owner's home directory:

*:5432:*:postgres:MyPassword
*:5432:*:xxxx:XsPassword

-- Gary Chambers

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux