On Oct 12, 2007, at 1:59 PM, Richard Huxton wrote:
Joao Miguel Ferreira wrote:Hello, I have a 'strange' situation:I need to make a replica copy of my database to a reduntantspare computer.The reduntant computer is not running postgres, but postgres isinstalled. 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 berebooted 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.
Are you restricted to keep that second server in that special run- level? If not, I'd consider using pg_standby with WAL archiving to keep your failover server at most a handful of minutes behind.
Erik Jones Software Developer | Emma® [EMAIL PROTECTED] 800.595.4401 or 615.292.5888 615.292.0777 (fax) Emma helps organizations everywhere communicate & market in style. Visit us online at http://www.myemma.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
