On 20 Mar, 16:47, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > "filippo" <filippo2...@xxxxxxxxxxx> writes: > > The problem with the current implementation is that sometime pd_dump > > and psql ask for password but I want to create the database copy > > without any user typing (it is a cron script). > > Create a ~/.pgpass file for the user that runs the cron job. thanks Tom and Richard, actually it works now. However I wonder if there is a SQL way, I'm partially in a Windows enviroment and I don't trust very much the microsoft security. Thanks and regards, Filippo