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

Technology Insights

Delete All Rows from a PostgreSQL Table

Use the truncate command from the CLI or via PGAdmin to delete all rows from a PostgreSQL database. To use PGAdmin follow the directions here or follow the directions below to truncate the table from the CLI. Connect: Connect to PostgreSQL with psql. Delete Rows: Type the following from the CLI. bash dev=# truncate table <em>table_name</em>…

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.

Technology Insights

How to Turn Off Email Attachments Being DEFANGED in Microsoft Outlook

If attachments are showing up in your Microsoft Outlook inbox with a modified ending such as .doc being changed to .1324DEFANGED-doc then the issue is more than likely with your mail server instead of your email client. There is an application called MailScanner that modifies the file ending as a security measure to stop any files from being executed automatically. Below I briefly discuss modifying this setting on a Linux server using ISPConfig.

The easiest way to resolve this issue on a per user basis with an ISPConfig Linux server is to disable MailScanner for that user. MailScanner does provide numerous other security checks though so it is not recommended to disable it but if you must disable the file ending modification then modify the below files.