title: How to update local files on all the postgres nodes
body: <p>I have a multi-node Postgres cluster running in High availability mode following the <code>primary-standby</code> architecture.</p>
  <pre><code>postgres-0                                               5/5     Running            0          111s
  postgres-1                                               5/5     Running            0          3m4s
  postgres-monitor-0                                       4/4     Running            0          13m
  </code></pre>
  <p>One of the pod is <code>primary</code> and the other pod is in <code>standby</code> mode which gets replicated from <code>primary</code> in a <code>synchronous</code> manner, while standby remains in the <code>read-only</code> mode.</p>
  <p>I am running the following CRUD commands to update a local file:</p>
  <pre><code>-- Update pg_config to allow access to the users
  create table hba ( lines text );
  copy hba from '/pgsql/data/pg_hba.conf';
  
  insert into hba (lines) values ('host     all              all       0.0.0.0/0    md5');
  insert into hba (lines) values ('host     all              all       ::/0         md5');
  
  copy hba to '/pgsql/data/pg_hba.conf';
  
  -- reload the config
  select pg_reload_conf();
  </code></pre>
  <p>The issue is, the file <code>/pgsql/data/pg_hba.conf</code> is getting updated on the <code>primary</code> node and not on the <code>standby</code> node (as all queries go to master), this means when the <code>primary</code> node goes down and <code>standby</code> becomes a new <code>primary</code> the config changes will be missing.</p>