PostgreSQL with FreePBX CDR

General Help
1

Hello.
We have the latest version of FreePBX. On another (external) server we install PostgreSQL.
Now FreePBX works with MySQL on the same server.

How can we make connections to PostgreSQL? In Advance Settings ->Remote CDR Database, I can not write any information.

2

Hello.
Does anybody have an ideas, how we can download and after it load module cdr_pgsql.so to Asterisk?

In FreePBX Distro there is not cdr_pgsql.so module!

3

https://wiki.asterisk.org/wiki/display/AST/PostgreSQL+CDR+Backend

But, yes, it’s probably not there in most distros , you will have build your own asterisk.

4

I believe that module is depreciated in favor of odbc as well.

5

Hello.
I install unixodbc and drivers for postgresql. I change Asterisk config files.
When I make command odbc show

ODBC DSN Settings

Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Last connection attempt: 1970-01-01 03:00:00
Pooled: No
Connected: Yes

Name: asteriskcdrdb1
DSN: PostgreSQL-asteriskcdrdb
Last connection attempt: 1970-01-01 03:00:00
Pooled: No
Connected: Yes

I see connect but in table cdr there is not any data.

Can we connect to two databases? If no, how I can change settings from MySQL to PostgreSQL?

6

I think, when I use odbc, I don`t need to install any drivers to Asterisk.
All work makes odbc.