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

[Tatsuo Ishii]

I guess "Quantum GIS" actually does not connect to pgpool on ServerA
(nor SeverB and ServerC, I think).  I suggest you turn on
log_connections in pgpool.conf and restart pgpool. This will show log
when Quantum GIS" actually connects to pgpool. If you do not see the
log, there's something wrong with setup of Quantum GIS.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
> 
> 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.
> 
> 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.
> 
> Thanks
> 
> Jo
> 
> On Thu, Jan 12, 2012 at 5:18 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> 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.
>>
> 
> 
> 
> -- 
> ***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.