Avaya POM Postgres DB Connect Command

[email protected] 08:04 PM /opt/Avaya/avpom/POManager/logs # su – postgres

-bash-3.2$ psql
Welcome to psql 8.3.10, the PostgreSQL interactive terminal.

Type: \\copyright for distribution terms
\\h for help with SQL commands
\\? for help with psql commands
\\g or terminate with semicolon to execute query
\\q to quit

postgres=# \\c VoicePortal
You are now connected to database “VoicePortal”.

pom=# select * from pim_job where job_id=’1150′;
job_id | campaign_id | schedule_id | status | start_time | end_time | last_allocated_id | f inish_reason | next_archival_time | abort_time | total_calls | total_emails | total_sms | total_contacts | successful_calls | nuisance_calls | customer_hangups
1150 | 1 | | 16 | 2011-03-02 12:41:42.188-07 | | -1 | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0
(1 row)

pom=# delete from pim_job where job_id=’1150′;

Src: How to stop POM Campaign manually


[email protected] ~]# service POM restart
Stopping POM at Mon Oct 17 10:12:07 CEST 2011
Stopping individual components:
Stopping Campaign Manager…
Stopping Campaign Manager:
Warning: No CM process is running! Please restart CM [ OK ]
… successful
Stopping Campaign Director…
Stopping Campaign Director:
Warning: No CD process is running! Please restart CD [ OK ]
… successful

POM Shutdown Status: [ OK ]

Solution: From the Voice Portal (VP) web Administration page, remove and create back the POM server.

From the Voice Portal Web Administration page, access menu POM Configuration / POM servers

  1.  Check the box in front of the POM server name and click the Delete button.
  2. Click the Add button to create back the POM server and fill the POM Server Name and POM Server IP Address fields.


 Proactive Outreach Manager POM: Got only one ring on POM dialed contact

When running the campaign, the called contacts ring only once. In the POM report, the calls are identified as transferred however the calls have not been answered. The strategy has been developed to use the AvayaPOMAgent application which proceed with a Blind transfer.

On CM, access the administration and run:

change system-parameters special-applications.

Set to yes SA8874 as shown below:

(SA8874) – Call Status Messages for 7434ND IP Softphone? y

[[email protected] ~]# service POM status


PostgreSQL vs MySQL limitations

1/ Postgres

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC…

Limit Value
Maximum Database Size Unlimited
Maximum Table Size 32 TB
Maximum Row Size 1.6 TB
Maximum Field Size 1 GB
Maximum Rows per Table Unlimited
Maximum Columns per Table 250 – 1600 depending on column types
Maximum Indexes per Table Unlimited


2/ MySQL

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the most up-to-date information, be sure to check the documentation specific to your operating system.

Operating System File-size Limit
Win32 w/ FAT/FAT32 2GB/4GB
Win32 w/ NTFS 2TB (possibly larger)
Linux 2.2-Intel 32-bit 2GB (LFS: 4GB)
Linux 2.4+ (using ext3 file system) 4TB
Solaris 9/10 16TB
MacOS X w/ HFS+ 2TB
NetWare w/NSS file system 8TB

If you do encounter a full-table error, there are several reasons why it might have occurred:

  • The disk might be full.
  • The InnoDB storage engine maintains InnoDB tables within a tablespace that can be created from several files. This enables a table to exceed the maximum individual file size. The tablespace can include raw disk partitions, which permits extremely large tables. The maximum tablespace size is 64TB.

    If you are using InnoDB tables and run out of room in the InnoDB tablespace. In this case, the solution is to extend the InnoDB tablespace. See Section 14.2.4, “Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace”.

  • You are using MyISAM tables on an operating system that supports files only up to 2GB in size and you have hit this limit for the data file or index file.
  • You are using a MyISAM table and the space required for the table exceeds what is permitted by the internal pointer size. MyISAM creates data and index table files to permit up to 4GB by default (256TB as of MySQL 5.0.6), but this limit can be changed up to the maximum permissible size of 65,536TB (2567 – 1 bytes).



What does database facebook, google, yahoo, twitter, linkin use

  • Hive (Data warehouse for Hadoop, supports tables and a variant of SQL called hiveQL). Used for “simple summarization jobs, business intelligence and machine learning and many other applications”
  • Cassandra (Multi-dimensional, distributed key-value store). Currently used for Facebook’s private messaging.

Currently running 610 (soon to be 1000) Hadoop nodes in a single cluster with Hive datastore. Both Hive and Cassandra have been open-sourced by Facebook.

Facebook stats:

  • More than 200 million active users
  • More than 100 million users log on to Facebook at least once each day
  • More than 30 million users update their statuses at least once each day
  • Average user has 120 friends on the site



4 Bước thiết lập password cho PostgreSQL Database

Khi mới cài đặt Postgres xong sẽ không có password để đăng nhập. Muốn thiết lập được ta cần trải qua các bước sau:

B1: Chuyển vào postgres user

Command: su – postgres

B2: Vào postgres command

Command: psql

B3: Gõ lệnh change password

Command: ALTER USER postgres WITH ENCRYPTED PASSWORD ‘vneconomics’;

B4: Khởi động lại Postgres

Command: service postgresql restart