Did you put postgresql.conf file in templates/default ? This is a default location where templates live. You have not read definition from chef resources website:

The location of a file in the /templates directory in a cookbook located in the chef-repo. Can be used to distribute specific files to specific platforms (see the section “File Specificity”, below). Default value: the name of the resource block (see Syntax section above).