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-8.3.0
drwxr-xr-x 6 pandora pandora 4096 Aug 31 2015
/tool/pandora64/.package/postgresql-9.0.2
drwxr-xr-x 6 pandora pandora 4096 Oct 11 2013
/tool/pandora64/.package/postgresql-9.3.0
drwxr-xr-x 6 pandora pandora 4096 May 30 2014
/tool/pandora64/.package/postgresql-9.3.2
drwxr-xr-x 6 pandora pandora 4096 Oct 19 2016
/tool/pandora64/.package/postgresql-9.6.0
What about 9.6.0 ?
On Wed, Feb 7, 2018 at 4:47 PM, David Gauthier <davegauthie...@gmail.com>
wrote:
> 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 reconnect back in the main thread.
> Fortunately, I don't have any outstanding transactions at that time so I
> don't lose anything as far as that's concerned.
>
> my $pid = fork()
>
> if($pid == 0) {
> <do whatever the forked proc needs to do>
> }
>
> $dbh->disconnect();
> $dbh->connect(...)
>
> proceed with the rest of the perl script.
>
> On Wed, Feb 7, 2018 at 11:59 AM, David Gauthier <davegauthie...@gmail.com>
> wrote:
>
>> 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 happy
>> with that, else I'll point to the more recent perl versions.
>>
>> Thanks Again
>>
>> On Wed, Feb 7, 2018 at 9:47 AM, David G. Johnston <
>> david.g.johns...@gmail.com> wrote:
>>
>>> On Wed, Feb 7, 2018 at 7:34 AM, David Gauthier <davegauthie...@gmail.com
>>> > 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.
>>>
>>>
>>
>
