| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Joao Miguel Ferreira <joao(dot)mc(dot)ferreira(at)criticalsoftware(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: replicating to a stopped server |
| Date: | 2007-10-12 18:59:30 |
| Message-ID: | 470FC412.8050402@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2007-10-12 19:09:15 | Re: replicating to a stopped server |
| Previous Message | Richard Huxton | 2007-10-12 18:57:19 | Re: Need advice on keeping backup database up to date |