On Tue, Aug 24, 2004 at 07:25:46 +0100, Mario Thomas <[EMAIL PROTECTED]> wrote: > Hello All, > > We have a server in our datacentre running PostgreSQL 7.2 with about 50 > databases set up (for different customers). We have just commissioned a > much better specified server which is running PostgreSQL 7.4. > > We need to migrate the databases from 7.2 to 7.4. The smallest database > contains about 200K of data whilst the largest database weighs in at > about 100Mb. > > What's the best way to migrate the data? Would you suggest using the > pgdump tools? We've found them to be quite problematic in use and are > not entirely sure of the best command line switches to use.
If you use the pg_dump(all) client from 7.4 to dump the 7.2 database, you will probably find that it works a lot better with handling dependencies than the 7.2 pg_dump(all) client did. > > We need to make sure the data and permissions get migrated, as the data > is being used for live web sites. So obviously speed of migration is > important as we will have a period of downtime to complete the > migrations. You might look at Slony I, though I think it only works on versions back to 7.3. If it works back to 7.2, then it could be used to sync your new system up, allowing for a very short cutover time. > > Any suggestions/product ideas would be greatly appreciated. > Thanks in advance, > > Mario ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
