Hi,<div><br></div><div>Sorry for the delay in responding- the server I am working on is not easy for me to access to get files off it. Attached is my pgpool.conf file from ServerA. The server is running pgpool 3.0.4.</div>
<div><br></div><div>I'm not really typing commands to create tables. I'm connecting to ServerA using Quantum GIS on a desktop machine, and using a graphical user interface to load data from a file-based format into postgresql. Normally (when not using pgpool) I would connect directly to the primary database host (eg ServerB) on port 5432, but now I'm connecting to the pgpool host (ServerA) on port 9999.</div>
<div><br></div><div>Thanks</div><div><br></div><div>Jo<br><br><div class="gmail_quote">On Thu, Jan 12, 2012 at 5:18 AM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I had hard time to understand your problem because it is not unlikely<br>
happen in usual situation. Please, post more details of your problem<br>
so that I could track it down. I need: pgpool version, pgpool.conf,<br>
and exact commands you typed in(please indicate on which host you typed).<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<div class="im"><br>
> Hi List,<br>
><br>
> Apologies in advance if this is a really simple question but I'm quite<br>
> confused.<br>
><br>
> I have pgpool set up on ServerA, with ServerB as my primary postgresql<br>
> server and ServerC as the secondary postgresql server. These are all<br>
> running Ubuntu 10.04 and Postgresql 9.0. PgPool is the latest version.<br>
> Replication between ServerB and ServerC works fine and recovery of my<br>
> secondary server works fine too.<br>
><br>
> When connected directly to ServerA, I can create tables in ServerA and see<br>
> them visible in ServerB and ServerC. However, when I connect remotely to<br>
> ServerA from a client machine, as the same user, and create a table in<br>
> ServerA, this is only visible from that client machine, and is not visible<br>
> in ServerB or ServerC. The postgresql log files tell me that the table does<br>
> not exist, and on a restart of the server, it is no longer visible.<br>
><br>
> I am not using pool_hba.conf for authentication.<br>
><br>
> I am trying to understand the way that PgPool passes data back to the<br>
> primary server, and I assume that I have a simple permissions problem,<br>
> which is not creating an obvious error. I've asked about this before and<br>
> not got a response, but I would very much like to understand the<br>
> permissions processes that are going on, so that I can resolve this. Can<br>
> someone help?<br>
><br>
> Thanks<br>
><br>
> Jo<br>
><br>
> --<br>
</div>> ***Jo Cook*<br>
<div class="im">> Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18<br>
> 7RL, UK<br>
> t:<a href="tel:%2B44%20750%20095%208167" value="+447500958167">+44 750 095 8167</a><br>
</div>> iShare - Data integration and publishing platform<<a href="http://www.isharemaps.com/" target="_blank">http://www.isharemaps.com/</a>><br>
<div class="im">> See the new Helpdesk and Customer<br>
</div>> portal<<a href="http://support.astuntechnology.com/home" target="_blank">http://support.astuntechnology.com/home</a>><br>
<div class="im">> *****************************************<br>
> Over 35% of the 4 star council websites use iShare - SOCITM Better<br>
> Connected 2010<br>
><br>
> See our customer commendations and<br>
</div>> awards<<a href="http://astuntechnology.com/customers/awards-and-commendations/" target="_blank">http://astuntechnology.com/customers/awards-and-commendations/</a>><br>
<div class="HOEnZb"><div class="h5">><br>
> Company registration no. 5410695. Registered in England and Wales.<br>
> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.<br>
> 864201149.<br>
</div></div></blockquote></div><br><br clear="all"><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>