Comments on Installing And Configuring Asterisk 1.6 + PostgreSQL To Manage CDR & RealTime Config On Debian

Installing And Configuring Asterisk 1.6 + PostgreSQL To Manage CDR & RealTime Config On Debian In this tutorial, I will describe how to install and configure Asterisk 1.6 on a Debian system to work with PostgreSQL in order to manage CDR (Call Detail Records) and real-time configuration. For this we will use a clean and up-to-date Debian Etch/Lenny system.

5 Comment(s)

Add comment

Comments

By: Allan

The line:

<code>

pgsql -U asterisk -h localhost -d asteriskDB < /usr/src/asterisk/realtime_pgsql.sql

</code>

Should be:

<code>

psql -U asterisk -h localhost -d asteriskDB < /usr/src/asterisk/realtime_pgsql.sql

</code>

At least on my Debian Lenny installation.

Cheers,

Allan

By: Grayson Peddie

If this the one contained inside realtime_pgsql.sql file? The website with the file in the URL does not have it. Here's the one:

http://www.koders.com/sql/fid78E5D8568A9C3119A00F9BCCEEDEDF3AF7B6976E.aspx?s=asterisk#L122

By:

Upgraded... ty, i change my domain and my hosting... :P btw... this TUTO is very OutUpdate... but check out in http://coto.debianchile.cl/asterisk/asterisk-postgresql/

Im working in a Upgrade, but is in Spanish... very soon i will translate and republish right here.. in How To Forge!

Cheers,

Coto Cisternas

By: Anonymous

thank you for the tutorial !!

By: Maziar

sql file not found