Re: Can I pause the pg_dump or pg_restore

From: David <wizzardx(at)gmail(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: "Chen, Dongdong (GE Healthcare)" <DongdongChen(at)ge(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Can I pause the pg_dump or pg_restore
Date: 2009-05-20 09:54:42
Message-ID: 18c1e6480905200254o749877aao810b7bfb60dd5947@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/5/20 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>:
> restore you can, kind of pause, by pausing data feed to it. (assuming
> you have a control over pipe, and you are using text dump format).
> as for pg dump, I don't think there's a way.
>

pg_dump should be pauseable, if you use your OS's job-handling tools.
For instance, in Linux, you can press "Ctrl+Z" while running a
program, and then run run "fg" later to resume it. You can also script
this with various command-line utilities.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Massa, Harald Armin 2009-05-20 10:12:59 Re: [Windows] Feedback on PG?
Previous Message David 2009-05-20 09:50:07 Getting ID of last-inserted row