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's
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
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)---
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
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
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
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
---(end
PROTECTED]
Subject: 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
]
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