by ray | Jul 18, 2018 | IT / Tech News
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...
by ray | Jul 17, 2018 | Linux / Ubuntu, IT / Tech News
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...
by ray | Jul 16, 2018 | G Suite
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...
by ray | Jul 16, 2018 | AWS
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...
by ray | Jul 16, 2018 | AWS, Linux / Ubuntu
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...
