Re: Streaming Replica Master-Salve Config.

On 8/5/16 12:35 AM, Periko Support wrote:
> 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?

max_connections must be the same (or higher) on the standby
as on the master:

https://www.postgresql.org/docs/current/static/runtime-config-connection.html#GUC-MAX-CONNECTIONS

but shared_buffers (which is what I guess you mean with "shared_memory")
can be a different value appropriate to the standby's hardware resources.

Regards

Ian Barwick

--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services