Re: could not send data to client: Permission denied

2020-08-27 Thread Daniel Jakots
On Thu, 27 Aug 2020 12:44:11 -0400, Tom Lane wrote: > It looks like send() itself is returning EACCES, which seems just > weird. The send(2) man page does cite some possible causes of > EACCES, but none of them seem relevant here. Oh, send(2) on OpenBSD [1] says that the firewall may cause suc

Re: could not send data to client: Permission denied

2020-08-27 Thread Tom Lane
Daniel Jakots writes: > On Thu, 27 Aug 2020 09:04:25 -0700, Adrian Klaver > wrote: >> Are you using some sort of authentication for the API? > Sorry I'm not sure what you mean? > Between the clients and the python code I use some "basic auth" (and IP > restrictions on the reverse proxy). But I

Re: could not send data to client: Permission denied

2020-08-27 Thread Daniel Jakots
On Thu, 27 Aug 2020 09:04:25 -0700, Adrian Klaver wrote: > > In postgresql log, it says: > > Aug 27 02:10:02 db1 postgres[62464]: [7-1] > > 10.10.10.43(41816):[unknown]@[unknown]: LOG: connection received: > > host=10.10.10.43 port=4181 Aug 27 02:10:02 db1 postgres[62464]: > > [8-1] 10.10.10.43(

Re: could not send data to client: Permission denied

2020-08-27 Thread Adrian Klaver
On 8/27/20 8:28 AM, Daniel Jakots wrote: Hi, I run a flask rest api which use postgres to store data. I've been using it for a few months and it worked flawlessly. I recently got an error twice (58h10m apart). I added a lot more data a few days ago which could be the reason I get this now, but t