Articles related to technology, how to use software, ways to work around technology problems, install hardware, install software, upgraded software, etc.
Easily create or drop a database via the psql CLI using the below syntax. Create a PostgreSQL Database: Just modify the database_name to the name you prefer for your new database. bash create database database_name
To install pgbench on Linux use yum and install the postgresql-contrib package using the below syntax. bash yum install postgresql-contrib When issuing the above command the results will output like the below. If postgresql, postgresql-server, and/or postgresql-libs has already been installed then it is likely that they will be upgraded using the default command.
The default admin or web login for the Kyocera KR2 Mobile Router is the last 6 digits of the MAC address. The MAC Address is located on the bottom of the router and is titled WLAN MAC ID. The digits will be in hexidecimal. To make configuration changes you must login to the administration account…
To find out how to install a certain command or utility via yum you can use list or the “whatprovides” option as shown below. This is an example of using yum with the list option to find any packages with “send” in the name. bash yum list *SEND* Using this command will provide results like…
The iostat command is used to check disk input/output statistics in real time. The iostat utility is installed with yum via the sysstat package as shown below. bash yum install sysstat Issuing this command will look similar to the below and provide the iostat command when finished.
There are a couple useful utilities on Linux to test disk input/ouput. Sequential Disk Access: hdparm The hdparm command will test sequential disk access and can be used with the below command. Replace /dev/sda1 with the mounted disk you would like to test such as /dev/hda1. bash hdparm -t /dev/sda1 The results will output similar…
The easiest way to check CPU speed and CPU model on Linux is to issue the below command from the CLI. bash 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 [root@server…
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>…
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…