HowTo change a user into a SUPERUSER in PostgreSQL

Modifying user permissions within PostgreSQL can range from rather simple to extremely complex, depending on the permissive granularity that is actually required. In most cases, however, it is the powerful ALTER USER command that should be utilized to do everything from allowing users to login, create databases, manage roles, and even become a SUPERUSER account.

In this little HowTo, we will explore the power of the ALTER USER command so you can easily perform a variety of permission assignments and removals as the need arises.


Keyboard Shortcuts Keys

What is a Keyboard Shortcut?

In computing, a keyboard shortcut is a set of one or more keys that invoke a command in software or an operating system.

They are typically an alternate means for invoking commands that would otherwise be accessible only through a menu, a mouse, or an aspect of the user interface. These shortcuts can expedite common operations by reducing input sequences to a few keystrokes.

These shortcuts can provide an easier and quicker method of using computer programs. These commands are commonly accessed by using the [Alt] key (on PC computers), [command key] (on Apple computers), [Ctrl], and [Shift] in conjunction with a single letter.

These shortcuts are for the following programs and applications.

  • Word
  • Windows
  • Internet Explorer
  • File Explorer
  • Windows System Commands
  • Firefox
  • Excel
  • Mac
  • Finder
  • Chrome



AOC USB Displaylink Raspberry Pi

AOC_e1659FwuThere’s good news and bad news:

Bad News:

You expected to struggle with this. You expected that this will be as tricky as it used to be. Rotten luck, chum.

Good news:

Create a file called called:



Autorun apps Raspberry Pi on Raspbian GUI / Terminal

Raspberry Pi 3Sometimes you want stuff to run at startup, be it an application or a forced setting. This is fairly easy to achieve in Rasbpian, here’s how:

You can use the Raspbian preferences via the GUI to cause the pi user to be auto logged in at boot up and the GUI to automatically run. However, if you need to run with root privileges due to needing IO pin control (PLEASE NOTE: It is not advised to run as root) then set the Raspbian preferences to boot to the command line. Now open this file by editing it(you can use your favourite editor, for this example we use nano):

sudo nano /etc/rc.local

Before the “exit 0” line in it add the following line:

#Auto run the GUI as root
sudo startx

Save it by pressing Ctrl+X, ” Y“, ENTER

Reboot your RPi and it should automatically run the GUI as the root user.

Setting An Application To Automatically Run In The GUI (more…)