Archive param questions?

From: Murthy Nunna <mnunna(at)fnal(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Archive param questions?
Date: 2014-04-02 12:49:24
Message-ID: BD7563973EF8894D905C80593EE9A4ED35C9CA@MAIL01.fnal.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can someone please enlighten me or point me to the documentation?

1. What is the role of "archive" and "archive_command" in a slave that is directly fed from master in a simple primary->slave configuration? I want to know both cases where archive = on versus archive = off and their relation to other parameters such as hot_standby.

2. Similarly what is the role of above two settings in a cascading standby? (cascading standby per documentation is defined as the slave that feeds another slave in a cascade configuration). I am talking about slave1 in a primary->slave1->slave2 cascade configuration.

I truly appreciate your responses.

Thanks,
Murthy

Browse pgsql-admin by date

  From Date Subject
Next Message Murthy Nunna 2014-04-02 19:09:57 Cascade Standby - HELP!
Previous Message Scott Ribe 2014-04-01 23:48:55 Re: Cascade Standby Configuration in 9.2.4