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 time.
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
sch
; http://www.sai.msu.su/~megera/postgres/talks/pgcon-2010-1.pdf
>
> On Wed, Jan 15, 2014 at 8:04 PM, itishree sukla
> wrote:
> > Deal all,
> >
> > In my project, there is a requirement to implement proximity search
> feature.
> > We are running a mobile app,
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
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
doc
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 su
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 arou
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
wrote:
> On Tue, Jul 9, 2013 at 6:26 PM, itishree sukla
> wrote:
> > Hello Every one,
> >
> > I have a requirement for support for
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 ca
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 wrote:
> the later ,in same db
>
> jov
> 在 2013-7-5 下午4:32,"itishree sukla" 写道:
>
> Hello Every one,
>>
>>
Hello Every one,
Is Postgresql providing triggers on DB level, schema level ( in same DB)?
Regards,
Itishree
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 wrote:
> Alban Hertroys wrote:
> > itishree sukla wrote:
>
> >> Can
.
Regards,
Itishree
On Fri, Jun 21, 2013 at 6:10 PM, Amit Langote wrote:
> On Fri, Jun 21, 2013 at 7:53 PM, itishree sukla
> wrote:
> > Hi all,
> >
> > Can any one give me more suggestion, about this problem. Every time my os
> > got restart, postmaster.pid is missin
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 tak
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
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...
Reg
Hi all,
Is there any way, i can know what all views are there on a table by a sql
query?
Regards,
Itishree
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:
org.apache.commons.dbcp.SQLNestedException
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 wrote:
> On 02/22/11 10:38 PM, itishree sukla wrote:
>
>>
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 “myDat
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
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 tha
On Fri, Apr 3, 2009 at 2:35 AM, Ricardo Fuentes wrote:
> Hello, i want to subscribe to this lists
>
Hi Ricardo,
Here is the link to subscribe.
http://www.postgresql.org/community/lists/
Regards,
Itishree
23 matches
Mail list logo