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

PostgreSQL Interview Q&A Part-1

PostgreSQL Interview Q&A Part -1 PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance. The frequently asked questions from PostgreSQL database are given below. 1.Difference between Alert log in Oracle and Error log in PostgreSQL? Error log to PostgreSQL is… Read More