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

Re: Proposed doc-patch: Identifying the Current WAL file

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Richard Huxton <dev(at)archonet(dot)com>, pgsql-docs(at)postgresql(dot)org
Subject: Re: Proposed doc-patch: Identifying the Current WAL file
Date: 2006-04-15 17:00:35
Message-ID: Pine.LNX.4.64.0604150957290.9581@discord.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
On Sat, 15 Apr 2006, Tom Lane wrote:

> For a command-line solution it's probably sufficient to sort by mtime,
> ie
> 	ls -t | head -1

A while back when I was trying to work this out on the admin list, I believe 
we came up with the following:

ls -tp /pg_xlog/ | grep -v "backup\|/" | head -1

which seems to work fairly well.  Looks like that thread is here:

http://archives.postgresql.org/pgsql-admin/2005-10/msg00173.php

-- 
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

In response to

Responses

pgsql-docs by date

Next:From: Bruce MomjianDate: 2006-04-15 17:26:57
Subject: Re: Proposed doc-patch: Identifying the Current WAL file
Previous:From: Tom LaneDate: 2006-04-15 16:40:11
Subject: Re: Proposed doc-patch: Identifying the Current WAL file

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-04-15 17:26:57
Subject: Re: Proposed doc-patch: Identifying the Current WAL file
Previous:From: Tom LaneDate: 2006-04-15 16:40:11
Subject: Re: Proposed doc-patch: Identifying the Current WAL file

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