Re: hot spare / log shipping work on

Tom Lane wrote:

> Gaetano Mendola <mendola@bigfoot.com> writes:
> 
>>I'm facing however to the following problems:
> 
> 
>>1) Discovery the actual WAL file
>>    I'm supposing is the last modified file inside the
>>         pg_xlog directory. If this is not the good method
>>         may I know how I can know it ?
> 
> 
> While that theoretically will work, it leaves a bad taste in my mouth.
> I have been thinking of proposing that we add a "pg_current_wal_file()"
> function, or some such name, to return the name of the active WAL file.

Totally agree, this could help during the process.

Actually I detect the current wal file in this way:

ls -t1p $PGXLOGDIR | grep -v / | head 1

that is an almost "empirical" process, in the first phase
I can live with it but for sure a more robust way is a must.


Regards
Gaetano Mendola