Re: Regarding PQputline and PQendcopy

Hello,

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?

Thanks,

Soni

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
>