Re: Why do backups take so long?

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Rob Richardson <RDRichardson(at)rad-con(dot)com>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Why do backups take so long?
Date: 2015-03-06 18:33:04
Message-ID: 54F9F2E0.70904@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On 06/03/2015 18:26, Rob Richardson wrote:
> I have PostgreSQL 9.3 and the associated version of PGAdmin loaded on my
> Windows 7 Pro box. I am trying to take a backup of a tiny database on
> my local machine. When I request the backup, PGAdmin flashes for three
> minutes before finally deciding to make the backup. Why does it do
> that, and is there an update for PGAdmin available that doesn’t do that?

pgAdmin just uses pg_dump [1] to do the actual backup, so it would be
interesting to run pg_dump directly at the command line to see if the
same behaviour manifests itself.

Ray.

[1] http://www.postgresql.org/docs/9.3/static/app-pgdump.html

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Rob Richardson 2015-03-06 18:44:34 Re: Why do backups take so long?
Previous Message Rob Richardson 2015-03-06 18:26:12 Why do backups take so long?