From: | "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org> |
---|---|
To: | "'Michael Zoet'" <Michael(dot)Zoet(at)zoet(dot)de>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: how to show time zone with numerical offset in CSV log? |
Date: | 2015-09-22 11:05:59 |
Message-ID: | 001301d0f526$af7b9a60$0e72cf20$@swisspug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Michael Zoet
> Sent: Dienstag, 22. September 2015 12:07
> To: pgsql-general(at)postgresql(dot)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(at)kofdb(dot)localhost=> SET datestyle TO 'ISO';
SET
kofadmin(at)kofdb(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2015-09-22 11:33:48 | Re: pgsql-95 repo in rsync |
Previous Message | Michael Zoet | 2015-09-22 10:07:19 | how to show time zone with numerical offset in CSV log? |