Search code examples
mysqlpostgresqldatabase-connectionasteriskivr

Connecting postgresql with asterisk using PGSQL()

I am trying to connect postgresql database with asterisk .For that I installed asterisk and postgresql.The docs says apart from odbc or realtime you can simply use PGSQL().So when I do

exten => s,2,PGSQL(Connect connid host=localhost user=asterisk dbname=credit)

It gave me the error no application 'PGSQL' for that extension

Can anybody help me to connect asterisk with postgres .I dont want to use odbc and any agi or realtime.I had used MYSQL in my dialplan and it worked there as I read that MYSQL module is included default in asterisk so I can use it directly without ODBC as I am using .

How can I do same with postgresql in order to connect to it via asterisk? Thanks

Solution

  • Read the documentation. The page that you linked says at the beginning:

    NOTE This function is not available in asterisk. Either use ODBC or write this funtion.