HP PCs – Setting Time and Date, Clock Losing Time, Time and Date Incorrect (Windows 10)

Setting the date and time Follow these steps to change the date and time settings. Click the date and time in the taskbar, then click Date and time settings.Figure : Clicking the Date and time settingsThe Date and Time window displays.Figure : Date and time window To set your computer clock to update automatically, turn on the Set time … Read moreHP PCs – Setting Time and Date, Clock Losing Time, Time and Date Incorrect (Windows 10)

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 drop existing connections except for yours: Query pg_stat_activity and get the … Read moreHow to drop a PostgreSQL database if there are active connections to it?

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 into psql as user postgres: psql -d template1 -U postgres and then I ran this query: GRANT ALL PRIVILEGES … Read morePermission denied in Postgres

Install Sublime Text 3 in Ubuntu 16.04 & Higher The Official Way

The popular cross-platform Sublime Text editor finally offers official Linux apt repository to make it easy to install and receive update in Ubuntu. Sublime Text is a proprietary source code editor with a Python API. It supports many programming languages and markup languages, and its functionality can be extended by users with plugins. It’s available to download and use … Read moreInstall Sublime Text 3 in Ubuntu 16.04 & Higher The Official Way