TECH TIPS
Mozilla SSL Configuration Generator
Nifty tool to show you a generic SSL configuration would look like for Apache, nginx, AWS ELB, among others. See tool here.
How to drop a PostgreSQL database if there are active connections to it?
I need to write a script that will drop a PostgreSQL database. There may be a lot of connections to it, but the script should ignore that. The standard DROP DATABASE db_name query doesn't work when there are open connections. How can I solve the problem? This will...
Permission denied in Postgres
I added the user myuserto Postgres. Then I added the database mydatabase in the pgAdmin III GUI and restored from a backup file. So the owner of mydatabase is the superuser postgres. Then I tried to give all rights to access and modify mydatabase to myuser. I logged...
Export all your G Suite data in one step
Today, we’re introducing data export, a new feature to make it even easier to export and download a copy of your data securely from our G Suite services. To initiate the process, in the Admin console, navigate to the Tools section of the right-side slideout menu and...
Connect to Amazon EC2 Instance from Nautilus without Using Password File
Lately, I have been working frequently with a couple EC2 instances. Remote editing on these instances has become a day-to-day task for me. These instances are based on Amazon Linux. I am so used to the "Ubuntu" way of remote editing, which I have described here....
How To Configure Custom Connection Options for your SSH Client
Introduction SSH, or secure shell, is the most common way of connecting to Linux hosts for remote administration. Although the basics of connecting to a single host are often rather straight forward, this can become unwieldy and a much more complicated task when you...