Re: [GENERAL] Git host for postgresql related projects

2013-04-14 Thread Sumit Raja
Assembla does free git repositories as well http://www.assembla.com/ On 14 April 2013 05:22, Francisco Figueiredo Jr. wrote: > > Hi, Magnus! > > How you doing? > > > Today I have a "mirror" at github which I'm using to test and learn git > and it seems to be very good. Git is very powerful and i

[GENERAL] JDBC and array of points

2013-02-22 Thread Sumit Raja
Hi, I've posted this to the postgis user group as well, but I think the issue may just be with my inability to understand the explicit casting in 9.2. I have code that generates a PreparedStatement that accepts an array of points in an ANY clause. I convert the point objects in java to a string "

Re: [GENERAL] Best method to compare subdomains

2013-01-17 Thread Sumit Raja
On 16 January 2013 20:23, Robert James wrote: > Is there a recommended, high performance method to check for subdomains? > > Something like: > - www.google.com is subdomain of google.com > - ilikegoogle.com is not subdomain of google.com > > There are many ways to do this (lowercase and reverse t

[GENERAL] FTS for a controlled vocab

2012-10-10 Thread Sumit Raja
Hello, I am trying to identify how best to handle the situation where a controlled vocabulary needs to be searched on using full text search. I have a list of brand names that have, what FTS deems, blank characters in them that I need to search against. E.g. (+)people, D&G, 100% Design. These pa

Re: [GENERAL] db server processes hanging around

2012-06-20 Thread Sumit Raja
Or ask your Java devs to investigate why the shut down does not close the physical connection properly. Does IDEA claim to shut down Tomcat but actually it is still running because of a threads not being cleaned up? Are you sure this isn't happening during normal operation of the application? If i

Re: [GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

2012-05-17 Thread Sumit Raja
pool? > > Best regards, > Paulo Correia > > On 15/05/12 09:01, Sumit Raja wrote: >> >> On 14 May 2012 17:28, Paulo Correia  wrote: >>> >>> Hello all! >>> Having a Postgres 9.0 with assynchronous streaming replication to a >>> hot-stan

Re: [GENERAL] Postgres 9.0 Streaming Replication and Load Balancing?

2012-05-15 Thread Sumit Raja
On 14 May 2012 17:28, Paulo Correia wrote: > Hello all! > Having a Postgres 9.0 with assynchronous streaming replication to a > hot-standby slave, both with CentOs 5.6, how can I use both DB instances for > query load balancing? > I've tried with pgPool-II but the pooling mechanism is disruptive

Re: [GENERAL] Which Java persistence library would you use with PostgreSQL?

2012-05-02 Thread Sumit Raja
> value="jdbc:postgresql://localhost:5432/MySampleDb"/> > > If you add ";create=true" just as in the example above, it breaks the code > and you get this as a result: > > org.postgresql.util.PSQLException: FATAL: database "MySampleDb;create=true" > does not exist "create=true" is a Derby specific