Hi All
I have created a function in C language . This is to be called from a pgsql
function .
Let say the C language function name is test1 and pgsql function name is
test .
test1 is called from test three times with different arguments . For
example :
test ()
begin
test1(arg1);--test1 is
Hi All
Please help me .
Thanks...
Tamanna
On Mon, Dec 5, 2011 at 12:45 PM, tamanna madaan
tamanna.mad...@globallogic.com wrote:
Hi Tomas
I tried it on the system having postgres-8.4.0 . And the behavior is same
.
Cluster means a group of machines having postgres installed on all
at 7:28 PM, Tomas Vondra t...@fuzzy.cz wrote:
On 1 Prosinec 2011, 12:57, tamanna madaan wrote:
Hi Craig
I am able to reproduce the issue now . I have postgres-8.1.2 installed in
cluster setup.
Well, the first thing you should do is to upgrade, at least to the last
8.1 minor version
using the setsockopt interface. I wonder if
postgres8.1.2 supports / request for system level keepalive control ?? If
not, then which release/version of postgres supports that ??
Thanks...
Tamanna
On Tue, Nov 29, 2011 at 4:56 PM, tamanna madaan
tamanna.mad...@globallogic.com wrote:
well, one
well, one question : Is tcp-keep-alive enabled by default in postgres-8.1.2 .
I am using postgres on linux platform .
On Tue, Nov 29, 2011 at 8:51 AM, tamanna madaan
tamanna.mad...@globallogic.com wrote:
Hi Craig
Thanks for your reply . But unfortunately I dont have that process running
to execute) is rebooted . What
could be the reason ??
Thanks...
--
Tamanna Madaan | Associate Consultant | GlobalLogic Inc.
Leaders in Software RD Services
ARGENTINA | CHILE | CHINA | GERMANY | INDIA | ISRAEL | UKRAINE | UK | USA
Office: +0-120-406-2000 x 2971
www.globallogic.com
issues have any role in that . Please help.
Thanks
Regards
Tamanna
On Tue, Nov 29, 2011 at 7:58 AM, Craig Ringer ring...@ringerc.id.au wrote:
On 11/28/2011 05:30 PM, tamanna madaan wrote:
Hi All
I have postgres installed in cluster setup. My system has a script
which executes the below
Can anyone please suggest me on this .
Thanks..
Tamanna
On Thu, Aug 18, 2011 at 2:47 PM, tamanna madaan
tamanna.mad...@globallogic.com wrote:
Hi
Yes , restarting the slon resolves the issue. But. there are other
processes also in my application which connect to postgres . Those
processes
at 11:14 PM, tamanna madaan
tamanna.mad...@globallogic.com wrote:
Hi All
I am using postgres-8.4.0 on a cluster setup with slony-2.0.4 being used
for replication.
Recently , I saw a idle in transaction postgres process as below.
postgres 13052 14742 0 May13 ? 00:00:00 postgres: slon abc
Hi All
I am using postgres-8.4.0 on a cluster setup with slony-2.0.4 being used for
replication.
Recently , I saw a idle in transaction postgres process as below.
postgres 13052 14742 0 May13 ? 00:00:00 postgres: slon abc 172.16.1.1(49017)
idle in transaction
I wonder what could have lead to
Hi All
I am using a cluster setup having postgres-8.4.0 and slon 2.0.4 is being
used for replication . It happened that the autovacuum was not running
successfully on one of the nodes in cluster and was giving error :
2011-05-13 23:07:42 CDTERROR: canceling autovacuum task
2011-05-13 23:07:42
Thanks Daniele
-Original Message-
From: Daniele Varrazzo [mailto:daniele.varra...@gmail.com]
Sent: Wed 4/20/2011 1:15 AM
To: tamanna madaan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] setting connection/ query timeout
On Tue, Apr 19, 2011 at 8:09 PM, tamanna madaan
Hi All
I am using postgres-8.1.2 . In postgresql.conf I have set :
#statement_timeout = 0
I am executing the below query just to check if postgres is allowing
connections or not .
psql -Uslon -ddb_name -h IP -c select 1;
Sometimes this query gets stuck for unknown reason . So, for this
Hi All
I am using postgres-8.4.0 and psqlodbc-08.03.0400-1 and unixODBC-2.2.14-000.01
driver to connect
to the database. One of the queries I executed from my application have got
stuck for an
indefinite amount of time causing my application to hang. So I cored the
application. The
core file
application is
multi threaded .
Tamanna
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Fri 3/18/2011 8:56 PM
To: tamanna madaan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] SOCK_wait_for_ready function call caused a query to get
stuck
On Fri, Mar
From: Alban Hertroys [mailto:dal...@solfertje.student.utwente.nl]
Sent: Fri 12/31/2010 3:28 PM
To: tamanna madaan
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] query stuck at SOCK_wait_for_ready function call
On 31 Dec 2010, at 5:14, tamanna madaan wrote
Hi All
I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver to
connect
to the databse. One of the queries I executed from my appilcation have got
stuck for an
indefinite amount of time causing my application to hang. So I cored the
application. The
core file gives a
...@sss.pgh.pa.us]
Sent: Thu 12/30/2010 11:23 PM
To: tamanna madaan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] query stuck at SOCK_wait_for_ready function call
tamanna madaan tamanna.ma...@globallogic.com writes:
I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver
...
Tamanna
-Original Message-
From: tamanna madaan
Sent: Thursday, September 09, 2010 7:25 PM
To: 'Michael Glaesemann'; 'Scott Marlowe'
Cc: 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] error while autovacuuming
Hi All
Can I upgrade directly to postgres-8.4 . I think it would
Thanks a lot Scott ...
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Saturday, October 02, 2010 3:14 AM
To: tamanna madaan
Cc: Michael Glaesemann; pgsql-general@postgresql.org
Subject: Re: [GENERAL] error while autovacuuming
On Fri, Oct 1, 2010 at 2:06
Thanks Scott for your reply ...
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Wednesday, September 15, 2010 7:36 AM
To: tamanna madaan
Cc: David Fetter; pgsql-general@postgresql.org
Subject: Re: [GENERAL] workaround steps for autovaccum problem
On Tue
Hi All
I am using postgres-8.1.2. I am getting the following error while
autovacuum.
2010-08-18 18:36:14 UTC LOG: autovacuum: processing database template0
2010-08-18 18:36:14 UTC ERROR: could not access status of transaction
3222599682
2010-08-18 18:36:14 UTC DETAIL: could not open file
every 20 mins as
I mentioned above.
Please confirm ...
-Original Message-
From: David Fetter [mailto:da...@fetter.org]
Sent: Wednesday, September 15, 2010 3:27 AM
To: tamanna madaan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] workaround steps for autovaccum problem
On Wed
Hi All
Can I upgrade directly to postgres-8.4 . I think it would also be having
the fix for autovacuum error which is there in postgres-8.1.6 . But
please confirm .
Thanks..
Tamanna
-Original Message-
From: tamanna madaan
Sent: Thursday, September 09, 2010 2:40 AM
To: 'Michael
can find the information about this fix and code changes done
for this fix.
Thanks..
Tamanna
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Thursday, September 09, 2010 1:45 AM
To: tamanna madaan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL
Hi All
I am using postgres-8.1.2 . I am getting the below error while
autovacuuming template0 database :
2010-08-18 18:36:14 UTC LOG: autovacuum: processing database template0
2010-08-18 18:36:14 UTC ERROR: could not access status of transaction
3222599682
2010-08-18 18:36:14 UTC DETAIL:
Hi David
You mean to say , change the binary to postgres-8.1.21 and then restart
postgres . that's it ?? please confirm..
Thanks..
Tamanna
-Original Message-
From: David Fetter [mailto:da...@fetter.org]
Sent: Friday, September 10, 2010 2:06 AM
To: tamanna madaan
Cc: Scott Marlowe
Ok . Thanks ..
-Original Message-
From: David Fetter [mailto:da...@fetter.org]
Sent: Friday, September 10, 2010 2:36 AM
To: tamanna madaan
Cc: Scott Marlowe; pgsql-general@postgresql.org
Subject: Re: [GENERAL] error while autovacuuming
On Fri, Sep 10, 2010 at 02:35:29AM +0530, tamanna
Hi All
Can a postgres patch for the fix ( provided in postgres-8.1.6 for
autovacuum error ) be included with the postgres version I am using i.e
postgres 8.1.2 so that I don't have to upgrade to 8.1.21 ??
Please reply
Thanks...
Tamanna
-Original Message-
From: tamanna madaan
Sent
To: Scott Marlowe
Cc: tamanna madaan; pgsql-general@postgresql.org
Subject: Re: [GENERAL] error while autovacuuming
On Sep 8, 2010, at 16:15 , Scott Marlowe wrote:
On Wed, Sep 8, 2010 at 1:11 PM, tamanna madaan
tamanna.ma...@globallogic.com wrote:
Hi All
Can a postgres patch for the fix
Hi All
Any idea about this problem ??
Thanks..
Tamanna
-Original Message-
From: tamanna madaan
Sent: Fri 8/20/2010 11:54 AM
To: pgsql-general@postgresql.org
Subject: error while autovacuuming
Hi All
I am using a cluster setup with two nodes in it . postgres version is 8.1.2
..
Tamanna
-Original Message-
From: David Fetter [mailto:da...@fetter.org]
Sent: Saturday, July 17, 2010 8:45 PM
To: Merlin Moncure
Cc: tamanna madaan; pgsql-general@postgresql.org
Subject: Re: [GENERAL] cache lookup failed for function 19119
On Thu, Jul 15, 2010 at 10:21:52AM -0400, Merlin
Hi All
I am using postgres-8.1.2 .
And getting this error cache lookup failed for function 19119.
Can anyone please let me know what could have gone wrong.
How can a function go missing . And which function
Its talkig about ?? its some postgres's internal function or a user
defined
...@gmail.com]
Sent: Tuesday, July 13, 2010 1:14 PM
To: tamanna madaan
Cc: pgsql-general@postgresql.org; Tapin Agarwal
Subject: Re: [GENERAL] attempted to lock invisible tuple error while
update
On Mon, Jul 12, 2010 at 11:54 PM, tamanna madaan
tamanna.ma...@globallogic.com wrote:
Hi Scott
Thanks
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Friday, July 09, 2010 9:35 PM
To: tamanna madaan
Cc: pgsql-general@postgresql.org; Tapin Agarwal
Subject: Re: [GENERAL] attempted to lock invisible tuple error while update
On Thu, Jul 8, 2010 at 10:56 PM
Hi All
I am using a cluster setup with two nodes in it. Replication between
two nodes is being done through slony.
Postgres version is 8.1.2 and slony version is 1.1.5 .
I am running an operation that does thousands of update/inserts/delete
on some tables. While running update query
Hi All
I am using postgres-8.1.2.
Can anyone please let me know if autovacuum in postgres-8.1.2 uses
prepared transactions.
Thanks a lot in advance
Regards
Tamanna
Thanks Tom ...
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, January 12, 2010 1:35 AM
To: tamanna madaan
Cc: pgsql-general@postgresql.org; Gaurav Katiyar
Subject: Re: [GENERAL] does autovacuum in postgres-8.1.2 use prepared
transactions ??
tamanna madaan
Hi All
I am using postgres-8.1.2 and slony-1.1.5 for replication.
I have 1 master and 1 slave in my cluster.
Sometimes I see problem of missing logtriggers and denyaccess triggers
on master table and slave tables respectively. Replication don't take place in
that
state though systems are
Hi All
I have a cluster setup with one master and one slave . Replication from
master to slave is not taking place.
I am getting this error duplicate key violates unique constraint in
my slon.log on slave . This error is thrown while
Slon is inserting a row in a table on slave. This
Hi
I am using postgres 8.1.2 with slony 1.1.5 used for replication between two
nodes. Very high number of db operations like (2.8 million inserts, 1.4 million
update and 4.5 lakhs deletes.) are being done on db in one transaction and this
is repeated for 5-6 times a day at an interval of let
41 matches
Mail list logo