Explore information related to sql


Install PostgreSQL 14 on Debian 11 - Step by step guide ?

This article covers how to install PostgreSQL 14 on the Debian 11 system. In fact, you can easily create the postgreSQL databases on your system. You can follow the steps here to install the PostgreSQL on Ubuntu: https://linuxapt.com/blog/1188-install-postgresql-on-ubuntu-20-04 .

With PostgreSQL 14 installed on your Ubuntu 20.04 system, you can now comfortably use it to steer your database-powered apps or projects to new heights.

Read More



Different methods of Checking MySQL Version in Linux

This article covers the ways to check the MySQL version in Linux. In fact, MySQL (and its drop-in replacement MariaDB) is the most popular open-source relational database management system. There are some important differences between MySQL versions, so knowing which version is running on your server might be important in some situations.


How to Check MySQL Version with V Command ?

The easiest way to find the MySQL version is with the command:

$ mysql -V

The command mysql –V is not OS specific. This command works on Windows, OS X, and Linux distributions including Ubuntu.

Read More



Install SQLite on Debian 11 - Step by step guide ?

This article covers how to install the latest version of SQLite on Debian 11 Bullseye. In fact, SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. 

Read More



Install and Use MySQL Workbench on Fedora 35 / 34 / 33 / 32 - Step by step guide

This article covers how to easily manage your SQL databases using MySQL workbench on Fedora. In fact, the MySQL Workbench on Fedora or REHL allows the database managers, developers or DB architects to visually design the Database. It features Database Connection & Instance Management, SQL Editor, Visual EXPLAIN, SQL snippets collections, SSH connection tunneling, Unicode support, Data modeling, ER diagramming, Drag n Drop visual modeling, Database administration, Database account management, Performance monitoring, Performance Schema metrics, MySQL instance dashboard, Database migration, and more.

Read More



Install PostgreSQL on Ubuntu 20.04 - Step by step guide ?

This article covers how to install PostgreSQL on your Ubuntu 20.04 LTS machine. In fact, PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It's standards-compliant and has many advanced features like reliable transactions and concurrency without read locks.


Service commands for PostgreSQL

The PostgreSQL database server runs as a service under the name "postgresql". You can manage the service by running the commands below.

1. Stop PostgreSQL server:

$ sudo systemctl stop postgresql

2. Start PostgreSQL server:

$ sudo systemctl start postgresql

3. Restart PostgreSQL(e.g. after changing configuration settings) server:

$ sudo systemctl restart postgresql

4. Reload PostgreSQL server:

$ sudo systemctl reload postgresql

5. Check PostgreSQL status:

$ sudo systemctl status postgresql

Read More




For Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on LinuxAPT.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com