Re: how to show time zone with numerical offset in CSV log?
От | Michael Zoet |
---|---|
Тема | Re: how to show time zone with numerical offset in CSV log? |
Дата | |
Msg-id | 20150922153137.Horde.3UNvSHk0ypnhW1wnthMmOA1@server06.zoet.de обсуждение исходный текст |
Ответ на | Re: how to show time zone with numerical offset in CSV log? ("Charles Clavadetscher" <clavadetscher@swisspug.org>) |
Ответы |
Re: how to show time zone with numerical offset in CSV log?
(Adrian Klaver <adrian.klaver@aklaver.com>)
Re: how to show time zone with numerical offset in CSV log? ("Charles Clavadetscher" <clavadetscher@swisspug.org>) Re: how to show time zone with numerical offset in CSV log? (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
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@postgresql.org >> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Michael Zoet >> Sent: Dienstag, 22. September 2015 12:07 >> To: pgsql-general@postgresql.org >> Subject: [GENERAL] 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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general ----- Ende der Nachricht von Charles Clavadetscher <clavadetscher@swisspug.org> -----
В списке pgsql-general по дате отправления:
Следующее
От: Adrian KlaverДата:
Сообщение: Re: how to show time zone with numerical offset in CSV log?