Hi List,<div><br></div><div>Apologies in advance if this is a really simple question but I'm quite confused.</div><div><br></div><div>I have pgpool set up on ServerA, with ServerB as my primary postgresql server and ServerC as the secondary postgresql server. These are all running Ubuntu 10.04 and Postgresql 9.0. PgPool is the latest version. Replication between ServerB and ServerC works fine and recovery of my secondary server works fine too.</div>
<div><br></div><div>When connected directly to ServerA, I can create tables in ServerA and see them visible in ServerB and ServerC. However, when I connect remotely to ServerA from a client machine, as the same user, and create a table in ServerA, this is only visible from that client machine, and is not visible in ServerB or ServerC. The postgresql log files tell me that the table does not exist, and on a restart of the server, it is no longer visible.</div>
<div><br></div><div>I am not using pool_hba.conf for authentication.</div><div><br></div><div>I am trying to understand the way that PgPool passes data back to the primary server, and I assume that I have a simple permissions problem, which is not creating an obvious error. I've asked about this before and not got a response, but I would very much like to understand the permissions processes that are going on, so that I can resolve this. Can someone help?</div>
<div><br></div><div>Thanks</div><div><br></div><div>Jo</div><div><div><br></div>-- <br><div><b></b><b>Jo Cook</b><br>Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18 7RL, UK <br>
t:+44 750 095 8167<br><div>
<a href="http://www.isharemaps.com/" target="_blank">iShare - Data integration and publishing platform</a><br>
<a href="http://support.astuntechnology.com/home" target="_blank">See the new Helpdesk and Customer portal</a><br>
***************************************** <br>
<font color="red">Over 35% of the 4 star council websites use iShare - SOCITM Better Connected 2010</font></div></div><div><font color="#ff0000"><br></font><a href="http://astuntechnology.com/customers/awards-and-commendations/" target="_blank">See our customer commendations and awards</a><br>
<br>
<font size="0.7em">
Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN
VAT no. 864201149.</font></div><br>
</div>