[pgpool-general: 145] Re: Relation does not exist

[Tatsuo Ishii]

I had hard time to understand your problem because it is not unlikely
happen in usual situation. Please, post more details of your problem
so that I could track it down.  I need: pgpool version, pgpool.conf,
and exact commands you typed in(please indicate on which host you typed).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi List,
> 
> Apologies in advance if this is a really simple question but I'm quite
> confused.
> 
> 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.
> 
> 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.
> 
> I am not using pool_hba.conf for authentication.
> 
> 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?
> 
> Thanks
> 
> Jo
> 
> -- 
> ***Jo Cook*
> Astun Technology Ltd, The Coach House, 17 West Street, Epsom, Surrey, KT18
> 7RL, UK
> t:+44 750 095 8167
> iShare - Data integration and publishing platform<http://www.isharemaps.com/>
> See the new Helpdesk and Customer
> portal<http://support.astuntechnology.com/home>
> *****************************************
> Over 35% of the 4 star council websites use iShare - SOCITM Better
> Connected 2010
> 
> See our customer commendations and
> awards<http://astuntechnology.com/customers/awards-and-commendations/>
> 
>  Company registration no. 5410695. Registered in England and Wales.
> Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
> 864201149.