Active: query is running and session is hitting every threshold time, Idle in transaction: query is completed, and waiting for commit, session is hitting every threshold period. Idle in transaction (aborted): last or some statement was aborted due to network or …
I am facing one issue. I have 3 IP. 1,2 are master and slave and 3 for pgpool. My application direct hit to 3 ,and 3 distribute the connection between master and slave. But in my web application have one …
PREREQUEST : ============ 1. OpenSSL should be install on both client and server systems 2. Confirm whether openssl is installed or not . nijam@2ndquadrant.in:~ # rpm -qa|grep -i openssl openssl-1.0.2j-60.52.1.x86_64 libopenssl1_0_0-1.0.2j-60.52.1.x86_64 python-pyOpenSSL-16.0.0-4.17.1.noarch 3. Checking openSSL version : nijam@2ndquadrant.in:~ # openssl …
Respected Sir/madam, This is Nijamutheen , I have 6+ years of experience in PostgreSQL database administrator as well as PostgreSQL Architect , Linux admin , web hosting – apache server , Oracle ,mySQL, Mriadb, MSSQL & Server security as well …
I have a table name is nijam, that table contains 63017 records and have csv excel data contains 586128 records so want to append the data in nijam table for this task you have to following below steps Sample DATA …
Apart from being the number one Open-Source Enterprise level RDBMS, it is the biggest alternative to the top commercial database management software’s, without any licensing costs and vendor lock-ins. Migrating to the world’s best open source database helps your business …