>>> On Fri, Aug 24, 2007 at 2:57 PM, in message <200708241357.23629.kevin@xxxxxxxxxxxxxxxxxxx>, Kevin Kempter <kevin@xxxxxxxxxxxxxxxxxxx> wrote: > c) setup WAL archiving on the 8.1.4 cluster > > d) do a full dump of the 8.1.4 cluster and restore it to the new 8.2.4 > cluster > > e) stop the 8.2.4 cluster and bring it up in recovery mode, pointing it > to > the directory where we're archiving the 8.1.4 cluster's WAL segments. You can't use these techniques for a major version upgrade. Use pg_dump piped to psql. That will also eliminate all bloat. -Kevin ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
