Re: logfile rotation

Tom Lane wrote:

>Andreas Pflug <pgadmin(at)pse-consulting(dot)de> writes:
>
>
>>>Answering my own question, the distribution of the current logfile
>>>name could be done trough a file handle.
>>>
>>>
>
>
>
>>would you mind commenting on my suggestion so I can continue on that topic?
>>
>>
>
>There is no portable way to redistribute a file handle.
>
>

Seems I didn't make clear enough what I mean.

I'd fopen a file handle in the postmaster, and all subsequent processes
will inherit that handle just as they do for stderr; no redistribution
required.
The log filename is written to that file when pg_logfile_rotate is called:
fseek(fh, 0, SEEK_SET);
fprintf(fh, "%s", newlogfilname);
fflush();

and all subprocesses may retrieve the filename when required by

char buf[MAXPGPATH];
fseek(fh, 0, SEEK_SET);
fread(buf, 1, MAXPGPATH, fh);
buf[MAXPGPATH-1]=0; // prevent buffer overflow
logfile=fopen(buf, "a+");

Regards,
Andreas