| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-04-15 17:26:57 | Re: Proposed doc-patch: Identifying the Current WAL file |
| Previous Message | Tom Lane | 2006-04-15 16:40:11 | Re: Proposed doc-patch: Identifying the Current WAL file |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-04-15 17:26:57 | Re: Proposed doc-patch: Identifying the Current WAL file |
| Previous Message | Tom Lane | 2006-04-15 16:40:11 | Re: Proposed doc-patch: Identifying the Current WAL file |