pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
multiple standby configuration 2+ messages / 2 participants [nested] [flat]
* multiple standby configuration @ 2010-08-31 09:36 Silvio Brandani <silvio.brandani@tech.sdb.it> 0 siblings, 1 reply; 2+ messages in thread From: Silvio Brandani @ 2010-08-31 09:36 UTC (permalink / raw) To: pgsql-admin 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/scp -Cv "%p" host_standby2:/var/lib/pgsql/archivelog/"%f" ' But in this case if the first scp fail, will skip the second scp command ??? Morevoer, is it possible to architect a cascading standby , that means a secondary standby with the archivelog shipped by the first standby primary-> standby1->standby2 Thanks a lot Silvio B. --- Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/news/privacy.html Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_penale_616.html L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei all'attività lavorativa o contrari a norme. -- ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: multiple standby configuration @ 2010-08-31 10:50 Jens Wilke <jens.wilke@affinitas.de> parent: Silvio Brandani <silvio.brandani@tech.sdb.it> 0 siblings, 0 replies; 2+ messages in thread From: Jens Wilke @ 2010-08-31 10:50 UTC (permalink / raw) To: pgsql-admin 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. The shell script can copy the wal files to multiple locations. > is it possible to architect a cascading standby , IIRC, this should be possible in 9.1 HTH, Jens -- Affinitas GmbH | Kohlfurter Straße 41/43 | 10999 Berlin | Germany Geschäftsführer: Lukas Brosseder, David Khalil, Kai Rieke, Christian Vollmann Eingetragen beim Amtsgericht Berlin, HRB 115958 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-08-31 10:50 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-08-31 09:36 multiple standby configuration Silvio Brandani <silvio.brandani@tech.sdb.it> 2010-08-31 10:50 ` Jens Wilke <jens.wilke@affinitas.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox