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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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