Posts by Tag

Linux_Basics

Linux Hardlink and Softlink/Symlink explained.

2 minute read

What is Inode? it’s the metadata about a regular file and directory in Linux.

How to install LAMP Stack On CentOS 6

2 minute read

This is a simple and straight forward tutorial to install and configure LAMP stack (Linux, Apache, MySQL, PHP) on a CentOS 6 system.

Vim - Powerful Text Editor in Linux!

1 minute read

Vim is one of the handy and most common text editor in Linux. It is a text editor that is upwards compatible to Vi. It can be used to edit all kinds of plai...

Back to Top ↑

postgresql

Monitoring PostgreSQL Replication

2 minute read

PostgreSQL replication is a critical component of database high availability and disaster recovery. Ensuring that replication is running smoothly and identif...

How to Setup PostgreSQL Replication

2 minute read

Setting up PostgreSQL replication ensures that your database remains highly available, providing data redundancy and improving reliability. This guide walks ...

Back to Top ↑

misc

Welcome to New ScratchPad Blog!

less than 1 minute read

Hello World! Every journey in the world of programming begins with a simple Hello World. So, it feels fitting that my very first blog post starts with the ...

Back to Top ↑

Linux

Confusing error: could not bind IPv4 socket: Cannot assign requested address

3 minute read

Postgres service failing with error: “could not bind IPv4 socket: Cannot assign requested address”

Back to Top ↑

Troubleshooting

Confusing error: could not bind IPv4 socket: Cannot assign requested address

3 minute read

Postgres service failing with error: “could not bind IPv4 socket: Cannot assign requested address”

Back to Top ↑

pg_stat_statements

Using pg_stat_statements to Track SQL Planning and Execution in PostgreSQL

2 minute read

The pg_stat_statements module in PostgreSQL provides a way to track the planning and execution statistics of all SQL statements executed by the server. It co...

Back to Top ↑

SQL

Using pg_stat_statements to Track SQL Planning and Execution in PostgreSQL

2 minute read

The pg_stat_statements module in PostgreSQL provides a way to track the planning and execution statistics of all SQL statements executed by the server. It co...

Back to Top ↑

performance

Using pg_stat_statements to Track SQL Planning and Execution in PostgreSQL

2 minute read

The pg_stat_statements module in PostgreSQL provides a way to track the planning and execution statistics of all SQL statements executed by the server. It co...

Back to Top ↑

monitoring

Using pg_stat_statements to Track SQL Planning and Execution in PostgreSQL

2 minute read

The pg_stat_statements module in PostgreSQL provides a way to track the planning and execution statistics of all SQL statements executed by the server. It co...

Back to Top ↑