Technology Insights

How to Check CPU Speed on Linux

The easiest way to check CPU speed and CPU model on Linux is to issue the below command from the CLI.

bash

  1. more /proc/cpuinfo | egrep 'model name|cpu MHz'

This will return results like the below that will list CPU model name on one line followed by CPU speed on the next line.

bash

  1. [root@server ~]# less /proc/cpuinfo | egrep 'model name|cpu MHz'
  2. model name : Dual-Core AMD Opteron(tm) Processor 2212
  3. cpu MHz : 2010.302
  4. model name : Dual-Core AMD Opteron(tm) Processor 2212
  5. cpu MHz : 2010.302
  6. model name : Dual-Core AMD Opteron(tm) Processor 2212
  7. cpu MHz : 2010.302
  8. model name : Dual-Core AMD Opteron(tm) Processor 2212
  9. cpu MHz : 2010.302
Details
Technology Insights

How to Dump the Data From One PostgreSQL Table

Below is the command to use when you would like to dump only the data from a postgreSQL table. There are other options to use to dump the schema, multiple tables, exclude certain tables, or backup the entire database but these command line switches will dump only the data from one postgreSQL table.

In the below example replace table_name with the name of the table you are backing up, file_name with the name of the output file (optionally add a path to the file name), and database_name with the name of the database where the table is located.

Details