Re: running psql in a cron job

never mind. a quick search in the mailing list archive solved the
problem. :)

Just use PGPASSWORD=my_pass psql -c "VACUUM ANALYZE" -d my_data -U
my_user


On Wed, 2002-08-07 at 10:51, Wei Weng wrote:
> My database has "local all password" as its HBA control.
> 
> Is there anyway to manipulate psql so that I can somehow put the
> password also inside the command line so that I can run psql in a cron
> job? (such as psql -c "VACUUM ANALYZE" -d my_data -U my_user)
> 
> Thanks
> 
> -- 
> Wei Weng
> Network Software Engineer
> KenCast Inc.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 
-- 
Wei Weng
Network Software Engineer
KenCast Inc.