On 10/25/07, Peter Childs <peterachilds@xxxxxxxxx> wrote: > I was wondering why my PITR base back up was taking 2 hours on my 8.3 test > database where as it takes 50 minutes on 8.1 and the database files are > meant to be smaller on a freshly installed 8.3 server rather than a 8.1.1 > server that aint been rebuilt since 8.1.1 was newly out. > I was planning to upgrade to 8.3 once its out... > > Down time for upgrades is somwhat lacking in a 24x7 business. > > Oh my 8.1 server has been up for well over a year with out being down at > all. the database for longer which really show how good postgres really is > 377 days uptime on computer and I think that was to move a plug. You should really look at scheduling the 5 minute window up update your 8.1 install. 8.1.1 is quite old and has a few known data eating bugs, if I remember correctly. Updating to 8.1.10 should only take literally about 1 or 2 minutes. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly