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

 

Andrew Dunstan <andrew@dunslane.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