Re: Multiple WALs for PITR ? - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Multiple WALs for PITR ?
Date
Msg-id NOEFLCFHBPDAFHEIPGBOCENECFAA.simon@2ndquadrant.com
Whole thread Raw
In response to Re: Multiple WALs for PITR ?  ("Goulet, Dick" <DGoulet@vicr.com>)
List pgsql-admin
>Goulet, Dick
> As an Oracle DBA primarily, moving more towards PostGreSQL as time
> passes, the "alter system switch logfile" command is very often used at
> the end of a hot backup to force a logfile switch and consequently
> provide a full archive log set.  The command causes the database engine
> to cease using the current online redo log and have it archived to the
> archive log destination.  This is the only way to be sure that all
> required archive logs are present in a backup to reconstitute the
> database at another location.
>

Yep, know what it does - just wanted to check that people really used it.

I always felt I did that as a precaution rather than for good reason.

OK - 8.1 it is then,

Best Regards

Simon Riggs

pgsql-admin by date:

Previous
From: admin@usachurch.com
Date:
Subject: Re: problems with pg_dump and pg_restore
Next
From: Marcio Fernandes
Date:
Subject: ...