When pgbench results are provided they are shown as TPS or transactions per second. Below is an example of pgbench being used. bash bash-3.1$ pgbench -Upostgres -s 10 -c 10 -t 3000 pgbench starting vacuum…end. transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 10 number of transactions per client: 3000 number of…
On initial installation of PostgreSQL typically you will also download and install pgAdmin III on your local PC to assist in Postgres management. The pgAdmin GUI will assist in viewing database information quickly, etc. In one of my installations I was not able to connect to the new Postgres installation via pgAdmin and I was…
You can disable Windows XP application errors from being sent to Microsoft. Even though these errors are confidential and will not have your personal information attached to them disabling the errors will stop you from being prompted to send the errors to Microsoft every time something crashes or you kill a process. Also whenever these…
Converting iTunes files or MPEG4 files to MP3 format is easy using the iTunes client. We will want to change the Import Settings which will then allow converting files into the same setting as the Import Settings. Follow the simple steps below and you will be converting your iTunes files to MP3 in no time. iTunes…
Installing dig on a CentOS Linux server is easy with yum. Dig is actually a bind tool so you will be required to install some bind libraries along with the bind utility package. bash [root@server ~]# yum install bind-utils Now you can run something like the below using dig to find MX records.
It is possible when attempting to uninstall SlingPlayer Mobile for Windows SmartPhone from your Windows PC that you will not be able to do so. The initial error I received was the fact that ActiveSync was not installed. The details of the error are below. ERROR: SlingPlayer Mobile For Windows Smartphone – InstallShield Wizard ERROR:…
If you use the Google Toolbar like I do then that is where you store access to all of your bookmarks. The FireFox web browser is set up by default to provide a bookmarks toolbar which if it is not used then its a waste of space. Initially it looks like the bookmarks toolbar is…
To obtain the latest git repo tag issue the below command. In my case this is how we list the latest master version of what is pushed to our test server or live server. bash [web@server project]# git describe 1.0.0-21-g58c28a4 Our format is main_version-revision-hash which will ensure that all commits are unique. You can issue…
To modify a user’s password in PostgreSQL via the psql CLI use the below syntax. bash [postgres@server pgsql]# psql -U postgres postgres=# ALTER USER user WITH PASSWORD ‘password’; Change user to the proper username and password to the new password you want to set. You will see a “ALTER ROLE” confirmation after issuing the command.