Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual Exiting the Database, Reactivating the Database

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 20

Exiting the Database

Chapter2

PostgreSQL Database Operations and Functionalities

Database Operations

•-S—Tells the postmaster to run in silent mode. This is not recorded to a log file.

•-i—Tells postmaster to allow network connections. If this is not set, the postmaster accepts connections only from the local host.

Note This is needed for the GUI to connect to the database even when it is running on the same machine.

•-B and -N—Set up shared memory segments.

•-D—Tells the postmaster the location of the database files.

Note For servers with console login, disable Xwindow in the file .profile, so the database can be restarted from a reboot.

Exiting the Database

To exit the postgreSQL database, perform the following steps:

Step 1 Log in to the Solaris system by entering postgres as the user.

A “postgres” password prompt may appear.

Step 2 Enter the following command:

/etc/init.d/postgres_init stop

This command calls the postgreSQL command pg_ctl stop.

Reactivating the Database

To reactivate the postgreSQL database, perform the following steps.

Step 1 Log in into the Solaris system by entering postgres as the user.

A “postgres” password prompt may appear.

Step 2 Enter the following command:

/etc/init.d/postgres_init restart

This command calls the postgreSQL command pg_ctl restart. The parameters for this command are described in “Activating the Database” section on page2-1 .

Cisco Carrier Sensitive Routing User Guide

2-2

Image 20

Cisco Systems Version 1.1 manual Exiting the Database, Reactivating the Database, etc/init.d/postgresinit stop

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 Overview of Cisco Carrier Sensitive Routing Chapter1CSR Limitations Carrier Sensitive Routing User Guide 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 NameTable2-1 Configuration Data Table continued ThreadCountinteger RejectSrcUnits booleanFALSE AllowTable2-3 TestRoutes Table DefaultTable2-2 Gatekeeper Table continued Table2-6 StringResources Table Table2-4 TestOutputs TableTable2-5 LogEntries Table Table2-7 Filters Table Dataset Tables2-10 Table2-9 MatchPatterns Table 2-11Table2-8 Carriers 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 DisplayStep 12 Click Delete Figure4-9 Sample Filter DisplayFigure4-10 Delete Filter Display 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 Message4-12 Updating Active DatasetsSwapping Datasets Creating, Modifying, and Deleting Carriers 4-13Figure4-17 Carrier Selection Box in Active Dataset Creating Carriers4-14 Figure4-18 Dialog Box for New Carrier in Active Dataset Modifying Carriers4-15 Deleting Carriers 4-164-17 Creating, Modifying, and Deleting ContactsCreating Contacts Modifying Contacts Deleting Contacts4-18 Figure4-22 Dialog Box for an Existing Contact in Active Dataset4-19 Creating, Modifying, and Deleting Contact ListsCreating Contact Lists Figure4-24 Dialog Box for an Existing Contact List in Active Dataset Modifying Contact Lists4-20 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 displayedhour0-23min 0-60sec Modifying Egress Route Attributes4-23 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-254-26 Creating, Modifying, and Deleting Ingress Route AttributesCreating Ingress Route Attributes 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-294-30 Creating, Modifying, and Deleting Match PatternsCreating Match Patterns Modifying Match Patterns Deleting Match Patterns4-31 Figure4-31 Dialog Box for New Match Pattern in Active Dataset4-32 Creating, Modifying, and Deleting RoutesCreating Routes Figure4-33 QoS Relationships Dialog Box in Active Dataset Modifying Routes4-33 Figure4-34 Dialog Box for an Existing Route in Active Dataset Deleting Routes4-34 4-35 Creating, Modifying, and Deleting RulesCreating Rules 4-36 A provisioned minimum QoSModifying Rules 4-37Figure4-36 Dialog Box for Existing Rule in Active Dataset Deleting Rules4-38 4-39 Updating Inactive DatasetsVerifying Datasets Figure4-37 Inactive Dataset Tab in CSR Window Destroying Inactive Datasets4-40 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 optional4-44 Updating Logging LevelLoading the Active Dataset Resetting Call Accounting Cleaning Test ResultsUpdating Gatekeepers 4-454-46 Checking CSR VersionMultiple GUI Operation Logging Configuring SyslogConfiguring Syslog Viewing Logs Viewing Logs ExamplesSample logs AppendixA Logging Viewing Logs Cisco Carrier Sensitive Routing User GuideConfiguration Data Schema Dataset Schema Data SchemaConfiguration Data 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 Cisco Carrier Sensitive Routing User Guide B-14AppendixB Data Schema Dataset Schema Database Connectivity Loss Gatekeeper Connectivity Loss Error Conditions and RecoveriesDatabase 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