replicating to a stopped server

Поиск
Список
Период
Сортировка
От Joao Miguel Ferreira
Тема replicating to a stopped server
Дата
Msg-id 1192212781.3908.0.camel@azagthot.critical.pt
обсуждение исходный текст
Ответы Re: replicating to a stopped server  (Richard Huxton <dev@archonet.com>)
Список 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






В списке pgsql-general по дате отправления:

Предыдущее
От: Matthew Wilson
Дата:
Сообщение: Need advice on keeping backup database up to date
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Out of memory with ODBC