Technology Errors

Postgres ERROR: database “dev” is being accessed by other users

If you are having issues dropping a postgres database the issue is more than likely that a user is accessing the database you are attempting to drop. There isn’t technically a way to force drop the postgres database however there are steps you can take to prevent others from accessing the database and if needed kick the users whom are accessing the database.

If you receive an error similar to the below the issue with your attempt to drop the database is the fact that either a user is accessing the database or an application of some sort has an open connection to the database. In the second scenario PostgreSQL considers the application the same as a user. In the code below the name of the example database is dev.

Please note that dropping the database will destroy all data located within the database. I strongly suggest always backing up your data before dropping the database. You can backup the data with pg_dump and regardless of if you think you will need the data or not it is best to keep a copy just in case.

Technology Insights

How to Copy and Paste Notes from Microsoft OneNote into the WordPress Admin

This post will explain how to post notes from Microsoft OneNote into the WordPress admin. When you copy and paste from most Microsoft products into a visual editor such as TinyMCE that WordPress uses you will typically include a bunch of unwanted tags from the Microsoft application. These tags will make it complicated to format correctly and can even spill over outside of your post and cause issues with your entire WordPress page. The method to input this data into WordPress will work with any of the Microsoft products such as Microsoft OneNote and Microsoft Word.

Below is an example of some basic formatted text copied directly from MS OneNote and pasted into WordPress’s visual editor.

Technology Insights

Performance Settings and pagefile.sys Should be Investigated after Upgrading RAM on Windows

After upgrading the RAM on your Windows XP or Windows Vista computer (laptops and desktops) you should review your performance settings. The primary concern will be your pagefile.sys size to make sure it matches or exceeds the amount of RAM you have in the computer. For those of us that are familiar with Linux more so than Windows the pagefile is also called the swap file in Windows. The pagefile or swap file is used for anything that won’t fit into RAM so technically it is an overflow for RAM so the excess has somewhere to go.

RAM: Random Access Memory