[GENERAL] Application crashing due to idle connection

Hi all, Our application is crashing due to lot of idle connection from last 1 month it is very frequent. When i checked pg_stat_activity I found below query :SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid: is on idle state number of

[GENERAL] Multiple Schema in One DB

Hi all, I am in a requirement to have multiple schema in one Database. Schema structure will be same with respect to DB all db objetcs like tables, procedure. However each schema will be accessed by one one application. Problem is as all DB objects are same, when application is calling to a

Re: [GENERAL] Need Help to implement Proximity search feature

knn search, http://www.sai.msu.su/~megera/postgres/talks/pgcon-2010-1.pdf On Wed, Jan 15, 2014 at 8:04 PM, itishree sukla itishree.su...@gmail.com wrote: Deal all, In my project, there is a requirement to implement proximity search feature. We are running a mobile app, for which

[GENERAL] Need Help to implement Proximity search feature

Deal all, In my project, there is a requirement to implement proximity search feature. We are running a mobile app, for which proximity search is require. Can any one guide me how i can achieve this using postgis, or is there any other way i can achieve this. We are using postgresql 9.2. Thanks

[GENERAL] Multi Master Replication

Hi all, I need suggestion about setting up multi master replication between two postgresql server place two different geographical area. As i know using some third party tool like Bucardo,RubyRep it can be achievable, not sue which is the good one to use. If any one can provide me some online

[GENERAL] Full text search

Hello everyone, I am using full text search, however it is not helping me to get the partial value. For example in my document let Pizza Hut is there, if i am searching for Pizza Hut is it giving me the values for only Pizza or a spell mistake like pizz is not returning any thing. any work

Re: [GENERAL] Full text search

Hi Raghavendra, Thanks for your response, however i want same kind of result using full text search. is it possible? Regards, Itishree On Fri, Jul 12, 2013 at 12:14 PM, Raghavendra raghavendra@enterprisedb.com wrote: On Fri, Jul 12, 2013 at 11:48 AM, itishree sukla itishree.su

Re: [GENERAL] Support for Foreign keys with arrays

Thanks, not sure how to download and apply this patch, not getting any down load link. ? On Wed, Jul 10, 2013 at 9:16 AM, Michael Paquier michael.paqu...@gmail.comwrote: On Tue, Jul 9, 2013 at 6:26 PM, itishree sukla itishree.su...@gmail.com wrote: Hello Every one, I have a requirement

[GENERAL] Support for Foreign keys with arrays

Hello Every one, I have a requirement for support for foreign keys with arrays, which is not there in postgresql 9.2, however it is in development for 9.3, i can see there is some thread saying patch is available, can any one please help me to get the patch, or any other work around by which we

[GENERAL] Triggers

Hello Every one, Is Postgresql providing triggers on DB level, schema level ( in same DB)? Regards, Itishree

Re: [GENERAL] Triggers

I didn't get you, you mean trigger is possible on schema level? if yes can you give example. Thank you On Fri, Jul 5, 2013 at 3:56 PM, Jov zhao6...@gmail.com wrote: the later ，in same db jov 在 2013-7-5 下午4:32，itishree sukla itishree.su...@gmail.com写道： Hello Every one, Is Postgresql

Re: [GENERAL] File System backup

yes, when i tried to start, postgresql service using init.d its gave me the error removed stale pid, postgresql failed to start. Regards, Itishree On Sat, Jun 22, 2013 at 8:05 PM, Kevin Grittner kgri...@ymail.com wrote: Alban Hertroys haram...@gmail.com wrote: itishree sukla itishree.su

[GENERAL] File System backup

Hi all, Can any one give me more suggestion, about this problem. Every time my os got restart, postmaster.pid is missing. After that createing postmaster.pid is also not helping to start the server. I am using postgresql 9.2 in ubuntu, with default installation. Is there any possibility i can

Re: [GENERAL] File System backup

, Itishree On Fri, Jun 21, 2013 at 6:10 PM, Amit Langote amitlangot...@gmail.comwrote: On Fri, Jun 21, 2013 at 7:53 PM, itishree sukla itishree.su...@gmail.com wrote: Hi all, Can any one give me more suggestion, about this problem. Every time my os got restart, postmaster.pid is missing

[GENERAL] coalesce function

Hi All, I am using coalesce(firstname,lastname), to get the result if first name is 'NULL' it will give me lastname or either way. I am having data like instead of NULL, blank null ( i mean something like '' ) for which coalesce is not working, is there any workaround or other function available

[GENERAL] Creating Extension pg_trgm

Hi all, I need to create pg_trgm extension, however in my current DB, we have some function based on pg_trgm. when i am trying to create extension, it is asking to drop all dependant function, is there anyway without dropping any dependency i can create this extension. Thanks in advance...

[GENERAL] Views

Hi all, Is there any way, i can know what all views are there on a table by a sql query? Regards, Itishree

[GENERAL] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

Dear All, Can any one please help me to fix this issue, i am getting this error from our application, currently Database is running on 9.2. 2013-04-17 11:37:25:151 - {ERROR} database.ConnectionManager Thread [http-8080-1]; --- getConnection() Exception:

[GENERAL] Re: [GENERAL] Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***

Hi John, Thanks for your reply, however the the address is starting with host 58.137.154.189. It was working fine before, however not working in new system. On Wed, Feb 23, 2011 at 12:39 PM, John R Pierce pie...@hogranch.com wrote: On 02/22/11 10:38 PM, itishree sukla wrote: Hi All

[GENERAL] FATAL: no pg_hba.conf entry for host “::1***

Hi All, I am using System DSN, that connects to postgreSQL, to fetch data from the database, and put into xls sheet .Its working fine with most of the machines and connects fine but on 1 machine i am getting this FATAL: no pg_hba.conf entry for host “::1**”, user “postgres”, database

[GENERAL] Faicng problem while creating system DSN

Hi All, I am creating a system DSN using PostgreSQL Unicode driver, after giving all the server credentials, when i am testing for the connection it is giving, error message like odbcad32.exe has encountered a problem and needs to close. We are sorry for the inconvenience. Can anybody please

[GENERAL] Issue with POSTGIS

Hello , My question is related to some functions in PostGIS. Problem: We are trying to find x points from a table that are within 20 nautical miles from a given point. Would like to use the ST_Dwithin function as it would use the GIST index. I could use the ST_Distance_Spheroid function but

Re: [GENERAL] Hello, i want to subscribe...

On Fri, Apr 3, 2009 at 2:35 AM, Ricardo Fuentes ricardo...@gmail.comwrote: Hello, i want to subscribe to this lists Hi Ricardo, Here is the link to subscribe. http://www.postgresql.org/community/lists/ Regards, Itishree