Skip to main content

Posts

All you want to know about 'idle in transaction' in PostgreSQL

 In the dynamic world of PostgreSQL databases, one term that often catches the attention of database administrators and developers alike is "Idle in Transaction." But what does it really mean, and how can understanding it help you optimize your PostgreSQL database connections? Let's dive into the intricacies of this concept in simple terms. What is "Idle in Transaction" in PostgreSQL? When you run a query in PostgreSQL, a transaction is initiated. The term "Idle in Transaction" refers to a state where a database connection is sitting idle while being within an open transaction. In simpler terms, the connection has started a transaction but hasn't executed any queries for a while. Why Does "Idle in Transaction" Occur? Application Design: In some cases, the application might keep a transaction open even when there's no immediate need to execute a query, leading to an "Idle in Transaction" state. Connection Pooling: If your ap

'SSL certificate problem: unable to get local issuer certificate' Issue while cloning the git

Note: This is not the recomended solution if your git is exposed to internet. This is just a workaround for local / VPN access How to solve SSL issue while cloning the GIT You can trun off the SSL using  git config --global http.sslVerify false $ git -c http.sslVerify=false clone https://192.10.10.21/Git.Server/project.git and provide the 192.10.10.21 's user name and password. Why this is occurring ? While we install Git, we might selected, " Use the OpenSSL Library " instead, we should choose, " Use the native windows secure channel."

PostgreSQL: How to kill the idle connections

Establishing connections is the initial stage in making changes or reading data from a PostgreSQL. Each link, on the other hand, generated overhead through the use of method and storage. That's why a device with few resources (memory, storage, and hardware) can handle a small number of connections. It should continue throwing errors or rejecting connections once the limited aggregate has gone far beyond a point. PostgreSQL does a good job of limiting links within PostgreSQL.conf. We'll look at the many states that PostgreSQL links can have in this tutorial. We'll show you how to identify whether a link is active or has been dormant for an extended period of time, in which case it can be severed to free up resources and links.  What are the different Connection States in PostgreSQL: When a PostgreSQL connection is formed, it can conduct a variety of actions that cause state transitions. Depending on the state and the length of time it has been in each condition, a sensible c

The best Open Source ERP for Small and Medium Enterprises 2021

  The 'Free ERP' refers to items that are provided by a solution provider at no charge. These are typically stripped-down versions of the expert or business editions, with simple features such as report generation and data visualization. These are typically stripped-down versions of the expert or business editions, with simple features such as report generation and data visualization. Commercially free ERP tools usually have less features than their open source counterparts, but they can be a great way to get more than a free trial if you're already interested in the product.  Enterprise Resource Planning (ERP) Software Systems Enterprise Resource Planning software is a scalable software framework that integrates the various functional areas of a company's business processes. Certain core software elements, such as modules, concentrate on various main business areas within the enterprise. The modules are chosen by organizations based on their business needs. Integrated