Title: RE: [ADMIN] LVM snapshots
Thanks all.
The
conclusion there seemed to be that it ought to work just fine, but should be
tested. Well, I'll test it and see if anything interesting comes up.
If anything LVM snapshots will be less tricky than NetApp snapshots as LVM has
access t
"Matt Clark" <[EMAIL PROTECTED]> writes:
> Could freezing of the filesystem result in the WAL being fsynced at an
> 'inappropriate' time? Is there ever an inappropriate time to fsync
> the WAL?
If there were it'd be a bug ...
regards, tom lane
---
dea
of the problems we've had with that). I'd be interested in comments on the
strategy and the script itself.
Cheers,
Murthy
-Original Message-
From: Matt Clark [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 13:22
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] LVM sna
Murthy Kambhampaty wrote:
Backup restore has been tested so far by restoring a table and comparing the
contents; they were identical. Thanks to rsync performance is fantastic
compared to pgdump to a file (my past e-mail to the list will give some idea
of the problems we've had with that). I'd be i
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Matt writes:
>> If the theory can be robustly demonstrated to work in practice (which
>> you may have already done) then I say this strategy needs to be
>> recognised in the docs (or at least the techdocs) as a valid and useful one.
> The note in the
Thanks Murthy, that's exceptionally helpful!
Does anyone know what (in general) would cause the notices that Murthy spotted in the
logs as per the snippet below?
> The postmaster is started and stopped on the backup server, so that any
> problems can be identified right away. (Notice the "ReadR
PROTECTED]
Subject: Re: [ADMIN] LVM snapshots
Here's the script I use to mount a snapshot and rsync to a remote server;
...
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Murthy Kambhampaty <[EMAIL PROTECTED]> writes:
> A checkpoint process may have to be ongoing when the snapshot creation
> (filesystem freeze) occurs, for this situation to arise. (Reduce the
> checkpoint segments and interval to test.)
If LVM manipulations are needed to cause it, I would think it'
Hi!
Ragnar Kjørstad <[EMAIL PROTECTED]> writes on
Mon, 17 Mar 2003 13:31:32 +0100 (MET):
> [snip]
The mail has been marked using 8859-15 but apparently is using utf-8.
Looks odd in my not so very good webmailer.
Masi
---(end of broadcast)---