Thread: Why do backups take so long?

<div class="WordSection1"><p class="MsoNormal">I have PostgreSQL 9.3 and the associated version of PGAdmin loaded on my
Windows7 Pro box.  I am trying to take a backup of a tiny database on my local machine.  When I request the backup,
PGAdminflashes for three minutes before finally deciding to make the backup.  Why does it do that, and is there an
updatefor PGAdmin available that doesn’t do that?<p class="MsoNormal"> <p class="MsoNormal">Thank you very much.<p
class="MsoNormal"> <pclass="MsoNormal">RobR</div> 

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@iol.ie

It completed successfully in about two seconds.

RobR

-----Original Message-----
From: Raymond O'Donnell [mailto:rod@iol.ie]
Sent: Friday, March 06, 2015 1:33 PM
To: Rob Richardson; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Why do backups take so long?

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
commandline 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@iol.ie

Am 06.03.2015 um 19:33 schrieb Raymond O'Donnell:

> 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.

There's nothing interesting about that, because this behaviour is really 
old news:
http://www.postgresql.org/message-id/20110103123027.118630@gmx.net

Running pg_dump from command line directly works without problems.

Makes me wonder whether the Windows version of pgAdmin is still being 
tested on xp only.

On 07/03/2015 00:15, Jan-Peter Seifert wrote:
> Am 06.03.2015 um 19:33 schrieb Raymond O'Donnell:
> 
>> 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.
> 
> There's nothing interesting about that, because this behaviour is really
> old news:
> http://www.postgresql.org/message-id/20110103123027.118630@gmx.net
> 
> Running pg_dump from command line directly works without problems.
> 
> Makes me wonder whether the Windows version of pgAdmin is still being
> tested on xp only.

It works fine for me - Windows 7 Home on my laptop, 64-bit, with pgAdmin
III 1.20.0. The interface flashes as described in the message linked
above - presumably as pgAdmin spawns and interacts with a new process
for pg_dump - but the entire operation takes no more than 5s with a tiny
database.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

I wanna unsubscribe immediately. How do I do it?!

On 07/03/2015 13:31, hushthatbush@hushmail.com wrote:
> I wanna unsubscribe immediately. How do I do it?!
> 

Just read the footer of every email from the list:

> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support

:-)

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 07/03/2015 13:43, hushthatbush@hushmail.com wrote:
> Nothing happens on that page except for a bunch of error messages and unrelated garbage.
> 
> Is this like a joke? Why can't I unsubscribe from this mailing list?!
> 
> On 2015-03-07 at 2:41 PM, "Raymond O'Donnell" <rod@iol.ie> wrote:
>>
>> On 07/03/2015 13:37, hushthatbush@hushmail.com wrote:
>>> Huh? There is no way to unsubscribe on that page...
>>>
>>> On 2015-03-07 at 2:35 PM, "Raymond O'Donnell" <rod@iol.ie> wrote:
>>>>
>>>> On 07/03/2015 13:31, hushthatbush@hushmail.com wrote:
>>>>> I wanna unsubscribe immediately. How do I do it?!

Please keep your replies on-list.

If there's a problem with the mailing list software, it'd be helpful to
tell the list *exactly* what error message(s) you got - that way the
list owners can have a look.

Thanks!

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Am 07.03.2015 um 13:32 schrieb Raymond O'Donnell:

> It works fine for me - Windows 7 Home on my laptop, 64-bit, with pgAdmin
> III 1.20.0. The interface flashes as described in the message linked
> above - presumably as pgAdmin spawns and interacts with a new process
> for pg_dump - but the entire operation takes no more than 5s with a tiny
> database.

You think it works fine. The truth is that you'll get flashed if you try 
to dump a larger database with many differences from template0.

I wanna unsubscribe immediately. How do I do it?!



--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

I don't check regularly, but I did just take a look and the instructions are there and do take you to a page with
optionsto unsubscribe. 

Further, both the PostgreSQL (http://www.postgresql.org/list/) and pgAdmin websites
(http://www.pgadmin.org/support/list.php)explain how to unsubscribe - given that you've been struggling to figure out
howto unsubscribe, I would assume you must have subscribed in the first place by reading one of those pages. 

> On 8 Mar 2015, at 02:59, hushthatbush@hushmail.com wrote:
>
> No, they are not. Jesus. Have you actually TRIED it? Because the link does NOT go to a page where you can
unsubscribe.Try it yourself. I can't believe I'm wasting so much time on UNSUBSCRIBING from a god damn mailing list
justbecause it's (deliberately?) broken. 
>
>> On 2015-03-07 at 5:56 PM, "Dave Page" <dpage@pgadmin.org> wrote:
>>
>> Instructions are on the bottom of every message.
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK:http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>> On 7 Mar 2015, at 13:31, hushthatbush@hushmail.com wrote:
>>>
>>> I wanna unsubscribe immediately. How do I do it?!
>>>
>>>
>>>
>>> --
>>> Sent via pgadmin-support mailing list (pgadmin-
>> support@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgadmin-support
>

On 08/03/2015 09:51, Dave Page wrote:
> I don't check regularly, but I did just take a look and the
> instructions are there and do take you to a page with options to
> unsubscribe.
> 
> Further, both the PostgreSQL (http://www.postgresql.org/list/) and
> pgAdmin websites (http://www.pgadmin.org/support/list.php) explain
> how to unsubscribe - given that you've been struggling to figure out
> how to unsubscribe, I would assume you must have subscribed in the
> first place by reading one of those pages.
> 
>> On 8 Mar 2015, at 02:59, hushthatbush@hushmail.com wrote:
>> 
>> No, they are not. Jesus. Have you actually TRIED it? Because the
>> link does NOT go to a page where you can unsubscribe. Try it
>> yourself. I can't believe I'm wasting so much time on UNSUBSCRIBING
>> from a god damn mailing list just because it's (deliberately?)
>> broken.

Also, as I said already, if there is a problem with the unsubscribe
page, it would be much more helpful to tell the list *exactly* what
error you got - you haven't done that yet.

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie