Hi, I have set up the latest version of pgpool on an Ubuntu server running postgresql 9.0, with two other ubuntu servers, also running postgresql 9.0, in streaming replication mode.
The replication part is fine- changes propagate through to the standby server. Pgpool can see both servers, and seems to be fine as well, and I can connect to the databases through pgpool and see all the tables that were present before pgpool was installed. However, if I connect to pgpool as anything other than the postgres superuser, any new tables created since pgpool was installed, don't show up, even though I can see them (as a non-superuser) if I connect directly to the primary or secondary server. I have checked basic permissions and have restarted pgpool. I don't understand if this is a permissions issue or some sort of cached connection problem but I've looked at all the settings in pgpool.conf to do with caches and can't see a problem. I'm quite new to pgpool (this is the first time I've set it up on a production server) so there may be something very basic that I'm missing, but please 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.
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
