From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
---|---|
To: | 'Nithya Soman' <nithya(at)quintetsolutions(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PSQL log file |
Date: | 2014-03-31 13:26:20 |
Message-ID: | 0683F5F5A5C7FE419A752A034B4A0B979785AA17@sswchi5pmbx2.peak6.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Is there any option in psql version 9.2.4, to insert the date time
> also inside the psql log files(in path /var/log/postgresql) ?
If you look in postgresql.conf for your installation, you can change the log prefix by setting log_line_prefix. If you add %t to that string, you'll get a timestamp + date value with every entry. The postgresql.conf file should also list all of the honored prefixes, or you can use this URL for more guidance:
http://www.postgresql.org/docs/9.2/static/runtime-config-logging.html
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd | Suite 400 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2014-03-31 13:49:38 | Re: [GENERAL] openvz and shared memory trouble |
Previous Message | lst_hoe02 | 2014-03-31 13:02:32 | Re: [GENERAL] openvz and shared memory trouble |