Re: pg_dump in a production environment - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump in a production environment
Date
Msg-id 16825.1116907955@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump in a production environment  ("Thomas F. O'Connell" <tfo@sitening.com>)
Responses Re: pg_dump in a production environment
Re: (Ideas) pg_dump in a production environment
List pgsql-general
"Thomas F. O'Connell" <tfo@sitening.com> 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

pgsql-general by date:

Previous
From:
Date:
Subject: Re: table synonyms
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: pg_dump in a production environment