Comment 13 for bug 63141

I have marked all the moodle reports as duplicates of this bug. They exhibit the same symptoms as each other.

The workaround for the pg_connect generic bug is to disable the ssl connection. Manually altering the moodle connect string in connection library to disable ssl also removes the segmentation fault in the moodle cron run.

The very simple patch I used to test moodle is at the bottom. This is a workaround for the moodle problem if you don't need to use SSL for your moodle db connections. You could also disable ssl connections at the postgresql end by;

1. ssl = false in postgresql.conf
2. alter pg_hba.conf to only have a hostnossl entry for the moodle user.

2 is a better option as it doesn't disable all instances of ssl on the server. It also will be faster for moodle as negotiating SSL is slow.

Overall the underlying problem is exactly the same, hence they are all duplicates.

--- adodb-postgres64.inc.php.orig 2008-11-04 20:26:31.000000000 +1100
+++ adodb-postgres64.inc.php 2008-11-04 20:19:02.000000000 +1100
@@ -668,6 +668,7 @@
        if ($user) $str .= " user=".$user;
        if ($pwd) $str .= " password=".$pwd;
     if ($db) $str .= " dbname=".$db;
+ $str .= " sslmode=disable";
   }

   //if ($user) $linea = "user=$user host=$linea password=$pwd dbname=$db port=5432";