WAL Replication + PITR

basti wrote:

is it possible to have WAL Replication and Point-in-Time Recovery like
follows:

DB-Master -- (WAL to Slave) --> DB-Slave
|
|-------> (PITR to an other Server)

Thanks for any help!

Sure. You can use something like the UNIX command "tee" in "archive_command"
to create a second copy of the WAL archive.

You could also use the same archived WALs for both purposes and
from several machines by putting them on a network file system.

p.s. is there a tutorial somewhere how describe the steps todo when the
master is crashed?

You will have to promote the standby, make sure future client
requests will go there (a connection pooler or a virtual IP address
can help here) and build a new standby.

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general