Hi,

I found that a step was missing regarding the Postgres permissions after:

grant all privileges on database snort to snort;

I had to dump out the list of tables at a postgres prompt (using \d), and then grant access to the tables as follows:

GRANT ALL ON TABLE data, detail, encoding, event, icmphdr, iphdr, opt, reference, reference_ref_id_seq, reference_system, reference_system_ref_system_id_seq, schema, sensor, sensor_sid_seq, sig_class, sig_class_sig_class_id_seq, sig_reference, signature, signature_sig_id_seq, tcphdr, udphdr TO snort;

 Otherwise snort will fail to start with:

 "database: postgresql_error: ERROR:  permission denied for relation sensor"

Here's someone else who had the same issue: http://www.snort.org/archive-1-6575.html 

Regards,

Patrick