PostgreSQL – KTEXPERTS

PostgreSQL Articles

11 months ago by KTEXPERTS TEAMPostgreSQL

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

11 months ago by Ankit GoyalPostgreSQL

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

Basic commands in PostgreSQL

11 months ago by Binnary Ajay KumarPostgreSQL

Hello Everyone, This article will help you learning basic commands in postgreSQL. Psql is an interactive terminal to work with the PostgreSQL database. It is used to retrieve data from the PostgreSQL database server faster and more effectively. The below commands are very helpful for… Read More

Tablespace Administration in Postgres – Q&A

12 months ago by Mitesh R SettyPostgreSQL

Tablespace Administration in Postgres – Q&A 1. What is tablespace in Postgres? A. It specifies in which location contents of the tables should be stored. We can’t use a database without tablespace Default tablespace is pg_default Users while creating objects can specify on which tablespace… Read More

PostgreSQL Interview Q&A Part-2

12 months ago by Ankit GoyalPostgreSQL

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

12 months ago by Ankit GoyalPostgreSQL

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

WAL Internals in PostgreSQL

1 year ago by Ankit GoyalPostgreSQL

WAL Internals in PostgreSQL Write-Ahead Log (WAL) is a very important term in transaction processing. In PostgreSQL, it is also known as a transaction log. A log is a record of all the events or changes and WAL data is just a description of changes… Read More

Data Fragmentation in PostgreSQL

1 year ago by Ankit GoyalPostgreSQL

Data Fragmentation in PostgreSQL PostgreSQL is a relational database management system with a client-server architecture. At the server-side, PostgreSQL’s processes and shared memory work together and build an instance, which handles the access to the data. Client programs connect to the instance and request read… Read More

Install PostgreSQL 12 On RHEL 8 in AWS

2 years ago by Ramesh ReddyInstallation of PostgreSQL

Dear Readers, In this article, we will see the following Install PostgreSQL 12 On RHEL 8 . Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget… Read More

Install PostgreSQL12 On SUSE Linux in AWS

2 years ago by Ramesh ReddyInstallation of PostgreSQL

Dear Readers, In this article, we will see the following Install PostgreSQL12 On SUSE Linux. Steps to Follow : Logging to AWS Account Launch PostgreSQL EC2 Instance Connect to Linux EC2 Instance by Using Putty Add PostgreSQL Repository Install PostgreSQL 12 Enable the PostgreSQL Start… Read More