snort adds the --with-postgresql flag if the postgres USE flag is on, but does not depend on it.
Thanks for the report.