Re: Practical maximums (was Re: PostgreSQL theoretical - Mailing list pgsql-general

From Jeff Davis
Subject Re: Practical maximums (was Re: PostgreSQL theoretical
Date
Msg-id 1155056052.12968.114.camel@dogma.v10.wvs
Whole thread Raw
In response to Re: Practical maximums (was Re: PostgreSQL theoretical  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Practical maximums (was Re: PostgreSQL theoretical  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On Tue, 2006-08-08 at 09:47 -0700, Jeff Davis wrote:
> I'm imagining something similar to the following:
> mydb=# select pg_start_backup('mybackup');
>
> $ tar zcf - /path/to/pgdata | mux.script /dev/st0 /dev/st1 /dev/st2
> $ tar zcf - /path/to/tablespace1 | mux.script /dev/st3 /dev/st4 /dev/st5
> $ tar zcf - /path/to/tablespace2 | mux.script /dev/st6 /dev/st7 /dev/st8
>

Oops, let me clarify. Those tar commands are independent and can be run
in parallel, which was the point I was trying to make. So, just run them
in the background in whatever way is most convenient.

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Practical maximums (was Re: PostgreSQL theoretical
Next
From: Joe Lester
Date:
Subject: restoring a backup, incompatible with server