replicating to a stopped server

From: Joao Miguel Ferreira <jmcferreira(at)criticalsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: replicating to a stopped server
Date: 2007-10-12 15:54:48
Message-ID: 1192204488.5673.78.camel@azagthot.critical.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

a) So... how do I replicate a database to a stopped postgres ?

b) Is it safe just to copy the /var/lib/pg/* directories to the right
place and let Pg boot on that ?

c) I know the right tool for this should be 'pg_dump' but it needs a
live postgres daemon running, in order to install the replica. Is this
correct ?

d) Is it viable to start postgres directlly from the dump ? by
specifying the dump-file in the cmd line ?

thx a lot
joao

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-10-12 16:00:46 Re: Coercing compound types to use generic ROW comparison operators
Previous Message Scott Marlowe 2007-10-12 15:54:27 Re: Missing files under pg_data following power failure