From 8fb3dd35cc73c8e631e15a945c05f0dd1a62e571 Mon Sep 17 00:00:00 2001
From: russell <russell@f38db490-d61c-443f-a65b-d21fe96a405b>
Date: Tue, 30 Jan 2007 23:30:34 +0000
Subject: Add documentation for using cdr_pgsql.  (issue #8942, lters)

git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.4@52999 f38db490-d61c-443f-a65b-d21fe96a405b
---
 doc/cdrdriver.txt | 46 ++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 46 insertions(+)

(limited to 'doc')

diff --git a/doc/cdrdriver.txt b/doc/cdrdriver.txt
index 9bc6fa102..8a7e2e328 100644
--- a/doc/cdrdriver.txt
+++ b/doc/cdrdriver.txt
@@ -160,10 +160,56 @@ MSSQL:		Asterisk can currently store CDRs into an MSSQL database in
                 logs a connection to the database and will now record every
                 call to the database when it's complete.
 
+
 MYSQL:
 
+
 PGSQL:
+        If you want to go directly to postgresql database, and have the cdr_pgsql.so
+        compiled you can use the following sample setup.
+        On Debian, before compiling asterisk, just install libpqxx-dev.
+        Other distros will likely have a similiar package.
+
+        Once you have the compile done,
+        copy the sample cdr_pgsql.conf file or create your own.
+
+        Here is a sample:
+
+        /etc/asterisk/cdr_pgsql.conf
+          ; Sample Asterisk config file for CDR logging to PostgresSQL
+          [global]
+          hostname=localhost
+          port=5432
+          dbname=asterisk
+          password=password
+          user=postgres
+          table=cdr
+
+        ;Now create a table in postgresql for your cdrs
+
+        ;SQL table where CDRs will be inserted
+        ;Copy and paste this into your postgresql prompt.
+        CREATE TABLE cdr (
+                calldate      time               NOT NULL ,
+                clid          varchar (80)          NOT NULL ,
+                src           varchar (80)          NOT NULL ,
+                dst           varchar (80)          NOT NULL ,
+                dcontext      varchar (80)          NOT NULL ,
+                channel       varchar (80)          NOT NULL ,
+                dstchannel    varchar (80)          NOT NULL ,
+                lastapp       varchar (80)          NOT NULL ,
+                lastdata      varchar (80)          NOT NULL ,
+                duration      int                   NOT NULL ,
+                billsec       int                   NOT NULL ,
+                disposition   varchar (45)          NOT NULL ,
+                amaflags      int                   NOT NULL ,
+                accountcode   varchar (20)          NOT NULL ,
+                uniqueid      varchar (32)          NOT NULL ,
+                userfield     varchar (255)         NOT NULL
+        );
+
 
 SQLLITE:
 
+
 RADIUS:		See doc/radius.txt for more information on cdr_radius	
-- 
cgit v1.2.3