Postgresql grok pattern fails

[grahamrhay]

The postgres grok pattern (https://github.com/elastic/logstash/blob/v1.4.2/patterns/postgresql#L2) doesn't seem to be compatible with postgres 9.4. I'm not sure when the format changed.

Specifically, the pid at the end is no longer there. This is what I'm using:

%{DATESTAMP:timestamp} %{TZ} %{DATA:user_id} %{GREEDYDATA:connection_id} %{DATA:level}: %{GREEDYDATA:msg}

[grahamrhay]

I can create a PR with that, but it's probably worth collating a few log messages from different versions of postgres first

[purbon]

@grahamrhay thanks a lot for your contribution. Yeah! having a few log lines as examples would be awesome.

[grahamrhay]

9.4:

2015-10-22 08:57:03 UTC [8850-3] foo@bar STATEMENT: INSERT INTO ...
2015-10-22 08:57:03 UTC [8850-2] foo@bar DETAIL: Key already exists.
2015-10-22 08:57:03 UTC [8850-1] foo@bar ERROR: duplicate key value...