Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual PostgreSQL Database Command Summary, 2-18

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 36

PostgreSQL Database Command Summary

Chapter2

PostgreSQL Database Operations and Functionalities

Database Functionalities

Note Tables IngressRoutes_1, IngressRoutes_2, EgressRoutes_1, and EgressRoutes_2 can inherit from this QoS table.

PostgreSQL Database Command Summary

Following is a summary of frequently used postgreSQL commands. Refer to the online manual pages and help section for more information.

•createdb—Creates a new database in postgreSQL. A database name is required when using this command.

•createuser—Creates a postgreSQL user. A user name is required when using this command.

•dropdb—Removes a database from postgreSQL. A database name is required when using this command.

•dropuser—Removes a postgreSQL user. A user name is required when using this command.

•initdb—Creates a new postgreSQL database installation. This command is used only once when the database is installed. It creates the base directory. This command cannot be used again.

•psql —SQL interface to the postgreSQL databases. A database name is required when using this command.

•vacuumdb—Cleans and analyzes a postgreSQL database.

Cisco Carrier Sensitive Routing User Guide

2-18

Image 36

Cisco Systems Version 1.1 manual PostgreSQL Database Command Summary, 2-18

Contents

Version Cisco Systems, Inc 170 West Tasman Drive San Jose, CA800 553-NETS Fax 408 Cisco Carrier Sensitive Routing User GuideCisco Carrier Sensitive Routing User Guide Copyright 2002, Cisco Systems, Inc All rights reservedPreface OverviewOverview of Cisco Carrier Sensitive Routing PrerequisitesSaving Configuration Settings Activating CSRAdding, Modifying, and Removing Gatekeepers Database TablesResetting Call Accounting Cleaning Test ResultsCreating Contact Lists Deleting Contact ListsData Schema B-1 Configuration Data SchemaLogging A-1 ExamplesPreface OverviewWho Should Use This Guide Overview, page-vii Who Should Use This Guide, page-viiAppendix B, “Data Schema” Appendix C, “Error Conditions and Recoveries”Document Organization Document ConventionsRelated Documentation and References Obtaining DocumentationWorld Wide Web Documentation CD-ROMObtaining Technical Assistance Documentation FeedbackCisco.com Technical Assistance CenterCisco TAC Web Site Cisco TAC Escalation CenterPreface Obtaining Technical Assistance Cisco Carrier Sensitive Routing User GuidePrerequisites Prerequisites, page CSR Components, page CSR Basics, pageCSR Limitations, page Overview of Cisco Carrier Sensitive RoutingCSR Components CSR BasicsPostgreSQL Database CSR ApplicationCSR GUI Ingress Rejection RulesEgress Rejection Rules Selection RulesCSR Limitations Chapter1 CSR Limitations Carrier Sensitive Routing User GuideOverview of Cisco Carrier Sensitive Routing PostgreSQL Database Operations and Functionalities Database OperationsActivating the Database Database Operations, page Database Functionalities, pageExiting the Database Reactivating the Databaseetc/init.d/postgresinit stop etc/init.d/postgresinit restartExporting a Database Reintializing a DatabaseExporting to a Text File Backing Up the Database SystemConfiguration Tables Database Tables, page PostgreSQL Database Command Summary, pageDatabase Functionalities Database TablesActiveDataset textDefault NameThreadCount integerTable2-1 Configuration Data Table continued RejectSrcUnits booleanFALSE AllowDefault Table2-2 Gatekeeper Table continuedTable2-3 TestRoutes Table Table2-4 TestOutputs Table Table2-5 LogEntries TableTable2-6 StringResources Table Dataset Tables 2-10Table2-7 Filters Table 2-11 Table2-8 Carriers TableTable2-9 MatchPatterns Table SelectPreferr edCarrier rule is used 2-12Table2-10 Routes Table Table2-11 Rules Table2-13 DefaultName Type2-14 NameLists Table 2-15Table2-13 Lists Table Table2-14 ContactLists Table2-16 DefaultName Type2-17 Table2-16 EgressRouteAttributes TableTable2-17 QoS Table Table2-18 QoS TablePostgreSQL Database Command Summary 2-18Cisco Carrier Sensitive Routing Application Operations Activating CSRSingle Instance CSR as a DaemonMultiple Instances CSR as a User ProcessDeactivating CSR Step 4 Click Shutdown CSR Figure3-2 CSR WindowChapter3 Deactivating CSRActivating the GUI, page Configuring CSR with the GUI, page CSR Commands, page Multiple GUI Operation, pageCSR GUI Functionalities Activating the GUIConfiguring CSR with the GUI Changing Configuration SettingsChanging Configuration Settings, page Adding, Modifying, and Removing Gatekeepers, pageChanging Log Levels Figure4-2 Configuration Management Tab in CSR WindowChapter4 CSR GUI Functionalities Configuring CSR with the GUI Cisco Carrier Sensitive Routing User GuideSaving Configuration Settings Changing App PriorityChanging Connection Port Enabling Test Routes AccountingAdding, Modifying, and Removing Gatekeepers Adding GatekeepersFigure4-5 Registered Messages and Filters Checkbox Chapter4 CSR GUI Functionalities Configuring CSR with the GUI Step 9 Click a filter on the pop-up menuFigure4-7 Filters Pop-up Menu Figure4-8 Sample Filter DisplayFigure4-9 Sample Filter Display Figure4-10 Delete Filter DisplayStep 12 Click Delete Modifying Gatekeepers Removing Gatekeepers 4-10Setting Threads for Processing Calls and Call Queue Size 4-11Figure4-14 Advanced Configuration Dialog Box Figure4-13 Delete Gatekeeper MessageUpdating Active Datasets Swapping Datasets4-12 Creating, Modifying, and Deleting Carriers 4-13Creating Carriers 4-14Figure4-17 Carrier Selection Box in Active Dataset Modifying Carriers 4-15Figure4-18 Dialog Box for New Carrier in Active Dataset Deleting Carriers 4-16Creating, Modifying, and Deleting Contacts Creating Contacts4-17 Modifying Contacts Deleting Contacts4-18 Figure4-22 Dialog Box for an Existing Contact in Active DatasetCreating, Modifying, and Deleting Contact Lists Creating Contact Lists4-19 Modifying Contact Lists 4-20Figure4-24 Dialog Box for an Existing Contact List in Active Dataset Creating, Modifying, and Deleting Egress Route Attributes Deleting Contact ListsCreating Egress Route Attributes 4-214-22 The key shown on the screen is the primary key of this egress route attribute in the Egress Route Attributes table. When a new egress route attribute is being created, “%%%%” is displayedModifying Egress Route Attributes 4-23hour0-23min 0-60sec 4-24 Figure4-26 List of Egress Route Attribute Names in Active DatasetChapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User GuideDeleting Egress Route Attributes 4-25Creating, Modifying, and Deleting Ingress Route Attributes Creating Ingress Route Attributes4-26 4-27 a. If you select Daily, enter Start Time and End TimeModifying Ingress Route Attributes 4-28Chapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User GuideDeleting Ingress Route Attributes 4-29Creating, Modifying, and Deleting Match Patterns Creating Match Patterns4-30 Modifying Match Patterns Deleting Match Patterns4-31 Figure4-31 Dialog Box for New Match Pattern in Active DatasetCreating, Modifying, and Deleting Routes Creating Routes4-32 Modifying Routes 4-33Figure4-33 QoS Relationships Dialog Box in Active Dataset Deleting Routes 4-34Figure4-34 Dialog Box for an Existing Route in Active Dataset Creating, Modifying, and Deleting Rules Creating Rules4-35 4-36 A provisioned minimum QoSModifying Rules 4-37Deleting Rules 4-38Figure4-36 Dialog Box for Existing Rule in Active Dataset Updating Inactive Datasets Verifying Datasets4-39 Destroying Inactive Datasets 4-40Figure4-37 Inactive Dataset Tab in CSR Window CSR Commands Resetting Call Accounting, page Updating Gatekeepers, pageCleaning Test Results, page Activating Inactive DatasetsSending Test Route Request Commands to an Active CSR Application 4-424-43 This entry is optionalUpdating Logging Level Loading the Active Dataset4-44 Resetting Call Accounting Cleaning Test ResultsUpdating Gatekeepers 4-45Checking CSR Version Multiple GUI Operation4-46 Configuring Syslog Configuring Syslog Viewing LogsLogging Viewing Logs ExamplesSample logs AppendixA Logging Viewing Logs Cisco Carrier Sensitive Routing User GuideData Schema Configuration Data SchemaConfiguration Data Schema Dataset Schema Page Page Page Dataset Schema Page Page Cisco Carrier Sensitive Routing User Guide Page B-10 CHECK RelativeQoS = 1 AND RelativeQoS =B-11 B-12 B-13 B-14 AppendixB Data Schema Dataset SchemaCisco Carrier Sensitive Routing User Guide Error Conditions and Recoveries Database Connectivity LossDatabase Connectivity Loss Gatekeeper Connectivity Loss Gatekeeper Connectivity Loss dialed number identification service automatic number identificationadmission request message domain naming systemresource availability indication message registration request messageunregistration request message GL-4I N D E IN-5IN-6