After checking and double-checking the Barnyard2.conf file which is including the line
'output database: log, postgresql, user=snort password=l0gg3r dbname=snort host=winids sensor_name=WinIDS-Home'
The Barnyard2 configuration test fails with the following result-
ERROR: database Connection to database 'snort' failed
Fatal Error, exiting database: Closing connection to database "snort"
Any suggestions for resolving would be appreciated.