OS - RH3 Pg - 7.4.9 Ram - 8G Disk-709G Raid 0+1 We are having a pgdump issue that we can't seem to find an answer for Background: Production server contains 11 databases of which 1 database comprises 85% of the 194G used on the drive. This one large db contains 12 schemas. Within the schemas of the large db, there maybe 1 or 2 views that span across 2 schemas. If we do a backup using pgdump against the entire database, it will take upwards of 8+ hours for the backup to complete. If we split the backup up to do a pgdump for the first 10 dbs and then do a pgdump by schema on the 1 large db, the the backup takes only 3.5hrs The other than using the schema switch, there is no compression happening on either dump. Any ideas why this might be happening or where we can check for issues? TIA Patrick Hatcher Development Manager Analytics/MIO Macys.com
