Re: Meaning og Logs

Please don't start a new message by replying to someone else's message.
If you are going to, trim their message body from your message.

Suresh Gupta VG wrote:
>
> I got the logs as below from log file of PGSQL 7.4.2 on Solaris-9. Can
> any one please give the exact meaning of it. And I have not found the
> file any where on the server "0000000400000072".
>
>
> LOG: recycled transaction log file "0000000400000072"

The write-ahead-log (WAL) stores transactions in 16MB files. It keeps
several of these around and renames them (recycles) rather than deleting
old ones and creating new ones all the time.

> And I found most of the logged file contains the following statements.

> LOG: unexpected EOF on client connection

Client dropped the connection without closing it cleanly.

> WARNING: there is no transaction in progress

Something is issuing ROLLBACK/COMMIT while no explicit transaction has
been started.

> WARNING: there is already a transaction in progress

Something is issuing BEGIN after it's already been issued.

> Can I get the exact date and time of these logged statements. And what
> is the meaning of these statements.

Sure - see the logging section of postgresql.conf and the relevant
section of the manuals. You can add timestamps, user-names, client IP
addresses etc.

--
Richard Huxton
Archonet Ltd