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

Re: Backup of live database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org, Steve Holdoway <steve(dot)holdoway(at)firetrust(dot)com>
Subject: Re: Backup of live database
Date: 2008-01-16 15:50:31
Message-ID: 24080.1200498631@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Am Mittwoch, 16. Januar 2008 schrieb Tom Lane:
>> (Thinks for a bit...) Actually I guess there's one extra assumption in
>> there, which is that tar must issue its reads in multiples of our page
>> size.  But that doesn't seem like much of a stretch.

> There is something about that here: 
> http://www.gnu.org/software/tar/manual/html_node/tar_149.html#SEC149

AFAICT that's talking about the I/O chunk size *on the archive file*.
It doesn't say anything specific about the chunk size on the file side.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Mischa SandbergDate: 2008-01-16 16:41:42
Subject: postgresql in FreeBSD jails: proposal
Previous:From: Peter EisentrautDate: 2008-01-16 15:39:11
Subject: Re: Backup of live database

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