Re: > 16TB worth of data question

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: > 16TB worth of data question
Date: 2003-04-28 21:22:58
Message-ID: 1051564978.13970.20.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2003-04-28 at 10:42, scott.marlowe wrote:
> On 28 Apr 2003, Jeremiah Jahn wrote:
>
> > On Fri, 2003-04-25 at 16:46, Jan Wieck wrote:
> > > Jeremiah Jahn wrote:
> > > >
> > > > On Tue, 2003-04-22 at 10:31, Lincoln Yeoh wrote:
[snip]
> Don't shut it down and backup at file system level, leave it up, restrict
> access via pg_hba.conf if need be, and use pg_dump. File system level
> backups are not the best way to go, although for quick recovery they can
> be added to full pg_dumps as an aid, but don't leave out the pg_dump,
> it's the way you're supposed to backup postgresql, and it can do so when
> the database is "hot and in use" and provide a consistent backup
> snapshot.

What's the problem with doing a file-level backup of a *cold* database?

The problem with pg_dump is that it's single-threaded, and it would take
a whole lotta time to back up 16TB using 1 tape drive...

If a pg database is spread across multiple devices (using symlinks),
then a cold database can be backed up, at the file level, using
multiple tape drives. (Of course, all symlinks would have to be
recreated when/if the database files had to be restored.)

--
+-----------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| An ad currently being run by the NEA (the US's biggest |
| public school TEACHERS UNION) asks a teenager if he can |
| find sodium and *chloride* in the periodic table of the |
| elements. |
| And they wonder why people think public schools suck... |
+-----------------------------------------------------------+

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Antti Haapala 2003-04-28 21:36:14 Re: timestamps and dates
Previous Message Ivan 2003-04-28 21:10:47 Re: encrypt/decrypt problem