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