Re: [GENERAL] Connection Pooling

2010-03-27 Thread Allan Kamau
On Fri, Mar 26, 2010 at 11:17 PM, David Kerr d...@mr-paradox.net wrote: Howdy all, I have some apps that are connecting to my DB via direct JDBC and I'd like to pool their connections. I've been looking at poolers for a while, and pgbouncer and pgpool-ii seem to be some of the most

Re: [GENERAL] Connection Pooling

2010-03-27 Thread John R Pierce
Allan Kamau wrote: You may also have a look at Commons DBCP from Apache software foundation, http://commons.apache.org/dbcp/;. I have used it for a few projects and have had no problems. for that matter, JDBC has its own connection pooling in java. -- Sent via pgsql-general mailing list

Re: [GENERAL] Get the list of permissions/privileges on schema

2010-03-27 Thread dipti shah
Okay..then could you please suggest me what could be the correct way? So far I have done following to meet my requirements: * I want users to use only stored procedures to create, alter, delete tables in mydb schema*. == For this I have *revoked all permissions from mydb *schema and stored

[GENERAL] How can I import a perl module into a plperl function ?

2010-03-27 Thread Grillo Grillo
Hi, I need to use sscanf in a plperl function. How can I import the module String::Scanf into my function ? Thanks ! Claudio Grillo cjgri...@gmail.com Brazil.

Re: [GENERAL] How can I import a perl module into a plperl function ?

2010-03-27 Thread hubert depesz lubaczewski
On Sat, Mar 27, 2010 at 08:17:26AM -0300, Grillo Grillo wrote: Hi, I need to use sscanf in a plperl function. How can I import the module String::Scanf into my function ? use pl/perlu depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk:

Re: [GENERAL] Large index operation crashes postgres

2010-03-27 Thread Frans Hals
Paul, I kindly received the information about the table data (quoting here): It changes as it goes down the table, it's a right mixture. ST_LineString |2 | 5398548 ST_LineString |3 | 2877681 ST_LineString |4 | 2160809 ST_LineString |

Re: [GENERAL] Large index operation crashes postgres

2010-03-27 Thread Frans Hals
Paul, do you know, if Postgis 1.3.6 will survive, if I install Geos 3.2 over it? Currently, there's Geos 3.1.1 installed. I remember, I had to downgrade Postgis/Geos to be compatible with Postgres 8.3.9. As I herited the database from a 8.3.9 dump, I needed to fit my installation before