Title: Re: FW: [ADMIN] Setting up of PITR system.
You should implement
filesystem or volume level snapshots. LVM, Veritas and the like all have
the functionality and it gets the database out of "backup" mode
quickly.
http://www.tldp.org/HOWTO/LVM-HOWTO/snapshots_backup.html
Before the
Hi,
On Tue, 11 Apr 2006, Spiegelberg, Greg wrote:
You should implement filesystem or volume level snapshots. LVM,
Veritas and the like all have the functionality and it gets the
database out of backup mode quickly.
from what I understand there is no need to keep the time between
Hello,
Next month I will receive my SAN and a new server. Using Redhat Cluster
Suite + GFS, I'd like to create a PGSQL active/passive cluster.
Do you have some advice about this setup or advice for PGSQL Clustering ?
For now, we are using 7.4.x but we will migrate to 8.1.x
My passive server
We already recommend file system snapshots as a backup method in our
documentation.
---
Spiegelberg, Greg wrote:
You should implement filesystem or volume level snapshots. LVM, Veritas and
the like all have the
I have an idea/request for the autovacuum daemon.As far as I can tell, there is no way to tell the daemon to only do it's work between certain hours. Could this be added as an option? In my situation, I have tables that if vacuumed during the day would cause a noticeable slowdown to my users and
Hi Chris Hoover,
There is already a method for this! Can i suggest that you set a O/S
schedule to simple run vacuumdb.exe at the desired time, preferable late
evening, as the vacuum of large databases can take all night, based on
my DBA experience. Don’t for get to setup the uses of password