Explore information related to postgresql


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.


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


Install Nextcloud with Nginx on Ubuntu 20.04 LTS - Step by step guide ?

This article covers the process of installing  and configuring Nextcloud personal cloud storage on your Ubuntu 20.04 LTS Focal Fossa system. In fact, Nextcloud is a free (Open Source) Dropbox-like software, a fork of the ownCloud project. Nextcloud is written in PHP and JavaScript, it supports many database systems such as MySQL/MariaDB, PostgreSQL, Oracle Database, and SQLite.

In order to keep your files synchronized between Desktop and your own server, Nextcloud provides applications for Windows, Linux, and Mac desktops and a mobile app for Android and iOS. Nextcloud is not just a Dropbox clone, it provides additional features like Calendar, Contacts, Schedule tasks, and streaming media with Ampache etc.


Install Zabbix on Debian 10 - A step by step guide ?

This article covers the best method of installing Zabbix monitoring software in Debian 10 Buster systems. In fact, Zabbix is 100% free open-source ultimate enterprise-level software designed for monitoring availability and performance of IT infrastructure components. 

For additional help or useful information, we recommend you to check the official Zabbix website.


Install PostgreSQL 13 on Debian 11 - A step by step guide ?

This article covers a step-by-step procedure of installing PostgreSQL 13 on Debian 11 Bulls-Eye. In fact, PostgreSQL is an open source, powerful, resilient and fault tolerant relational database management system powering many mission critical applications. 


Features of PostgreSQL 13 includes:

  • Improvements from de-duplication of B-tree index entries – Space savings and performance gains from.
  • Queries that use aggregates or partitioned tables gets improved performance.
  • Incremental sorting.
  • Better query planning when using extended statistics.
  • Parallelized vacuuming of indexes.


Install PgAdmin 4 on Rocky Linux 8 - Step by Step Process ?

This article covers how you can Install and easily get started with PgAdmin4 for your Linux system. pgAdmin is an advanced, open-source, full-featured, and web-based administration and management tool for the PostgreSQL database server.



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