From: | Miguel <mmiranda(at)123(dot)com(dot)sv> |
---|---|
To: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: fecha y hora en log |
Date: | 2006-03-27 21:14:14 |
Message-ID: | 442855A6.9050507@123.com.sv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Martin Marques wrote:
>On Mon, 27 Mar 2006 12:51:16 -0600, Miguel <mmiranda(at)123(dot)com(dot)sv> wrote:
>
>
>>Hola listeros, como puedo configurar postgres para que aparesca la fecha
>>y hora en el log del servidor, actualmente aparece asi:
>>
>>
>
>Para ello necesitas algo como esto en el postgresql.conf:
>
>log_line_prefix = '<%t>'
>
>
>
gracias, exacto lo que queria.
2006-03-27 15:08:51 CST LOG: database system was shut down at
2006-03-27 15:08:50 CST
2006-03-27 15:08:51 CST LOG: checkpoint record is at 2/3792FA10
2006-03-27 15:08:51 CST LOG: redo record is at 2/3792FA10; undo record
is at 0/0; shutdown TRUE
2006-03-27 15:08:51 CST LOG: next transaction ID: 12434; next OID: 16561
2006-03-27 15:08:51 CST LOG: next MultiXactId: 1; next MultiXactOffset: 0
2006-03-27 15:08:51 CST LOG: database system is ready
2006-03-27 15:08:51 CST LOG: transaction ID wrap limit is 1073743867,
limited by database "radius"
2006-03-27 15:08:51 CST LOG: autovacuum: processing database "postgres"
atte
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Marques | 2006-03-27 21:15:14 | Re: problemas con permisos |
Previous Message | Fermín Bueno | 2006-03-27 21:09:24 | Montar POstgres 8.1x en Servidor Suse 9.2 |