[ADMIN] Upgrading with WALs

2008-07-29 Thread Chris Bovitz
As I mentioned earlier, we are doing major upgrades to our database servers from 8.1.3 which necessitates the use of pg_dumpall. But what do we do with the WALs? Should we delete them? Or should we leave them there, and the new version of PostgreSQL will pick up where they left off? Should w

Re: [ADMIN] Upgrade clients when (major) upgrading server?

2008-07-24 Thread Chris Bovitz
Scott Marlowe wrote: On Thu, Jul 24, 2008 at 9:00 AM, Chris Bovitz <[EMAIL PROTECTED]> wrote: We have 8.1.3 on our operational and development database servers and will upgrade to 8.3.3 (development) and 8.2.9 (operations) soon. (We will not upgrade both systems' da

[ADMIN] Upgrade clients when (major) upgrading server?

2008-07-24 Thread Chris Bovitz
We have 8.1.3 on our operational and development database servers and will upgrade to 8.3.3 (development) and 8.2.9 (operations) soon. (We will not upgrade both systems' databases now because we've already tested 8.2 on our web server database for the past year, so it's already spent time in "