This resource will create file named postgresql in current working directory (I dont know what directory is by default used by chef-solo. Do you?). Use absolute path.