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
