Skip site navigation (1) Skip section navigation (2)

Re: serverlog function (log_destination file)

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>,PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>,mha(at)sollentuna(dot)net,Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Subject: Re: serverlog function (log_destination file)
Date: 2004-06-08 18:27:29
Message-ID: 40C60511.3070209@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Magnus Hagander wrote:

>Specifically about the logs, I still think there is a lot of value to
>being able to read the logs remotely even if you can't restart
>postmaster.
>
Since I believe that retrieving the logs easily without server file 
access is a feature that's welcomed by many users, here's my proposal.

The attached diff will
- add a guc-variable log_filename
- extend log_destination to accept the keyword 'file'
- elog to that file if configured
- provide two functions pg_logfile_length() and pg_logfile to obtain the 
contents.

int4 pg_logfile_length()
cstring pg_logfile(int4 size, int4 position)
size (may be null meaning max) is the chunk size (max: currently 50000)
position (may be null meaning -size) is the start position; positive 
counting from log file start, negative from end.


Regards,
Andreas


Attachment: logfile.diff
Description: text/plain (9.3 KB)

In response to

Responses

pgsql-hackers by date

Next:From: pgsqlDate: 2004-06-08 19:24:42
Subject: Frequently updated tables
Previous:From: Thomas HallgrenDate: 2004-06-08 18:17:50
Subject: Re: Question regarding dynamic_library_path

pgsql-patches by date

Next:From: Euler Taveira de OliveiraDate: 2004-06-08 18:40:20
Subject: Re: pg_autovacuum integration proof of concept patch
Previous:From: Manfred KoizarDate: 2004-06-08 18:18:31
Subject: Re: cost_nonsequential_access()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group