Search Postgresql Archives

Re: replicating to a stopped server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux