[GENERAL] How to find the latest (partial) WAL file
What is the best way to find the latest partial WAL file? Based on my tests, using the mtime isn't 100% accurate, as if a pg_start_backup/pg_stop_backup() operation is run, the .backup file created might be newer than the last WAL file. It also seems that the WAL file related to the backup is being updated according to the mtime. Using a file name is also not 100% accurate, as it seems that postgres will recycle the archived files, giving them future names before they are used, leaving the directory with files that are older by name, but not yet with relevant data. Is there a way to discover what is the real current WAL file? I've read that one of the todo's for 8.2 is to handle partial files archiving, but I'm looking for something I can use now. Regards, Guy. -- Family management on rails: http://www.famundo.com - coming soon! My development related blog: http://devblog.famundo.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] How to find the latest (partial) WAL file
Just Someone [EMAIL PROTECTED] writes: Is there a way to discover what is the real current WAL file? If you sort first by mtime and second by file name you should find the right one in all cases, ie, take the latest mtime among the properly-named files, breaking ties by taking the higher filename. It'd probably be better if we had a function to report this, but you can get along without one. regards, tom lane ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] How to find the latest (partial) WAL file
Hi Tom, If you sort first by mtime and second by file name you should find the right one in all cases, ie, take the latest mtime among the properly-named files, breaking ties by taking the higher filename. It'd probably be better if we had a function to report this, but you can get along without one. For now I'm using ls with grep: LAST_WAL=$(/bin/ls -t1p $WAL_DIR | /bin/grep -v / | /bin/grep -v backup | /usr/bin/head -1) But a pg function for that would be great. Regards, Guy Naor. -- Family management on rails: http://www.famundo.com - coming soon! My development related blog: http://devblog.famundo.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] How to find the latest (partial) WAL file
On Apr 10, 2006, at 6:24 PM, Tom Lane wrote: Just Someone [EMAIL PROTECTED] writes: Is there a way to discover what is the real current WAL file? If you sort first by mtime and second by file name you should find the right one in all cases, ie, take the latest mtime among the properly-named files, breaking ties by taking the higher filename. It'd probably be better if we had a function to report this, but you can get along without one. Seems like a natural candidate for a TODO item. I'm not familiar with the relevant internals, but on the surface it seems like it might even be a % item? -- Thomas F. O'Connell Database Architecture and Programming Co-Founder Sitening, LLC http://www.sitening.com/ 3004 B Poston Avenue Nashville, TN 37203-1314 615-260-0005 (cell) 615-469-5150 (office) 615-469-5151 (fax) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org