Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sat, 15 Apr 2006 10:00:35 -0700 (PDT)
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
- Follow-Ups:
- Re: Proposed doc-patch: Identifying the Current WAL file
- From: Bruce Momjian
- Re: Proposed doc-patch: Identifying the Current WAL file
- References:
- Re: Proposed doc-patch: Identifying the Current WAL file
- From: Bruce Momjian
- Re: Proposed doc-patch: Identifying the Current WAL file
- From: Tom Lane
- Re: Proposed doc-patch: Identifying the Current WAL file
- Prev by Date: Re: Proposed doc-patch: Identifying the Current WAL file
- Next by Date: Re: Proposed doc-patch: Identifying the Current WAL file
- Previous by thread: Re: Proposed doc-patch: Identifying the Current WAL file
- Next by thread: Re: Proposed doc-patch: Identifying the Current WAL file
- Indexes: