Hi Charles,
thanks for the quick response and it looked promising but did not work
as expected.
I can set the datestyle to ISO on database level but this does not
seem to effect the way the CSV logs are written. I still get
2015-09-22 13:06:01.658 UTC (or CEST and so on) in the log files. And
as I see it is not only in the CSV logs, also in the none CSV logs I
have.
Is there a way to convince Postgres to write the date/time with
numerical time zone values to the log files?
Regards,
Michael
Hi
-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Michael Zoet
Sent: Dienstag, 22. September 2015 12:07
To: pgsql-general@xxxxxxxxxxxxxx
Subject: how to show time zone with numerical offset in CSV log?
Hello everybody,
I am saving PostgreSQL log file data (CVS logs) with Logstash and
Elasticsearch. My problem with this is that the time zone value is
with the name of the time zone like
2015-09-22 12:02:59.836 CEST
which Logstash can not process.
What Logstash needs are date/time stamps like
2015-09-22 12:02:59.836 +0200.
How can I setup Postgres to log with a numerical offset in the CSV
logs and not with the name of the time zone?
Not exactly the same format, but this may help:
kofadmin@kofdb.localhost=> SET datestyle TO 'ISO';
SET
kofadmin@kofdb.localhost=> select now();
now
----------------------------
2015-09-22 12:53:38.123+02
(1 row)
If you want the change to be persistent you can use:
ALTER DATABASE database_name SET datestyle TO 'ISO';
And then reconnect to see the change.
Bye
Charles
Any hints and links to the corresponding documentation would be appreciated.
Regards,
Michael
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
----- Ende der Nachricht von Charles Clavadetscher
<clavadetscher@xxxxxxxxxxxx> -----
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
