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
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 Sherry||Date: 2006-11-30 03:33:26|
|Subject: elog(FATAL)ing non-existent roles during client authentication|
|Previous:||From: Pavel Stehule||Date: 2006-11-29 23:32:26|
|Subject: Re: this patch correct upper and lower case for translated month's and|