Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Antti HaapalaDate: 2003-04-28 21:36:14
Subject: Re: timestamps and dates
Previous:From: IvanDate: 2003-04-28 21:10:47
Subject: Re: encrypt/decrypt problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group