×

Set a Static IP on Debian 11 - How to do it ?

This article covers the different ways of assigning a static IP on your Debian 11 system which could either be via GUI or the terminal. In fact, DHCP or Dynamic Host Control Protocol dynamically assigns an IP address to an interface. It requires a DHCP server running in the network. In the static IP assignment, we manually assign the IP address, routing gateway, and DNS resolvers. Static IP assignment gives to more control on assigning an IP address and setting the DNS resolvers.

Install VirtualBox Guest Additions on Debian 11 - Best Method ?

This article covers how to successfully install VirtualBox Guest Additions on Debian 11. In fact, Using VirtualBox you can run multiple guest operating system simultaneously. The Guest Additions provides some useful functionalities for guest machines like a mouse pointer integration, full screen view, shared folders, shared clipboard, better and accelerated and much more.

Change Font Type, Size, and Color on Debian 10 Terminal

This article covers how to change the font type, size, and color of a Debian Terminal and give a new look and feel to your Terminal text and background. If you spend a lot of time working in Terminal on your Linux system, you probably may not be comfortable with its default font size. Too small font size sometimes can give a burden to your eyes. However, the Terminal application in Linux gives you the flexibility to customize its look and feel to suit your style and need.

Install Emacs Editor in Debian 10 - Best Method ?

This article covers the different methods to install Emacs on Debian OS. Emacs is a widely used open-source text editor for Linux. It exists for many years now and can be used for basic word processing, code editing, and scripting, etc.


How to Install Emacs editor on Debian ?

1. To start the installation process, login with root and update the package repository with the following command.

$ apt-get update

2. Next, run the following command on the terminal and wait for the operation to complete. This can take several minutes. When you are asked for confirmation, press Y from your keyboard.

$ apt-get install emacs

Optimize Images in Debian 10 Linux System Using Trimage

This article covers how to optimize any type of JPEG and PNG images to save some precious disk space on your computer. Sometimes we need to optimize our images so they can take up less disk space and load faster in our websites. A very nice and easy-to-use tool for everyone that can help us optimize our image files for the web by removing EXIF, other metadata and unnecessary comments is Trimage. This image optimizing program is inspired by ImageOptim which is another open-source program used to optimize image files in machines that run Mac Os X.


To install Trimage in Debian and Ubuntu just execute the following command.

$ sudo apt-get install trimage

Send Processes to the Background in Debian 10 - Best Method ?

This article covers the best method to send processes to the background in your Linux system. This is helpful, if you have started a command on terminal and that command is taking to much time. Now you want to move that in background, so that you can continue with other tasks.


To list all jobs running in background use jobs command. It will show all running commands with their job id:

$ jobs


How to Place a Running Foreground Process into the Background in Linux ?

A foreground process is the a process. In order to place a foreground process into the background, we must first put the process to sleep, and then place it in the background.

Execute the command to run your process.

Press CTRL+Z to put the process into sleep.

Run the bg command to wake the process and run it in the background.

Install Java on Debian 9 System - Step by Step Process ?

This article covers how to install and manage multiple Java versions on Debian 9 system. Also we described how to set default Java version and also how to uninstall Java once it is no longer needed.

Basically, the programming language Java and the Java virtual machine or JVM are used extensively and required for many kinds of software.


To install Default JRE/JDK Java on Debian.

1. First, update the package index.

$ sudo apt-get update

2. Next, install Java. Specifically, this command will install the Java Runtime Environment (JRE).

$ sudo apt-get install default-jre

When prompted, type y for yes to confirm the installation.

3. You can install the JDK with the following command:

$ sudo apt-get install default-jdk

Install and Configure VNC on Debian 9 - Step by Step Process ?

This article covers how to install and configure VNC on Debian Linux System. Also, you will learn how to connect it from Linux, MacOS and Windows local system and manage your Debian 9 server easily using a graphic interface.
VNC (Virtual Network Computing) is a technology for remote desktop sharing. VNC enables the visual desktop display of one computer to be remotely viewed and controlled over a network connection. It is similar to MSTSC on windows. It uses the Remote Frame Buffer protocol (RFB) to remotely control another computer.


To install VNC and XFCE on Debian, run the following commands:

$ apt-get update
$ apt-get install xfce4 xfce4-goodies gnome-icon-theme tightvncserver


To Create a VNC User on Debian:
1. Create a user named vnc by using this command.

$ adduser vnc
2. Install sudo by executing this command. We will need to add vnc user to sudo group.
$ apt-get install sudo
3. Now, Add vnc user to sudo group, it will give permission to vnc user to act like a root user and execute root command.
$ gpasswd -a vnc sudo
Adding user vnc to group sudo
4. switch to a vnc user for further operations.
$ su - vnc

Different ways to Check Debian Version ?

This article covers how to check OS version using different methods. You can get more information on Debian releases at official site of the Debian Releases

The easiest way on how to check what Debian version you are running is to simply read a contents from /etc/issue file. Execute the command:

# cat /etc/issue

Also, you can check for /etc/os-release release file:

# cat /etc/os-release

Change Hostname on Debian 9 - Do it Now ?

This article covers how to change the hostname on Debian 9 system using different methods. Basically, the hostname is a label that is assigned during the initial server setup and it is used to identify and easily distinguish one server from another. 

To check your current hostname:

$ hostname

And to check your Fully Qualified Domain name (FQDN) you can run the following command instead:

$ hostname -f


How to Change your Debian hostname ?

1. To change your hostname, we can simply run the following command:

$ hostname new.hostname.com

2. So in order to change our hostname permanently, you will need to update this file. You can open it with your favorite text editor, for example:

$ nano /etc/hostname

3. Change the hostname, save the file and exit the text editor.

Configure SSH Keys on Debian 9 System - How to do it ?

This article covers how to create a new SSH key pair and set up an SSH key-based authentication. You can set up same key to multiple remote hosts. Also, you will learn how to disable SSH password authentication. SSH stands for Secure Shell and works as a method to establish remote connections between computers. SSH is usually used to log in and manage a remote server.

SSH key pairs can be used to authenticate a client to a server. The client creates a key pair and then uploads the public key to any remote server it wishes to access. This is placed in a file called authorized_keys within the ~/. ssh directory in the user account's home directory on the remote server.


To Disable Password Authentication:

Disabling password authentication is a security precaution. It prevents brute-force attacks against attempting to log in to the server.

1. Start by logging into the remote server:

$ ssh user@hostname

2. Next, edit the sshd_config file in a text editor of your choice (we are using nano):

$ sudo nano /etc/ssh/sshd_config

3. Find and modify the following lines to look as follows:

PasswordAuthentication no
ChallengeResponseAuthentication no
UsePAM no

4. Write the changes, then exit the editor. Restart the SSH service by entering the following:

$ sudo systemctl restart ssh

Install Git on Debian 9 System - Step by Step Process ?

This article covers how to install Git on your Debian server and how to Setting up Git. With versioning tools such as Git, you can track changes, revert to previous stages, and branch to create alternate versions of files and directories.


How to Install Git with Default Packages on Debian?

1. First, use the apt package management tools to update your local package index. 

After updating the system, you can download and install Git:

$ sudo apt update
$ sudo apt install git

2. You can confirm that you have installed Git correctly by running the following command:

git --version

Install MySQL on Debian 9 Stretch - Step by Step Process ?

This article covers how to install mysql 8.0 and Secure MySQL on Debian 9 server. MySQL, the world's most popular open-source relational database management system is not available in the default Debian's repositories. MariaDB is the default database system in Debian 10. 

The MySQL APT repository provides a simple and convenient way to install and update MySQL products with the latest software packages using Apt. The MySQL APT repository provides MySQL packages for the following Linux distros: Debian.


How to Uninstall MySQL from Debian?

To remove MySQL, Run the following commands:

$ sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
$ sudo apt-get autoremove -y
$ sudo apt-get autoclean
rm -rf /etc/mysql
sudo find / -iname 'mysql*' -exec rm -rf {} \;


How to secure MySQL ?

MySQL comes with a command we can use to perform a few security-related updates on our new install. Let's run it now:

$ mysql_secure_installation

This will ask you for the MySQL root password that you set during installation. Type it in and press ENTER. Then answer a series of yes or no prompts. 

Secure Nginx with Let's Encrypt on Debian 9 - How to do it ?

This article covers how to install certbot client, obtain Let's Encrypt SSL certificate and configured to Nginx to use the certificates. Also you will learn how to set up a cronjob for automatic certificate renewal.


To install the Certbot software on Debian:

1. Update your package list.

$ sudo apt update

2. Next, install the dependencies for the python3-certbot-nginx package, which include the python3-acme, python3-certbot, python3-mock, python3-openssl, python3-pkg-resources, python3-pyparsing, and python3-zope.interface packages.

$ sudo apt install python3-acme python3-certbot python3-mock python3-openssl python3-pkg-resources python3-pyparsing python3-zope.interface

3. Finally, install the python3-certbot-nginx package:

$ sudo apt install python3-certbot-nginx

Configure Nginx Server Blocks on Debian 9 - How to do it ?

This article covers how to create an Nginx server blocks to host multiple website on a single Debian machine. Nginx is a very popular high-performance web server that combines the power of reverse proxying, load balancing, caching and so much more. Depending on how it is configured, it can act as a reverse proxy as well as a load balancer for HTTP/HTTPS servers.


To install Nginx on Debian:

1. Update the Debian 10 Package Repository.

$  sudo apt update -y

2. Install Nginx on Debian 10.

$ sudo apt install nginx -y

3. To check the status of Nginx, execute:

$ systemctl status nginx

Install Nginx on Debian 9 Server - Step by Step Process ?

This article covers how to install Nginx on your Debian 9 server. Now you can deploy your applications and use Nginx as a web or proxy server. Nginx is more resource-friendly than Apache in most cases and can be used as a web server or reverse proxy.


To install Nginx on Debian:

1. Update our local package index so that we have access to the most recent package listings:

$ sudo apt update

2. We can now install nginx:

$ sudo apt install nginx

When prompted to confirm the installation, hit Enter to proceed. After that, apt will install Nginx and any required dependencies to your server.


Profiles available for Nginx:

  • Nginx Full: This profile opens both port 80 (normal, unencrypted web traffic) and port 443 (TLS/SSL encrypted traffic).
  • Nginx HTTP: This profile opens only port 80 (normal, unencrypted web traffic).
  • Nginx HTTPS: This profile opens only port 443 (TLS/SSL encrypted traffic).

Install phpMyAdmin with Apache on Debian 9 - Step by Step Process ?

This article covers step by step process to Install and Configure phpMyAdmin with Apache on Debian 9 system. The phpMyAdmin utility is a graphical database management tool. By installing phpMyAdmin, you no longer need to use a default command-line interface to manage your databases.


To install wget:

1. Access your terminal window, and update your software package lists using the following command:

$ sudo apt update

2. The wget utility allows you to download files directly from the terminal window. Enter the following command to install the wget tool:

$ sudo apt install wget -y


To install Apache on Debian:

1. Open a terminal window, and install Apache by entering the following command:

$ sudo apt install apache2 -y

2. Enter the following command to make sure the Apache service is running:

$ systemctl status apache2

In the output, you should see a green status that says active (running).


To Install PHP on Debian 10:

1. Install core PHP packages and Apache and MySQL plugins with the following command:

$ sudo apt install php php-cgi php-mysqli php-pear php-mbstring php-gettext libapache2-mod-php php-common php-phpseclib php-mysql -y

2. Once the installation process is complete, verify that PHP has been installed:

$ php --version

The system displays the current version of PHP, along with the date of the release.

Install MariaDB on Debian 9 Server - Step by Step Process ?

This article covers how to install MariaDB version on a Debian 10 server, and verify that it is running and has a safe initial configuration.


How To Install MariaDB on Debian 10 ?

1. To install MariaDB, update the package index on your server with apt:

$ sudo apt update

2. Then install the package:

$ sudo apt install mariadb-server

3. To Configure MariaDB, Run the security script:

$ sudo mysql_secure_installation

Configure Apache Virtual Hosts on Debian 9 - Step by Step Process ?

This article covers how to Configure up Apache Virtual Hosts on a Debian 10 server. Using Apache Virtual Hosts you can host multiple domains on a single server. 

Apache will break its functionality and components into individual units so you can customize independently. The basic unit that describes an individual site or domain is called a virtual host.


How to configure Apache Virtual Hosts on Debian ?

Apache is a free and open source web server used web server in the world, and it is commonly used in Linux servers.

To install Apache:

1. Check whether apache is already installed and running on your server. You can do this with the following command:

$ dpkg -l apache2

2. If apache is not installed, you can do this by running the following commands. First, make sure that the system repositories are up to date:

$ apt-get update

3. To install the Apache web server, execute the following:

$ apt-get install apache2

4. After the installation is complete, you should enable Apache to start automatically upon server reboot with:

$ systemctl enable apache2

5. You can also check the status of your Apache service with the following command:

$ systemctl status apache2

If you want to secure your website with an SSL certificate, you can generate and Install a free Letsencrypt SSL certificate.

Create a Sudo User on Debian - Step by Step Process ?

This article covers how to create a user with sudo privileges. You can now log in to your Debian server with this user account and use sudo to run administrative commands. Basically, In linux sudo is masterpiece to allow users to execute commands with another user's privileges, default is root user.


How to Create a new user account in Debian ?

Create a new user account using the adduser command. Don't forget to replace username with your desired user name:

$ adduser username


To Add the user to the sudo group

Use the usermod command:

$ usermod -aG sudo username

Install Arduino IDE on Debian 10 - Step by Step Process to implement it ?

This article covers different methods to install the Arduino IDE on Debian system. To get the latest version of Arduino IDE, simply go for installation via tarball and snap. If you prefer an older release of Arduino, go for installation via apt.

Arduino boards are able to read inputs – light on a sensor, a finger on a button, or a Twitter message – and turn it into an output – activating a motor, turning on an LED, publishing something online. You can tell your board what to do by sending a set of instructions to the microcontroller on the board. 

To do so you use the Arduino programming language (based on Wiring), and the Arduino Software (IDE), based on Processing.”


To Install Arduino IDE on Ubuntu:

1. Execute the command:

$ sudo apt install Arduino

2. You will be provided with Y/N option, press y to continue.

3. Now wait for a while until the installation of Arduino IDE is completed.


To Launch Arduino IDE:

To launch Arduino IDE application on your system, hit the super key and in the search bar that appears, type Arduino. When the Arduino IDE icon appears, click on it to launch.

You will see the default view of Arduino IDE.

Install and Configure Apache Web Server with Virtual Host on Debian 10 - Do it now ?

This article covers how to perform installation and configuration of Apache web server on Debian 10.

Also, you will learn how to create virtual hosts on an Apache server and troubleshoot errors. These steps are almost the same for Ubuntu and LinuxMint distributions.

Apache HTTP Server is a free and open-source web server that delivers web content through the internet. It is commonly referred to as Apache and after development, it quickly became the most popular HTTP client on the web.


On most systems if you installed Apache with a package manager, or it came preinstalled, the Apache configuration file is located in one of these locations: /etc/apache2/httpd. conf. /etc/apache2/apache2.


Debian/Ubuntu Linux Specific Commands to Start/Stop/Restart Apache:

1. Restart Apache 2 web server, enter: # /etc/init.d/apache2 restart. $ sudo /etc/init.d/apache2 restart.

2. To stop Apache 2 web server, enter: # /etc/init.d/apache2 stop.

3. To start Apache 2 web server, enter: # /etc/init.d/apache2 start.


To check running status of LAMP stack:

1. For Ubuntu: # service apache2 status.

2. For CentOS: # /etc/init.d/httpd status.

3. For Ubuntu: # service apache2 restart.

4. For CentOS: # /etc/init.d/httpd restart.

5. You can use mysqladmin command to find out whether mysql is running or not.

Find Files in Debian 10 - How to perform this ?

This article covers the different methods of finding files in Debian 10. 


To find a file in Debian:

Use the Locate command

1. Debian and Ubuntu sudo apt-get install locate.

2. CentOS yum install locate.

3. Prepare locate command for first use. To update the mlocate.db database before first use, run: sudo updatedb. 

To use locate, open a terminal and type locate followed by the file name you are looking for.


To locate a file in Linux:

1. find . - name thisfile.txt. If you need to know how to find a file in Linux called thisfile.

2. find /home -name *.jpg. Look for all . jpg files in the /home and directories below it.

3. find . - type f -empty. Look for an empty file inside the current directory.

4. find /home -user randomperson-mtime 6 -iname ".db".


To find packages in Debian:

You can also search for a package using the aptitude Ncurses user interface. 

1. Type 'aptitude' in the terminal and the following interface will be displayed in the window. 

2. To search for a package, press '/' and then type the package name into the search bar.


How to use grep to find a file?

The grep command searches through the file, looking for matches to the pattern specified. 

To use it type grep , then the pattern we're searching for and finally the name of the file (or files) we're searching in. 

The output is the three lines in the file that contain the letters 'not'.


To list files in Linux:

The easiest way to list files by name is simply to list them using the ls command. Listing files by name (alphanumeric order) is, after all, the default. 

You can choose the ls (no details) or ls -l (lots of details) to determine your view.


Which command have more searching options to search a file in file system in Linux?

Grep is a Linux / Unix command-line tool used to search for a string of characters in a specified file. The text search pattern is called a regular expression. 

When it finds a match, it prints the line with the result. 

The grep command is handy when searching through large log files.


grep is a command-line utility for searching plain-text data sets for lines that match a regular expression. 

Its name comes from the ed command g/re/p (globally search for a regular expression and print matching lines), which has the same effect.


To grep recursively in a directory:

To recursively search for a pattern, invoke grep with the -r option (or --recursive ). When this option is used grep will search through all files in the specified directory, skipping the symlinks that are encountered recursively.

Block or Unblock Ping Request on Debian 10 - How to perform this task ?

This article covers how you can block/unblock ping requests to your Debian system. You will learn different ways for blocking/unblocking ping requests either temporarily or permanently.


The --query-icmp-block=<type> option can be used to determine if a type is confgured to allow or deny. 

The --add-icmp-block=<type> option can be used to block a certain type. 

The --remove-icmp-block=<type> option can be used to not block a certain type. 

After adding or removing a block, reload the firewall.


To block ping requests in Linux:

1. Edit /etc/sysctl.conf. Add the following line to your /etc/sysctl.conf : net.ipv4.icmp_echo_ignore_all=1. Then: sysctl -p.

2. Using iptables: iptables -I INPUT -p icmp --icmp-type echo-request -j DROP.

3. With cron. Run crontab -e as root, then add the following line: @reboot echo "1" > /proc/sys/net/ipv4/icmp_echo_ignore_all.


To block ping in iptables:

1. Add a rule that tells the iptables firewall to block ping in and out of a server by controlling the ICMP requests.

2. Remove the rule that tells the iptables firewall to allow ping in and out of a server by controlling the ICMP requests.


To enable ping on Linux server?

# iptables -D INPUT -p icmp --icmp-type echo-request -j REJECT D : 

This command switch is used to delete the rule. Once the ping enabled, the server should now respond to ping requests

Modify Date, Time, and Timezone in Debian 10 - How to do it ?

This article covers how you can easily change the date, time, and timezone in your Debian system. To change your Debian system's timezone, run the sudo timedatectl set-timezone command followed by the long name of the time zone you want to set

Based on your convenience, you can either choose the command line or the GUI method. If you are using Ubuntu OS, you can visit our post on How to Change the Date, Time, and Timezone in Ubuntu 20.04 LTS .


Using the correct timezone is essential for many systems related tasks and processes. 

For example, the cron daemon uses the system's timezone for executing cron jobs, and the timestamps in the log files are based on the same system's timezone.

On Debian, the system's timezone is set during the install, but it can be easily changed at a later time.


To check the Current Timezone:

timedatectl is a command-line utility that allows you to view and change the system's time and date. It is available on all modern systemd-based Linux systems:

$ timedatectl


To modify Change Time Zone in Debian 10 / Debian 9:

1. Using /etc/localtime File. In this method, we will use /etc/localtime (link to the original time zone file) file to set the timezone for your system.

2. Using timedatectl command. In this method, we will use the timedatectl command to change the time zone in Debian.

Assign Multiple IP Addresses to Single NIC in Debian 10 - How to do it ?

This article covers how to assign and remove multiple IP addresses to and from a single NIC. Based on your preferences, you can either assign the multiple IP addresses temporarily or permanently.

There's no simple command that you can run to determine whether the IP address on a Linux system is assigned by DHCP or static. 

If it changes when the system restarts, it's clearly dynamically assigned, but even a dynamic address has some resistance to change. 

The best way is to look at the configuration file.


To add a static route in Linux:

1. Use the route command with the –p option to add a persistent route: # route -p add default ip-address.

2. Use the route command with the –name option to add a persistent route by specifying a name rather than destination and gateway: # route -p add destination-address gateway-address -name name.


What is ip route command in Linux?

ip route is used to manipulate entries in the kernel routing tables. 

Route types: 

1. unicast - the route entry describes real paths to the destinations covered by the route prefix. 

2. unreachable - these destinations are unreachable. 

Packets are discarded and the ICMP message host unreachable is generated.

Create and Run a Shell Script in Debian 10 -Step by step process to do it ?

This article covers how to easily create a shell script and automate repetitive jobs in #Linux. Shell scripts are just a series of commands that you add in a file and run them together.  


To write and execute a #script:

1. Open the #terminal. Go to the directory where you want to create your script.

2. Create a file with . sh extension.

3. Write the script in the file using an editor.

4. Make the script executable with command chmod +x <fileName>.

5. Run the script using ./<fileName>.


#Shell is a #UNIX term for an interface between a user and an operating system service. 

Shell provides users with an interface and accepts human-readable commands into the system and executes those commands which can run automatically and give the program's output in a shell script.

Reboot Debian 10 - Different methods to do it ?

This article covers different methods to reboot your Debian 10 system. reboot command is used restart or reboot the system.
In a Linux system administration, there comes a need to restart the server after the completion of some network and other major updates.
It can be of software or hardware that are being carried on the server.

To reboot Linux using the command line:
1. To reboot the Linux system from a terminal session, sign in or “su”/”sudo” to the “root” account.
2. Then type “ sudo reboot ” to reboot the box.
3. Wait for some time and the Linux server will reboot itself.

To restart a Linux (Ubuntu / Debian) network?
1. Use the following command to restart the server networking service. # sudo /etc/init.d/networking restart or # sudo /etc/init.d/networking stop # sudo /etc/init.d/networking start else # sudo systemctl restart networking.
2. Once this done, use the following command to check the server network status.

Install MongoDB on Debian 10 - Step by step process to do it ?

This article covers how to #install / #uninstall MongoDB on your Debian system. You have also learned how to manage MongoDB services.
MongoDB is an opensource, cross-platform NoSQL database server.
In MongoDB, data is stored in flexible, JSON-like documents where fields can vary from document to document.
It does not require a predefined schema, and data structure can be changed over time.

To install MongoDB on #Debian:
Perform the following steps as root or user with sudo privileges to install MongoDB on a Debian system.
1. Install the packages required for adding a new repository:

$ sudo apt install dirmngr gnupg apt-transport-https software-properties-common ca-certificates curl

2. Add the MongoDB GPG key to your system:

$ curl -fsSL https://www.mongodb.org/static/pgp/server-4.2.asc | sudo apt-key add -

3. Enable the MongoDB repository:

$ sudo add-apt-repository 'deb https://repo.mongodb.org/apt/debian buster/mongodb-org/4.2 main'

4. Packages with older versions of MongoDB are not available for Debian 10.
Update the packages list and install the mongodb-org meta-package:

$ sudo apt update
$sudo apt install mongodb-org


The following packages will be installed on the system as a part of the mongodb-org package:
mongodb-org-server - The mongod daemon and corresponding init scripts and configurations.
mongodb-org-mongos - The mongos daemon.
mongodb-org-shell - The mongo shell is an interactive JavaScript interface to MongoDB. It is used to perform administrative tasks through the command line.
mongodb-org-tools - Contains several MongoDB tools for importing and exporting data, statistics, as well as other utilities.

To Start the #MongoDB service and enable it to start on boot:

sudo systemctl enable mongod --now

Install Google Chrome on Debian 10 - How to do it ?

This article covers different methods to install and enjoy Google Chrome on your Debian 10 system. Moreover, whenever you feel like you do not need this browser any longer, then we have even explained to you the method of removing this browser from your Debian 10 system for your convenience.


To Install Google Chrome on Debian:

1. Downloading Google Chrome. Open the terminal either by using the Ctrl+Alt+T keyboard shortcut or by clicking on the terminal icon.

2. Installing Google Chrome. Once the download is complete, install Google Chrome with apt : sudo apt install ./google-chrome-stable_current_amd64.deb.

Install PostgreSQL on Debian 10 - Step by step process to do it ?

This article will guide you on how you can install PostgreSQL #DBMS on your Debian 10 system. Also, we also shared with you the method with which you can remove the PostgreSQL DBMS from your #Debian 10 system.

#PostgreSQL supports transaction s, subselects, trigger s, view s, foreign key referential integrity, and sophisticated locking.


pgAdmin is the de facto GUI tool for PostgreSQL, and the first tool anyone would use for PostgreSQL. It supports all PostgreSQL operations and features while being free and open-source. With pgAdmin you can Create, view and edit on all common PostgreSQL objects.

#PgAdmin is graphical user interface administration tool for PostgreSQL. It does not include a PostgreSQL database server.


To install PostgreSQL 9.5 on #Ubuntu:

1. sudo apt-get update.

2. sudo apt-get install postgresql postgresql-contrib.

3. sudo -u postgres psql.

4. # Replace xxxxxxx with your own password ALTER USER postgres WITH ENCRYPTED PASSWORD 'xxxxxxx';

5. # Feel free to replace nano with an editor of your choice sudo nano /etc/postgresql/9.5/main/pg_hba.conf.


ANALYZE in #Postgres collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. Subsequently, the query planner uses these statistics to help determine the most efficient execution plans for queries.

Install Wine on Debian 10 - Step by step process ?

This article will guide you on steps to install Wine on Debian via WineHQ repository. Also you will learn how to uninstall it from your system if you no longer need it. 

For official documentation, you can visit Wine for Debian.

If you are working on Linux Mint OS, visit our post on How to Install Wine on Linux Mint 20 .


Wine stands for Wine Is Not an Emulator. While a virtual machine or emulator simulates internal Windows logic, Wine translates those Windows logic to native UNIX/POSIX-complaint logic. 

In simple and non-technical words, Wine converts internal Windows commands to commands your Linux system can natively understand.


To Check Wine Version:

Wine installation successfully completed. 

Use the following command to check the version of wine installed on your system

wine --version 


A Linux repository is a storage location from which your system retrieves and installs OS updates and applications. 

Each repository is a collection of software hosted on a remote server and intended to be used for installing and updating software packages on Linux systems.

Repositories contain thousands of programs.

Methods to Log Out of Debian 10 ?

This article will guide you on how you can log out from your Debian 10 system. Here, you will learn the different methods of logging out of a #Debian system. 

exit command in #linux is used to exit the shell where it is currently running. 

It takes one more parameter as [N] and exits the shell with a return of status N. 

If n is not provided, then it simply returns the status of last #command that is executed. Syntax: exit [n].

pkill is a command-line utility that sends signals to the processes of a running program based on given criteria. 

The processes can be specified by their full or partial names, a user running the process, or other attributes.

Methods to uninstall programs from Debian 10 ?

This article will guide you on how to uninstall programs from Debian 10. The first method can be used if you prefer #GUI over #CLI. The second method can be used if you only intend to delete a program without its configuration files. The third mthod can be used if you intend to delete a program along with all of its configuration files. Finally, the fourth mthod can be used if you want to get rid of all the unused packages and dependencies altogether.

Whenever you add a repository using "add-apt-repository" command, it will be stored in /etc/apt/sources. list file. 

To delete a software repository from Ubuntu and its derivatives, just open the /etc/apt/sources. list file and look for the repository entry and delete it.

Running sudo apt-get update (or sudo aptitude update ) updates this on your local system. This is the step that actually retrieves information about what packages can be installed, including what updates to currently installed packages packages are available, from Internet sources.

To Uninstall Programs on #Debian:

1. Go to the Installed tab. 

2. It will list all the installed #applications in your system. 

3. From the list, search for the application you want to #uninstall and click the Remove button in front of it. 

4. When you click the Remove button, the following message will appear for you to confirm the decision.

Step by step process to Install the latest MySQL on Debian 10 ?

This article will guide you on how to #install #MySQL server on Debian 10 #Linux system. Also we looked into how to secure the installation and connect with the MySQL shell. Using the Validate password #plugin you can make a more secure database MySQL password #authentication.

MySQL is an #RDBMS tostore, retrieve, modify and administrate a database usingSQL.

The mysql #command:

1. -h followed by the server host name (server.linuxapt.com).

2. -u followed by the account user name (use your MySQL username).

3. -p which tells mysql to prompt for a password.

4. database the name of the database (use your database name).

How to create and run a Perl script in Debian 10 ?

This article will guide you on steps to create your first #Perl #script and execute it in Debian 10. Here you will learn the basic method of creating and running a simple Perl script. Once you manage to learn this, you can use Perl scripting for lots of other programmatically complex problems.

To run a Perl script:

1. Write and Run Your First Script. All you need to write Perl #programs is a text editor.

2. Write Your Script. Create a new text file and type the following exactly as shown: #!usr/bin/perl.

3. Run Your Script. Back at the command prompt, change to the directory where you saved the Perl script.

How to Set Up OpenVPN Server on Debian 10 ?

This article will guide you on how to set up an OpenVPN server on Debian Linux 10 server.