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