Skip site navigation (1) Skip section navigation (2)

Re: Regarding PQputline and PQendcopy

From: "soni de" <soni(dot)de(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Regarding PQputline and PQendcopy
Date: 2006-11-30 03:17:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

I wanted this ASAP so asked for "respone" after 6 hours

Sorry for being rude and impatient.

We are planning to switch to postgres 8.1.x, but for that we want to migrate
our older postgres data to newer database.

And we want our own utility for migrating data, so that we can have full
control over our utility.

So we have written our own program for copying data from older postgres to
newer one

We came to know why PQputline returns EOF, that is because of connection is
not alive or because of some problem in connection.

After refreshing the connection it works fine.

But some time program gets hangs in PQendcopy. Below is pstack trace where
postgres goes in hang state:

ff21dce8 poll     (feb05828, 1, ffffffff)

ff1cd6fc select   (5, 0, 0, feb05830, feb05964, feb05828) + 348

ff26ab28 select   (1, 0, 7bba8, 0, ff357964, ff358640) + 34

ff3593bc PQgetResult (7bba8, 0, 0, ff359360, 81707, 0) + 64

ff359f90 PQendcopy (7bba8, a57d8, 70a1c, 7553e0, 7553e0, 0) + 108

Can anyone please tell me why PQendcopy (PQgetResult) goes in hang state?



On 11/29/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> > soni de wrote:
> >> Any response?
> > Yes. First posting this just 6 hours after your original is both
> > impatient and rude.
> > Second, you should upgrade to a modern and supported version of
> > Postgres. Nobody is going to want to support you on a version as out of
> > date as 7.2.4.
> And third, this was not a hacker-grade question.
>                        regards, tom lane

In response to


pgsql-hackers by date

Next:From: Gavin SherryDate: 2006-11-30 03:33:26
Subject: elog(FATAL)ing non-existent roles during client authentication
Previous:From: Pavel StehuleDate: 2006-11-29 23:32:26
Subject: Re: this patch correct upper and lower case for translated month's and

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group