title: Postgresql pg_dump adding public to all schema names
body: <p>I'm still a relative newbie to Postgresql, so pardon if this is simple ignorance.  </p>
  
  <p>I've setup a active/read-only pacemaker cluster of Postgres v9.4 per the cluster labs documentation.</p>
  
  <p>I'm trying to verify that both databases are indeed in sync.  I'm doing the dump on both hosts and checking the diff between the output.  The command I'm using is:</p>
  
  <pre><code>pg_sql -U myuser mydb &gt;dump-node-1.sql
  </code></pre>
  
  <p>Pacemaker shows the database status as 'sync' and querying Postgres directly also seems to indicate the sync is good... (Host .59 is my read-only standby node)</p>
  
  <pre><code>psql -c "select client_addr,sync_state from pg_stat_replication;"
  +---------------+------------+
  |  client_addr  | sync_state |
  +---------------+------------+
  | 192.16.111.59 | sync       |
  +---------------+------------+
  (1 row)
  </code></pre>
  
  <p>However, when I do a dump on the read-only host I end up with all my tables having 'public.' added to the front of the names.  So table foo on the master node dumps as 'foo' whereas on the read-only node it dumps as 'public.foo'.  I don't understand why this is happening...  I had done a 9.2 Postgresql cluster in a similar setup and didn't see this issue.  I don't have tables in the public schema on the master node...</p>
  
  <p>Hope someone can help me understand what is going on.</p>
  
  <p>Much appreciated!</p>