On Feb 18, 2008 2:02 PM, Alfred Langer <Alfred.Langer1@xxxxxx> wrote: > > Hallo, > > I'm using fedora 8 and I have problems to run 8.2 and 8.3 parallel on the > same computer . Is it realy necessary to run pg_dumpall with 8.3. I'm afraid I'm not entirely sure if you're asking two unrelated questions or two questions you believe to be related. To run 8.2 and 8.3 in parallel on fedora, you'll either need to do source builds with different --prefix= settings, or you'll have to compile your own rpms from sprms with aforementioned --prefix settings in there somehow. For fedora, I prefer to build from source. it's really easy, and it's usually on a box used for things like running > 1 of something. ./configure --prefix=/home/smarlowe/pg82 make make install rinse repeat. As to the pg_dumpall, the nominally accepted way of upgrading your cluster is to use pg_dumpall from the destination version again the source version, where the destination pg version is > or = the source pg version. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend