[Asterisk-Users] PostgreSQL

[Brian Cuthie]

Fabio,

You need to enable tcp connectivity on psql. Wherever you configured the 
databases to live (/var/lib/pgsql/data on my machine) you'll find a file 
called "postgres.conf". You need to read that and uncomment out the 
appropriate lines to get:

    tcpip_socket = true
    port = 5432

-brian

Fabio Donaggio wrote:

>Hi to all!!
>
>Here's my problem:
>
>[cdr_pgsql.so] => (PostgreSQL CDR Backend)
>  == Parsing '/etc/asterisk/cdr_pgsql.conf': Found
>May 26 17:21:35 ERROR[16384]: cdr_pgsql.c:298 my_load_module: cdr_pgsql:
>Unable to connect to database server localhost.
>Calls will not be logged!
>May 26 17:21:35 ERROR[16384]: cdr_pgsql.c:299 my_load_module: cdr_pgsql:
>Reason: could not connect to server:
>Connection refused
>        Is the server running on localhost and accepting
>        TCP/IP connections on port 5432?
>
>Anyone can help me??? Anyone have some suggest about this or about how to
>connect PostgreSQL to Asterisk???
>Thanks!
>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>  
>