<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <tt>Hi,<br>
      <br>
      I have an 9.5.19 (on Ubuntu) and works ok.<br>
      <br>
      Regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>

</pre>
    <div class="moz-cite-prefix">On 4/22/20 3:44 PM, Nayani Nikeshala
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:1119346896.578368.1587559461192@mail.yahoo.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div class="ydpeb8bea13yahoo-style-wrap"
        style="font-family:Helvetica Neue, Helvetica, Arial,
        sans-serif;font-size:16px;">
        <div dir="ltr" data-setdir="false">Hi Bogdan,</div>
        <div dir="ltr" data-setdir="false"><br>
        </div>
        <div dir="ltr" data-setdir="false">I found an old email, where
          he has faced a similar kind of an issue with PSQL 9.2 also. I
          believe, it will not get resolved with PSQL version. </div>
        <div dir="ltr" data-setdir="false"><br>
        </div>
        <div dir="ltr" data-setdir="false"><span><a
              href="https://opensips.org/pipermail/devel/2015-June/017666.html"
              rel="nofollow" target="_blank" moz-do-not-send="true">https://opensips.org/pipermail/devel/2015-June/017666.html</a></span><br>
        </div>
        <div><br>
        </div>
        <div dir="ltr" data-setdir="false">According to the email, he
          has resolved it by modifying makefile, but I'm not sure, how
          he did that.</div>
        <div dir="ltr" data-setdir="false"><br>
        </div>
        <div dir="ltr" data-setdir="false"><br>
        </div>
      </div>
      <div id="yahoo_quoted_8404259530" class="yahoo_quoted">
        <div style="font-family:'Helvetica Neue', Helvetica, Arial,
          sans-serif;font-size:13px;color:#26282a;">
          <div> On Wednesday, April 22, 2020, 01:54:09 PM GMT+5:30,
            Bogdan-Andrei Iancu <a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a> wrote: </div>
          <div><br>
          </div>
          <div><br>
          </div>
          <div>
            <div id="yiv3030998548">
              <div> <tt>It may sound weird, but maybe you into the
                  other extrema, with some too new version :D...<br
                    clear="none">
                  <br clear="none">
                  Is it possible to try some 9.3 or so ?<br clear="none">
                  <br clear="none">
                  Regards, </tt><br clear="none">
                <pre class="yiv3030998548moz-signature">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a rel="nofollow" shape="rect" class="yiv3030998548moz-txt-link-freetext" target="_blank" href="https://www.opensips-solutions.com" moz-do-not-send="true">https://www.opensips-solutions.com</a>

</pre>
                <div class="yiv3030998548yqt9174662582"
                  id="yiv3030998548yqt86238">
                  <div class="yiv3030998548moz-cite-prefix">On 4/21/20
                    10:35 PM, Nayani Nikeshala wrote:<br clear="none">
                  </div>
                  <blockquote type="cite"> </blockquote>
                </div>
              </div>
              <div class="yiv3030998548yqt9174662582"
                id="yiv3030998548yqt35619">
                <div>
                  <div class="yiv3030998548ydp262fd7bayahoo-style-wrap"
                    style="font-family:Helvetica Neue, Helvetica, Arial,
                    sans-serif;font-size:16px;">
                    <div dir="ltr">Hi Bogdan,</div>
                    <div dir="ltr"><br clear="none">
                    </div>
                    <div dir="ltr">I removed psql 8.4 and installed psql
                      9.6. </div>
                    <div dir="ltr"><br clear="none">
                    </div>
                    <div dir="ltr">
                      <div>
                        <div>[root@SIPserver opensips-2.4.7]# yum list
                          installed | grep postgre</div>
                        <div>postgresql96.i686        9.6.17-1PGDG.rhel6</div>
                        <div>postgresql96-devel.i686  9.6.17-1PGDG.rhel6</div>
                        <div>postgresql96-libs.i686   9.6.17-1PGDG.rhel6</div>
                        <div>postgresql96-server.i686 9.6.17-1PGDG.rhel6</div>
                        <div>[root@SIPserver opensips-2.4.7]#</div>
                        <div><br clear="none">
                        </div>
                      </div>
                      <br clear="none">
                    </div>
                    <div dir="ltr">When I compile, I get below error.
                      (Below is a part of the error)</div>
                    <div dir="ltr"><br clear="none">
                    </div>
                    <div dir="ltr">
                      <div>
                        <div>make[1]: Entering directory
                          `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
                        <div>Compiling dbase.c</div>
                        <div>Compiling pg_con.c</div>
                        <div>Compiling res.c</div>
                        <div>Compiling val.c</div>
                        <div>In file included from pg_con.c:23:</div>
                        <div>pg_con.h:39:22: error: libpq-fe.h: No such
                          file or directory</div>
                        <div>In file included from pg_con.c:23:</div>
                        <div>pg_con.h:54: error: expected
                          specifier-qualifier-list before ‘PGconn’</div>
                        <div>pg_con.c: In function
                          ‘db_postgres_new_connection’:</div>
                        <div>pg_con.c:93: error: ‘struct pg_con’ has no
                          member named ‘con’</div>
                        <div>pg_con.c:93: warning: implicit declaration
                          of function ‘PQconnectdbParams’</div>
                        <div><br clear="none">
                        </div>
                      </div>
                      <div dir="ltr"><span><span style="color:rgb(0, 0,
                            0);font-family:Helvetica Neue, Helvetica,
                            Arial, sans-serif;font-size:16px;">libpq-fe.h
                            & <span><span style="color:rgb(0, 0,
                                0);font-family:Helvetica Neue,
                                Helvetica, Arial,
                                sans-serif;font-size:16px;">pg_config
                                are</span></span> in the below paths.  </span></span><br
                          clear="none">
                      </div>
                      <div dir="ltr"><span><span style="color:rgb(0, 0,
                            0);font-family:Helvetica Neue, Helvetica,
                            Arial, sans-serif;font-size:16px;"><br
                              clear="none">
                          </span></span></div>
                      <div dir="ltr">
                        <div>
                          <div>[root@SIPserver opensips-2.4.7]# ls -lrt
                            /usr/pgsql-9.6/include/libpq-fe.h</div>
                          <div>-rw-r--r--. 1 root root 21900 Feb 12
                            02:52 /usr/pgsql-9.6/include/libpq-fe.h</div>
                          <div>[root@SIPserver opensips-2.4.7]#</div>
                          <div><br clear="none">
                          </div>
                          <div dir="ltr">
                            <div>
                              <div>[root@SIPserver opensips-2.4.7]# ls
                                -lrt /usr/pgsql-9.6/bin/pg_config</div>
                              <div>-rwxr-xr-x. 1 root root 24544 Feb 12
                                02:52 /usr/pgsql-9.6/bin/pg_config</div>
                            </div>
                            <br clear="none">
                          </div>
                          <div dir="ltr">Could you assist me with above
                            error. </div>
                        </div>
                        <br clear="none">
                      </div>
                      <br clear="none">
                    </div>
                    <div><br clear="none">
                    </div>
                  </div>
                  <div class="yiv3030998548yahoo_quoted"
                    id="yiv3030998548yahoo_quoted_8185339492">
                    <div style="font-family:'Helvetica Neue', Helvetica,
                      Arial, sans-serif;font-size:13px;color:#26282a;">
                      <div> On Tuesday, April 21, 2020, 08:57:13 PM
                        GMT+5:30, Bogdan-Andrei Iancu <a rel="nofollow"
                          shape="rect"
                          class="yiv3030998548moz-txt-link-rfc2396E"
                          ymailto="mailto:bogdan@opensips.org"
                          target="_blank"
                          href="mailto:bogdan@opensips.org"
                          moz-do-not-send="true"><bogdan@opensips.org></a>
                        wrote: </div>
                      <div><br clear="none">
                      </div>
                      <div><br clear="none">
                      </div>
                      <div>
                        <div id="yiv3030998548">
                          <div> Hi Nayani,<br clear="none">
                            <br clear="none">
                            yeah, that is a rather old and unsupported
                            version of postgres. I think you should try
                            to use a newer version it (maybe a newer
                            version of your distro).<br clear="none">
                            <br clear="none">
                            Regards,<br clear="none">
                            <pre class="yiv3030998548moz-signature">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a rel="nofollow" shape="rect" class="yiv3030998548moz-txt-link-freetext" target="_blank" href="https://www.opensips-solutions.com" moz-do-not-send="true">https://www.opensips-solutions.com</a>

</pre>
                            <div class="yiv3030998548yqt3599837898"
                              id="yiv3030998548yqtfd29760">
                              <div class="yiv3030998548moz-cite-prefix">On
                                4/21/20 5:21 PM, Nayani Nikeshala wrote:<br
                                  clear="none">
                              </div>
                              <blockquote type="cite"> </blockquote>
                            </div>
                          </div>
                          <div class="yiv3030998548yqt3599837898"
                            id="yiv3030998548yqtfd41903">
                            <div>
                              <div><span style="color:rgb(38, 40, 42);">Hi
                                  Bogdan,</span><br clear="none">
                              </div>
                              <div
                                class="yiv3030998548ydpbd3f94ebyahoo_quoted"
id="yiv3030998548ydpbd3f94ebyahoo_quoted_7777934833">
                                <div style="font-family:'Helvetica
                                  Neue', Helvetica, Arial,
                                  sans-serif;font-size:13px;color:#26282a;">
                                  <div>
                                    <div
                                      class="yiv3030998548ydp33188704yahoo-style-wrap"
                                      style="font-family:Helvetica Neue,
                                      Helvetica, Arial,
                                      sans-serif;font-size:16px;">
                                      <div dir="ltr"><br clear="none">
                                      </div>
                                      <div dir="ltr">I have attached the
                                        output log for the above
                                        commands. </div>
                                      <div dir="ltr"><br clear="none">
                                      </div>
                                      <div dir="ltr"><span><span
                                            style="font-family:monospace;">"make
                                            modules
                                            module=modules/db_postgres"
                                            gave me an error as in the
                                            attached file, so I used "<span>make
include_modules=db_postgres modules" instead. I could see below in the
                                              output. </span></span></span><br
                                          clear="none">
                                      </div>
                                      <div dir="ltr"><span><span
                                            style="font-family:monospace;"><span><br
                                                clear="none">
                                            </span></span></span></div>
                                      <div dir="ltr"><span><span
                                            style="font-family:monospace;">
                                          </span></span>
                                        <div>
                                          <div>make[1]: Entering
                                            directory
                                            `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
                                          <div>make[1]: Leaving
                                            directory
                                            `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
                                          <div>make[1]: Entering
                                            directory
                                            `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
                                          <div>Compiling dbase.c</div>
                                          <div>Compiling db_postgres.c</div>
                                          <div>Compiling pg_con.c</div>
                                          <div>Compiling res.c</div>
                                          <div>Compiling val.c</div>
                                          <div>pg_con.c: In function
                                            db_postgres_new_connection:</div>
                                          <div><span
                                              style="background-color:rgb(91,
                                              136, 40);">pg_con.c:93:
                                              warning: implicit
                                              declaration of function
                                              PQconnectdbParams</span></div>
                                          <div><span
                                              style="background-color:rgb(91,
                                              136, 40);">pg_con.c:93:
                                              warning: assignment makes
                                              pointer from integer
                                              without a cast</span></div>
                                          <div>Linking db_postgres.so</div>
                                          <div>make[1]: Leaving
                                            directory
                                            `/home/cscore/Downloads/opensips-2.4.7/modules/db_postgres'</div>
                                        </div>
                                        <div><br clear="none">
                                        </div>
                                        <div dir="ltr">Is this a problem
                                          of my psql version(<span><span
                                              style="color:rgb(38, 40,
                                              42);font-family:Helvetica
                                              Neue, Helvetica, Arial,
                                              sans-serif;">8.4.20</span></span>),
                                          because <span><span
                                              style="color:rgb(0, 0,
                                              0);font-family:monospace;font-size:16px;background-color:rgb(91,
                                              136, 40);">PQconnectdbParams </span><span
                                              style="color:rgb(0, 0,
                                              0);font-family:monospace;font-size:16px;background-color:rgb(255,
                                              255, 255);"> is not
                                              available in that
                                              version. </span></span></div>
                                      </div>
                                      <br clear="none">
                                    </div>
                                  </div>
                                </div>
                              </div>
                              <br clear="none">
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                  <br clear="none">
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>