On Fri, 30 Sep 2005, Simon Riggs wrote:
If I follow your example, yes. But that assumes there is only one timeline's WAL files in your pg_xlog. It could get more complex in that situation because you could be in any of the timelines. But, if you know which timeline you're in, then yes, the file after the latest file in archive_status is the current WAl file. It might be interesting to submit your script to put into contrib?
So, actually, my script is probably doing things incorrectly at the moment. What effect would the different timelines create? In my client's case there is only one timeline, but I'd love to generalize the script so we can put it in contrib, but first I'd like to make sure it actually works properly. :-)
-- Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
