Database Administration and Security
Changing PostgreSQL Database Owner
Changing the owner of a PostgreSQL database can be necessary for various reasons, such as transferring responsibilities or updating user…
Tag: psql
CentOS
How to Install PostgreSQL and pgAdmin4 on CentOS/RHEL 9
PostgreSQL is a powerful, open-source object-relational database system known for its robustness, scalability, and compliance with SQL standards. pgAdmin4, on…
General Articles
How to List All Tables in PostgreSQL Database
If you are new to PostgreSQL and databases, you might wonder how to see a list of all the tables…
Database Administration and Security
Creating PostgreSQL User and Assign Permissions
Creating a user in PostgreSQL and assigning permissions might seem complicated, but it’s quite straightforward once you understand the basics.…
General Articles
How To Configure PostgreSQL to Allow Remote Connections
An open-source, object-based relational database PostgreSQL, provides the user with the implementation of SQL and is commonly hosted on Linux.…
Databases
How to Check the PostgreSQL Version
PostgreSQL is an advanced, open-source relational database management system. It is written in C programming language and was developed at…
PostgreSQL
How to Install PostgreSQL 11 on Debian 10 (Buster)
PostgreSQL is an open-source object-relational database system. PostgreSQL 11 is the latest version available for the installation on Debian systems.…
PostgreSQL
How To Install pgAdmin4 on Debian 10/9
pgAdmin is a web-based interface for managing PostgreSQL database instances. With the help of pgAdmin4, We can create, access databases,…
PostgreSQL
How To Install PostgreSQL and pgAdmin4 on Fedora Linux
PostgreSQL, often simply known as Postgres, is an open-source object-relational database system with a strong reputation for reliability, feature robustness,…
PostgreSQL
How to Install PostgreSQL 11 on CentOS/RHEL 7/6
PostgreSQL 11 Released. It is an open-source object-relational, highly scalable, SQL-compliant database management system. PostgreSQL is developed at the University…