Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual Exporting a Database, Reintializing a Database

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 21

Exporting a Database

Chapter2

PostgreSQL Database Operations and Functionalities

Database Operations

Exporting a Database

To export a database to a text file or to back up the entire database system, perform the following steps:

Exporting to a Text File

Step 1 Export a database into a text file by entering the following command:

pg_dump –x databasename > outfile

Note "-x" is optional. When it is used, the “dumped” database loses the ownership information.

Step 2 Reload the dataset by entering the following command:

psql –e database < outfile

Note "-e" is optional. When it is used, every log message “echoes” on the screen.

Backing Up the Database System

You can back up the database system file directory /usr/local/pgsql/data/base into a tar file.

Reintializing a Database

To reinitialize a database, the existing database must be destroyed, and a new one must be created. To reinitialize a database, performing the following steps:

Step 1 Destroy the database by entering the following command with “csrdb” as the name of the database:

dropdb csrdb

Note The database to be destroyed must not be connected to the CSR application, CSR GUI, and pgsql.

Step 2 Create a new database by entering the following command:

createcsrdb csrdb

After the database is re-created, the CSR and CSR GUI can be restarted and connected to the new database. If “csrdb” is not used as the name of the database, note the following:

•To have CSR started upon reboot of the Solaris system, modify the following files:

–etc/init.d/csr_init

–/etc/rc2.d/S99csr_init

•To start CSR from the command prompt, specify the database name in command csr newdbname &

Cisco Carrier Sensitive Routing User Guide

2-3

Image 21

Cisco Systems Version 1.1 manual Exporting a Database, Reintializing a Database, Exporting to a Text File

Contents

Cisco Systems, Inc 170 West Tasman Drive San Jose, CA Version800 553-NETS Fax 408 Cisco Carrier Sensitive Routing User GuideCopyright 2002, Cisco Systems, Inc All rights reserved Cisco Carrier Sensitive Routing User GuideOverview PrefaceOverview of Cisco Carrier Sensitive Routing PrerequisitesActivating CSR Saving Configuration SettingsAdding, Modifying, and Removing Gatekeepers Database TablesCleaning Test Results Resetting Call AccountingCreating Contact Lists Deleting Contact ListsConfiguration Data Schema Data Schema B-1Logging A-1 ExamplesOverview PrefaceWho Should Use This Guide Overview, page-vii Who Should Use This Guide, page-viiAppendix C, “Error Conditions and Recoveries” Appendix B, “Data Schema”Document Organization Document ConventionsObtaining Documentation Related Documentation and ReferencesWorld Wide Web Documentation CD-ROMDocumentation Feedback Obtaining Technical AssistanceCisco.com Technical Assistance CenterCisco TAC Escalation Center Cisco TAC Web SiteCisco Carrier Sensitive Routing User Guide Preface Obtaining Technical AssistancePrerequisites, page CSR Components, page CSR Basics, page PrerequisitesCSR Limitations, page Overview of Cisco Carrier Sensitive RoutingCSR Basics CSR ComponentsCSR Application PostgreSQL DatabaseIngress Rejection Rules CSR GUIEgress Rejection Rules Selection RulesCSR Limitations Chapter1 CSR Limitations Carrier Sensitive Routing User GuideOverview of Cisco Carrier Sensitive Routing Database Operations PostgreSQL Database Operations and FunctionalitiesActivating the Database Database Operations, page Database Functionalities, pageReactivating the Database Exiting the Databaseetc/init.d/postgresinit stop etc/init.d/postgresinit restartReintializing a Database Exporting a DatabaseExporting to a Text File Backing Up the Database SystemDatabase Tables, page PostgreSQL Database Command Summary, page Configuration TablesDatabase Functionalities Database Tablestext ActiveDatasetDefault NameThreadCount integerTable2-1 Configuration Data Table continued boolean RejectSrcUnitsFALSE 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 2-12 SelectPreferr edCarrier rule is usedTable2-10 Routes Table Table2-11 Rules TableDefault 2-13Name TypeName 2-142-15 Lists TableTable2-13 Lists Table Table2-14 ContactLists TableDefault 2-16Name TypeTable2-16 EgressRouteAttributes Table 2-17Table2-17 QoS Table Table2-18 QoS Table2-18 PostgreSQL Database Command SummaryActivating CSR Cisco Carrier Sensitive Routing Application OperationsSingle Instance CSR as a DaemonCSR as a User Process Multiple InstancesDeactivating CSR Figure3-2 CSR Window Step 4 Click Shutdown CSRChapter3 Deactivating CSRCSR Commands, page Multiple GUI Operation, page Activating the GUI, page Configuring CSR with the GUI, pageCSR GUI Functionalities Activating the GUIChanging Configuration Settings Configuring CSR with the GUIChanging Configuration Settings, page Adding, Modifying, and Removing Gatekeepers, pageFigure4-2 Configuration Management Tab in CSR Window Changing Log LevelsChapter4 CSR GUI Functionalities Configuring CSR with the GUI Cisco Carrier Sensitive Routing User GuideChanging App Priority Saving Configuration SettingsChanging Connection Port Enabling Test Routes AccountingAdding Gatekeepers Adding, Modifying, and Removing GatekeepersFigure4-5 Registered Messages and Filters Checkbox Step 9 Click a filter on the pop-up menu Chapter4 CSR GUI Functionalities Configuring CSR with the GUIFigure4-7 Filters Pop-up Menu Figure4-8 Sample Filter DisplayFigure4-9 Sample Filter Display Figure4-10 Delete Filter DisplayStep 12 Click Delete Modifying Gatekeepers 4-10 Removing Gatekeepers4-11 Setting Threads for Processing Calls and Call Queue SizeFigure4-14 Advanced Configuration Dialog Box Figure4-13 Delete Gatekeeper MessageUpdating Active Datasets Swapping Datasets4-12 4-13 Creating, Modifying, and Deleting CarriersCreating Carriers 4-14Figure4-17 Carrier Selection Box in Active Dataset Modifying Carriers 4-15Figure4-18 Dialog Box for New Carrier in Active Dataset 4-16 Deleting CarriersCreating, Modifying, and Deleting Contacts Creating Contacts4-17 Deleting Contacts Modifying 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 Deleting Contact Lists Creating, Modifying, and Deleting Egress Route AttributesCreating Egress Route Attributes 4-21The 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 displayed 4-22Modifying Egress Route Attributes 4-23hour0-23min 0-60sec Figure4-26 List of Egress Route Attribute Names in Active Dataset 4-24Chapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User Guide4-25 Deleting Egress Route AttributesCreating, Modifying, and Deleting Ingress Route Attributes Creating Ingress Route Attributes4-26 a. If you select Daily, enter Start Time and End Time 4-274-28 Modifying Ingress Route AttributesChapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User Guide4-29 Deleting Ingress Route AttributesCreating, Modifying, and Deleting Match Patterns Creating Match Patterns4-30 Deleting Match Patterns Modifying 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 A provisioned minimum QoS 4-364-37 Modifying RulesDeleting 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 Resetting Call Accounting, page Updating Gatekeepers, page CSR CommandsCleaning Test Results, page Activating Inactive Datasets4-42 Sending Test Route Request Commands to an Active CSR ApplicationThis entry is optional 4-43Updating Logging Level Loading the Active Dataset4-44 Cleaning Test Results Resetting Call AccountingUpdating Gatekeepers 4-45Checking CSR Version Multiple GUI Operation4-46 Configuring Syslog Configuring Syslog Viewing LogsLogging Examples Viewing LogsSample logs Cisco Carrier Sensitive Routing User Guide AppendixA Logging Viewing LogsData Schema Configuration Data SchemaConfiguration Data Schema Dataset Schema Page Page Page Dataset Schema Page Page Cisco Carrier Sensitive Routing User Guide Page CHECK RelativeQoS = 1 AND RelativeQoS = B-10B-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 automatic number identification dialed number identification serviceadmission request message domain naming systemregistration request message resource availability indication messageunregistration request message GL-4IN-5 I N D EIN-6