Re: psql \copy hanging - Mailing list pgsql-general

From Adrian Klaver
Subject Re: psql \copy hanging
Date
Msg-id 9e9164df-e7b7-bcd3-538a-7714907f7df4@aklaver.com
Whole thread Raw
In response to psql \copy hanging  ("Arnaud L." <arnaud.listes@codata.eu>)
Responses Re: psql \copy hanging
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: performance of pg_upgrade "Copying user relation files"
Next
From: "Arnaud L."
Date:
Subject: Re: psql \copy hanging