Uploaded image for project: 'FreeSWITCH'
  1. FreeSWITCH
  2. FS-11880

Add mod_pgsql replacing PostgreSQL support in the core.

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 20.19.5, 1.10.0
    • Component/s: core, mod_pgsql
    • Labels:
      None
    • CPU Architecture:
      x86-64
    • Kernel:
      Linux
    • Userland:
      GNU/Linux
    • Distribution:
      Debian
    • Distribution Version:
      Debian 8 jessie
    • Compiler:
      gcc
    • FreeSWITCH GIT Revision:
      901bf8bff8714ed70c124c026a94e63f46832ab3
    • GIT Master Revision hash::
      901bf8bff8714ed70c124c026a94e63f46832ab3

      Description

      Native PostgreSQL support was removed from the FreeSWITCH Core!
      =================================
      NOTICE: Database modules are described in new section called `pre_load_modules.conf` (pre_load_modules.conf.xml file) and NOT in `modules.conf` (modules.conf.xml file).
      You MUST enable mod_pgsql in the "pre_load_modules.conf" section, see `pre_load_modules.conf.xml`:

      <configuration name="pre_load_modules.conf" description="Modules">
       <modules>
       <!-- Databases -->
       <load module="mod_pgsql"/>
       </modules>
       </configuration>

      =================================
      According to https://www.postgresql.org/docs/9.6/libpq-connect.html#LIBPQ-CONNSTRING
      There are two accepted formats for connection strings supported by the libpq library:

      • For plain keyword = value strings use pgsql://
        pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE'
      • For RFC 3986 URIs use postgresql:// or postgres://
        postgresql://
        postgresql://localhost
        postgresql://localhost:5433
        postgresql://localhost/mydb
        postgresql://user@localhost
        postgresql://user:secret@localhost
        postgresql://other@localhost/otherdb?connect_timeout=10&application_name=myapp
        postgresql:///mydb?host=localhost&port=5433
      <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE'" />
      <param name="core-db-dsn" value="postgresql://freeswitch:@127.0.0.1/freeswitch?options=-c%20client_min_messages%3DNOTICE" />

      Supported prefixes:
      pgsql://
      postgresql://
      postgres://

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mikej Mike Jerris
                Reporter:
                andywolk Andrey Volk
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: