Joao Miguel Ferreira wrote:
Hello,
I have a 'strange' situation:
I need to make a replica copy of my database to a reduntant
spare
computer.
The reduntant computer is not running postgres, but postgres is
installed. The redundant computer is running in a special
run-level (I'm
talking Linux here) in which Pg is _not_ running.
When the primary computer crashes the redundant one will be
rebooted in
'normal' mode and Postgres must be started with the databases
from the
replica.
You could use WAL archiving, but you'll want a fairly regular
full-backup of PG's files otherwise the recovery could take a long time.
See Ch 23 of the manuals for details.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster