Streaming Replica Master-Salve Config.

From: Periko Support <pheriko(dot)support(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Streaming Replica Master-Salve Config.
Date: 2016-08-04 15:35:37
Message-ID: CAK2yrTZEV7iOPGhKuqT+RkZT8ZUQEsvKrjuBpefD7q85yGeazQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I'm testing streaming replica with ubuntu 14 and psql9.3.

I'm trying to understand how this works, my plan is to setup the
slave server for pentaho reports for queries only.

Now, my master server it has 128GB max_connections = 200 maybe I will add more.
shared_memory=18GB.

My slave server doesn't have that resources, is a Xeon with 32GB of
RAM with psql same version
running on ubuntu14.

My questions, does the slave server need to have the same resources?
128GB and the same settings in specific max_connections and
shared_memory?

Any comment appreciated, thanks!!!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eduardo Morras 2016-08-04 16:15:01 Re: Streaming Replica Master-Salve Config.
Previous Message Adrian Klaver 2016-08-04 14:41:48 Re: Question on table inheritance and privileges