On 2009-05-20, Sam Mason wrote:
> On Wed, May 20, 2009 at 03:39:39PM +0100, Howard Cole wrote:
>> Sam Mason wrote:
>> >Note that when used on the pg_dump process all you're doing is stopping
>> >it from writing out the backup. The server process will still be
>> >running and waiting for the backu
On 2009-05-20, Chen, Dongdong (GE Healthcare) wrote:
> This is a multi-part message in MIME format.
>
> In my application, when press button "Backup" in UI, it invokes pg_dump
> to backup the database. It may take few minutes for the whole process.
> If I want to pause the process, what should I d
On Wed, May 20, 2009 at 03:39:39PM +0100, Howard Cole wrote:
> Sam Mason wrote:
> >Note that when used on the pg_dump process all you're doing is stopping
> >it from writing out the backup. The server process will still be
> >running and waiting for the backup to finish writing the data. It will
Sam Mason wrote:
On Wed, May 20, 2009 at 06:22:46PM +0530, Gurjeet Singh wrote:
I don't know if the following would be recommended, but did some research
and it seems that one can use STOP and CONT signals on Linux/Unix to
pause/continue a process.
As David noted; sending a STOP is exa
On Wed, May 20, 2009 at 06:22:46PM +0530, Gurjeet Singh wrote:
> I don't know if the following would be recommended, but did some research
> and it seems that one can use STOP and CONT signals on Linux/Unix to
> pause/continue a process.
As David noted; sending a STOP is exactly what your shell do
On Wed, May 20, 2009 at 2:53 PM, Chen, Dongdong (GE Healthcare) <
dongdongc...@ge.com> wrote:
> In my application, when press button "Backup" in UI, it invokes pg_dump
> to backup the database. It may take few minutes for the whole process. If I
> want to pause the process, what should I do. And
2009/5/20 Grzegorz Jaśkiewicz :
> 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 in
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://
On 20/05/2009 10:23, Chen, Dongdong (GE Healthcare) wrote:
> In my application, when press button "Backup" in UI, it invokes pg_dump
> to backup the database. It may take few minutes for the whole process.
> If I want to pause the process, what should I do. And also how to resume
> the process? Can
In my application, when press button "Backup" in UI, it invokes pg_dump
to backup the database. It may take few minutes for the whole process.
If I want to pause the process, what should I do. And also how to resume
the process? Can I pause while pg_restore?
Thanks
KevinChen
10 matches
Mail list logo
