Re: "could not receive data from client" && "incomplete startup packet"

2018-02-08 Thread Tom Lane
David Gauthier writes: > It's a corporate "public" posting, so I can't simply install stuff there. > However, I can request that new version(s) be put there. What version > would you recommend ? The important point is that you should be running the latest, or nearly latest, minor release in whic

Re: "could not receive data from client" && "incomplete startup packet"

2018-02-08 Thread David Gauthier
Hi Alvaro: It's a corporate "public" posting, so I can't simply install stuff there. However, I can request that new version(s) be put there. What version would you recommend ? -dave On Wed, Feb 7, 2018 at 6:24 PM, Alvaro Herrera wrote: > David Gauthier wrote: > > I thin kit's 9.3.2 :-( > > >

Re: "could not receive data from client" && "incomplete startup packet"

2018-02-07 Thread Alvaro Herrera
David Gauthier wrote: > I thin kit's 9.3.2 :-( > > % psql -V > psql (PostgreSQL) 9.3.2 Ah, you're screwed then. My condolences. > These are my options... > ls -ld /tool/pandora64/.package/postgresql* > drwxr-xr-x 8 pandora pandora 4096 Sep 2 2016 > /tool/pandora64/.package/postgresql-8.2.3 >

Re: "could not receive data from client" && "incomplete startup packet"

2018-02-07 Thread David Gauthier
I thin kit's 9.3.2 :-( % psql -V psql (PostgreSQL) 9.3.2 These are my options... ls -ld /tool/pandora64/.package/postgresql* drwxr-xr-x 8 pandora pandora 4096 Sep 2 2016 /tool/pandora64/.package/postgresql-8.2.3 drwxr-xr-x 8 pandora pandora 4096 Sep 16 2013 /tool/pandora64/.package/postgresql-

Re: "could not receive data from client" && "incomplete startup packet"

2018-02-07 Thread David Gauthier
I think I found out what's going on. In the perl script, I'm "forking" a parallel process. The DB connection gets messed up as a consequence (sorry, I can't articulate better because I don't fully understand). But the answer (at least what worked for me), is to formally disconnect and then reconn

Re: "could not receive data from client" && "incomplete startup packet"

2018-02-07 Thread Alvaro Herrera
David Gauthier wrote: > Hi David, thanks for the response. > > I upgraded to 9.3.2 and recreated the DB there. So far, so good. I sincerely hope you mean 9.3.20 and not 9.3.2. There are critical bugs that can eat your data in the 9.3 series prior to 9.3.11, so by all means do upgrade to the lat

Re: "could not receive data from client" && "incomplete startup packet"

2018-02-07 Thread David Gauthier
Hi David, thanks for the response. I upgraded to 9.3.2 and recreated the DB there. So far, so good. But nights are usually the worse time, so we'll see later. There is a more current version of the perl code, but that's not the project default at this time. If the PG upgrade fixes this, I'll be

Re: "could not receive data from client" && "incomplete startup packet"

2018-02-07 Thread David G. Johnston
On Wed, Feb 7, 2018 at 7:34 AM, David Gauthier wrote: > I have a v9.3.0 PG DB on a linux box as the DB server. > ​[...]​ > Any help would be appreciated! > > Upgrade to 9.3.20 and ensure you are using a current version of Perl and DB modules. David J.

"could not receive data from client" && "incomplete startup packet"

2018-02-07 Thread David Gauthier
Hi: I'm experiencing what appears to be an intermittent db connection problem of some sort (although I may be wrong about that). I have a v9.3.0 PG DB on a linux box as the DB server. The client is a virtual machine (also linux) running the same version... *server side:* sqf=# select version();