Re: fecha y hora en log

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

In response to

Browse pgsql-es-ayuda by date

  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