"Thomas F. O'Connell" <tfo@xxxxxxxxxxxx> writes: > I'd like to use pg_dump to grab a live backup and, based on the > documentation, this would seem to be a realistic possibility. When I > try, though, during business hours, when people are frequently > logging in and otherwise using the application, the application > becomes almost unusable (to the point where logins take on the order > of minutes). The pg_dump sources contain some comments about throttling the rate at which data is pulled from the server, with a statement that this idea was discussed during July 2000 and eventually dropped. Perhaps you can think of a better implementation. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster