Re: psql \copy hanging

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: arnaud(dot)listes(at)codata(dot)eu, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql \copy hanging
Date: 2019-10-03 13:54:58
Message-ID: 9e9164df-e7b7-bcd3-538a-7714907f7df4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/2/19 11:51 PM, Arnaud L. wrote:
> Hi list,
>
> Le 28/08/2019 à 09:43, Luca Ferrari a écrit :
>> I don't want to be pedantic, but I would have tried with a single
>> change at a time.
>> And my bet is: the local file would do the trick (i.e., it is a weird
>> share problem).
>
> Well, this problem is still bugging me, and this time I've tried with a
> local file. Unfortunately, it did not help.
> To further rule out filesystem problems, I first took care to delete the
> target files before copying to it, but it did not help either.
>
> So now I'm quite confident that the problem is either psql or even
> postgresql itself.
>
> Does anyone know of anything I could try to try to fix or debug this ?

Going back to the original thread I noticed it was not specified what
program was being used to run the script in the overnight session.

So what is being used to run the script overnight?

>
> Thanks a lot for your help!
>
> Regards
> --
> Arnaud
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arnaud L. 2019-10-03 14:13:31 Re: psql \copy hanging
Previous Message Adrian Klaver 2019-10-03 13:46:59 Re: performance of pg_upgrade "Copying user relation files"