[ADMIN] multiple standby configuration

2010-08-31 Thread Silvio Brandani
Is it possible to have multiple host destinations in the archive_command parameter of postgresql.conf to be able to mantain 2 standby datbase with write ahead log??? Can we use something like: archive_command = '/usr/bin/scp -Cv "%p" host_standby1:/var/lib/pgsql/archivelog/"%f" && /usr/bin/sc

Re: [ADMIN] multiple standby configuration

2010-08-31 Thread Jens Wilke
Am Dienstag 31 August 2010 11:36:31 schrieb Silvio Brandani: > Is it possible to have multiple host destinations in the archive_command > parameter of postgresql.conf to be able to mantain 2 standby datbase > with write ahead log??? You have to write a shell script and run this as archive command