On Thu, Nov 6, 2008 at 11:04 PM, Swathi S <[EMAIL PROTECTED]> wrote: > Hi, > > I have a database of size approx 400G. It's a 24/7 database. Only few tables > have regular reads and writes. The other tables just store information. > > I would like to upgrade to 8.3 and would like to know the best way to > upgrade with less downtime.
Assuming you're running 8.0 or higher now, slony should provide you with a one stop upgrade path with the minimum amount of downtime. We use it for our database which is smaller (~20 Gigs) but quite hard working, with access around the clock, and we switched out 8.1 to 8.3 with abut 1 minute of downtime. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
