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

From Ron Johnson
Subject Re: Practical maximums (was Re: PostgreSQL theoretical
Date
Msg-id 44D8DC7F.9050502@cox.net
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  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jeff Davis wrote:
> 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.

Open database or closed database?

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE2Nx/S9HxQb37XmcRAgM5AKCkFR21o7/tUQiDPF/tvxpT0hmENACgsCBW
LeMdlk1n2TnD7gfqYeAFySw=
=R8CG
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: restoring a backup, incompatible with server
Next
From: Christoph Pingel
Date:
Subject: Re: DISTINCT to get distinct *substrings*?