Installation of PostgreSQL

Installation of PostgreSQL As PostgreSQL is an open source, we can download it from official website (www.postgresql.org) by following below steps: Go to official website >> Click on Download >> Choose your System OS >> Click “Download the installer” Select latest version (15.2 present) of… Read More

Introduction to PostgreSQL

Introduction to PostgreSQL • PostgreSQL (pronounced as post-gress-Q-L) is a high demand open-source object relational database management system (ORDBMS). It was developed by a worldwide team of volunteers. It is not controlled by any private entity so, it is available for free. • PostgreSQL uses… Read More

PostgreSQL Articles

PostgreSQL Articles Dear Readers, Please check the below list of PostgreSQL Articles SNo Description Link 1 Installation of PostgreSQL 11.4 On Windows Platform https://www.ktexperts.com/installation-of-postgresql-11-4-on-windows-platform/ 2 How to Download and Install the pgAdmin 4 https://www.ktexperts.com/how-to-download-and-install-the-pgadmin-4/ 3 Installation of PostgreSQL 11.4 in Linux Platform. https://www.ktexperts.com/installation-of-postgresql-11-4-in-linux-platform/ 4 Install… Read More

PostgreSQL Interview Q&A Part-3

PostgreSQL Interview Q&A Part-3 Before going into the article, please check our previous article on PostgreSQL Q&A Part-2 1. Can we have different data directories for PostgreSQL Cluster? Under One PostgreSQL installation, you can create multiple Clusters.  Each Cluster will have its own data directory. One… Read More

PostgreSQL Interview Q&A Part-2

PostgreSQL Interview Q&A Part-2 Before going into the article, please check our previous article on PostgreSQL Q&A Part-1 1. What are template0 & template1 databases? As the name suggests, these are template databases that come by default with the Installation. In a fresh installation, both… Read More