Re: How I can automate postgres DB backing up?

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

 



On Monday 05 November 2007 06:14:02 Strong wrote:
> I have several DBs in single claster. When I make
>
> pg_dumpall -U postgres >file
>
> it asks me for password exact times the number DBs I have. Even to do
> that manualy, it sucks. But I want to go even farther: how I can
> automate the process to put into cron?

change your pg_hba.conf file and set postgres (or the user you're trying this 
as) to 'trust'

A more secure way is to setup a .pgpass file or use pg_service.  See the 
online postgres docs for more on these


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux