Query regarding new version of shared library with older binary

Hi All, I have following query: Our application is compiled with postgres SQL Client C++(11.18) and it is dynamically linked with postgres shared library(version libpq.so.5.11). But where this application runs at customer production system new version of libpq(libpq.so.5.13) available. This

RE: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy

Hi Matthias, Currently many customers are using this. We want to use libpq library APIs only. Is there any support of keepalive at client side? Regards Tarkeshwar -Original Message- From: Matthias Apitz Sent: Tuesday, March 5, 2024 4:59 PM To: M Tarkeshwar Rao Cc: pgsql-gene

Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy

Hi all, " We are using libpq c client (Version : 14.10) of postgresql in our application to connect with postgresql database server (Version 14.10). For making connection we are using libpq's API "PQsetdbLogin()". Problem Statement : If our connection remains idle for more than 15 minutes,

Recall: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy

M Tarkeshwar Rao would like to recall the message, "Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy".

Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy

Hi Tarkesh, " We are using libpq c client (Version : 14.10) of postgresql in our application to connect with postgresql database server (Version 14.10). For making connection we are using libpq's API "PQsetdbLogin()". Problem Statement : If our connection remains idle for more than 15 minutes,

Issue in Postgres Client 14.9 with OpenSSL 3.2.0

Hi, We are facing issue while trying to connect securely(ssl) from postgres c client(libpq) with postgresql server. We have compiled postgreClient 14.9(postgresql-14.9.tar.gz) using OpenSSL version 3.2.0. Backtrace of the issue is mentioned below : #0 0x009a71f8 in

PostgreSQL C++ Interface version 14.9 using static library instead of shared library

Hi While compiling PostgreSQL C++ Interface version 14.9 . Found that libpq.so is getting created with libssl.a and libcrypto.a instead of shared library libssl.so and libcrypto.so. It is created like below: user@seli[postgres/14.9/lib]$ ldd libpq.so

Multiple core dump errors are thrown by initdb when Huge pages are enabled in OS and huge_pages is set to “off” in postgresql.conf.sample in Kubernetes.

Hi, We are facing following issue with postgres db with Kubernetes. Is huge pages not supported in Kubernetes environment? Multiple core dump errors are thrown by initdb when Huge pages are enabled in OS and huge_pages is set to “off” in postgresql.conf.sample in Kubernetes. In this case, the

Migrating postgres client(libpq) library from 12.10 to 14(Need some information)

Hi All, We are migrating our product from postgres client library libpq 12.10 to libpq 14. This is major upgrade in the client library for us. I am quite new in this migration activity. Can you please guide me or share standard steps for this migration. Which area I should see in detail so

Could not read certificate file from while upgrading to PostgreSQLClient 12.9

Hi all, We are upgrading our postgres client in C++ application. Also we upgraded the Postgres server. Our C++ application making secure connection(TLS) to Postgres DB. When we are trying to connect PostgreSQLClient 12.9 to Postgre SQL Server 12.9. in SSL Mode. We are getting below error could

is there any memory leak with postgres version(12.x) - https://stackoverflow.com/questions/3849543/force-postgresql-to-release-allocated-memory

Hi All, Is there any memory leak in Postgres version 12.7 or any other 12.x? It is mentioned in https://stackoverflow.com/questions/3849543/force-postgresql-to-release-allocated-memory. Regards Tarkeshwar

RE: memory consumption of memory for postgres db container

Can you please suggest few commands? Regards Tarkeshwar From: Ninad Shah Sent: Thursday, September 2, 2021 8:30 PM To: M Tarkeshwar Rao Cc: pgsql-gene...@postgresql.org Subject: Re: memory consumption of memory for postgres db container No need to worry. This isn't really a concern

memory consumption of memory for postgres db container

Hi all, We did a stability test for our product, where we continuously inserting data into postgres tables. We did this for three days continuously. Memory utilization of our Postgres container continuously increasing. [cid:image001.jpg@01D7A035.D9017060] Can you please provide us the clue why

“tlsv1 alert unknown ca” with PQconnectdb

Hi all, I made following changes in my Postgres server which means I am enabling one way authentication: (Disabled Mutual authentication. Only client will authenticate server.) hostssl all myuser 0.0.0.0/0 md5 clientcert=0 I am trying psql with following

How postgres is refreshing TLS certificates

Hi all, We are working on a activity in which I need to refresh the TLS certificate without restarting the my application pod. This feature is already there in Postgres. Can anyone please suggest us how postgres is implemented the same? Regards Tarkeshwar

RE: 3867653, EMM1 cluster issue on 23rd May--core generated --design feedback

Hi All, We are getting following core with following use case: Case: We made max_connections as 15 and 10 different processes opening 15 connections with server. It is running fine. But after few hours it giving following core. When we increase the max_connections then core come

RE: Autovacuum not functioning for large tables but it is working for few other small tables.

please suggest any workaround so that we can resolve the issue or any other way by which we can avoid this situation? Regards Tarkeshwar -Original Message- From: Tomas Vondra Sent: Thursday, December 17, 2020 7:16 AM To: M Tarkeshwar Rao ; pgsql-performa...@postgresql.org Cc: Neeraj Gupta

Autovacuum not functioning for large tables but it is working for few other small tables.

Hi all, We have facing some discrepancy in Postgresql database related to the autovacuum functionality. By default autovacuum was enable on Postgres which is used to remove the dead tuples from the database. We have observed autovaccum cleaning dead rows from table_A but same was not

undefined reference to `pg_snprintf when we upgraded libpq version from 10.3 to 12.3

Hi all, We upgraded the libpq version from 10.3 to 12.3. Now we are getting following linker error in compilation. linux64/lib/libPostgreSQLClient.so: undefined reference to `pg_snprintf(char*, unsigned long, char const*, ...)' When we analyzed it we found following diff in libpq. What could

RE: Getting error on

Thanks for reply. Can you please suggest why this error occur? Any resource crunch on postgres server? Regards Tarkeshwar From: Ron Sent: Monday, June 15, 2020 7:17 PM To: pgsql-general@lists.postgresql.org Subject: Re: Getting error on On 6/15/20 8:43 AM, M Tarkeshwar Rao wrote: Hi all, I

Getting error on

Hi all, I have the c++ postgres client. When I restarted my client process I am getting following error on insertion. Can you please suggest why this error is coming and how to resolve it? 2020-04-17 06:30:04.498 PRINT_DEFAULT_ERROR: Processor-DefaultCollectorGroup-0 :DRViewerPoint.cc :notify

After restart of our C++(postgres client) which is running in the kubernetes pod, connection is getting hanged.

Hi all, We are new to Kubernetes. Our application is in C++ and it is connecting to postgres server. We are facing problems during sending traffic to postgres server. Initially it is running fine. When we restarting the container it hanged. We took tcpdump. After analyzing the dump we found

Postgres cursor taking 2 hrs to update the table

Hi, I have the 10 application processes(each process having 12 threads and each of have updating 8 million rows in the shared memory) which are reading the data from single postgres database. We are using database cursors in C++ to fetch the data and updating the shared memory. There is the

We have to close the cursor or rollback the transaction in case of failure?

Hi all, I am using cursors to fetch the data from table using C++. Initially were errors as highlighted as "current transaction isaborted" in /var/logs during full vacuum. We are little bit confused in failure handling. In case of any failure of following function. PQexec(connection,

RE: Getting following error in using cursor to fetch the records from a large table in c language(current transaction is aborted, commands ignored until end of transaction block)

, November 1, 2019 10:38 PM To: M Tarkeshwar Rao Cc: pgsql-gene...@postgresql.org Subject: Re: Getting following error in using cursor to fetch the records from a large table in c language(current transaction is aborted, commands ignored until end of transaction block) On Fri, Nov 1, 2019 at 1:44 PM

Getting following error in using cursor to fetch the records from a large table in c language(current transaction is aborted, commands ignored until end of transaction block)

Hi all, Getting following error in using cursor to fetch the records from a large table in c language. Can you please suggest why it is coming and what is the remedy for this. Error Details - Nov 1 13:21:54 sprintstd2 postgres[18604]: [10-1] < 2019-11-01 13:21:54.212 CET

RE: Getting following error in using cursor to fetch the records from a large table in c language

Hi, If VACUUM full is going on and any conflicting query come then what will happen to that query. Regards Tarkeshwar -Original Message- From: M Tarkeshwar Rao Sent: Thursday, October 31, 2019 12:45 PM To: Laurenz Albe ; 'pgsql-gene...@postgresql.org' Subject: RE: Getting following

RE: Getting following error in using cursor to fetch the records from a large table in c language

When we running with vacuum full we are getting following error message. Error: --- user was holding a relation lock for too long Any idea about this error. -Original Message- From: Laurenz Albe Sent: Thursday, October 31, 2019 12:28 PM To: M Tarkeshwar Rao ; 'pgsql-gene

Can you please suggest how to configure hot_standby_feedback?

Hi all, Can you please suggest how to configure hot_standby_feedback? Regards Tarkeshwar

RE: Getting following error in using cursor to fetch the records from a large table in c language

To: M Tarkeshwar Rao ; 'pgsql-gene...@postgresql.org' Subject: Re: Getting following error in using cursor to fetch the records from a large table in c language On Wed, 2019-10-30 at 16:59 +, M Tarkeshwar Rao wrote: > Getting following error in using cursor to fetch the records from a la

Getting following error in using cursor to fetch the records from a large table in c language

Hi all, Getting following error in using cursor to fetch the records from a large table in c language. Can you please suggest why it is coming and what is the remedy for this. Error Details - Failed to execute the sql command close:

RE: Can you please tell us how set this prefetch attribute in following lines.

-Original Message- From: Reid Thompson Sent: Thursday, October 17, 2019 9:49 PM To: pgsql-general@lists.postgresql.org Cc: Reid Thompson Subject: Re: Can you please tell us how set this prefetch attribute in following lines. On Thu, 2019-10-17 at 11:16 +, M Tarkeshwar Rao wrote

Can you please tell us how set this prefetch attribute in following lines.

Hi all, How to fetch certain number of tuples from a postgres table. Same I am doing in oracle using following lines by setting prefetch attribute. For oracle // Prepare query if( OCIStmtPrepare( myOciStatement, myOciError, (text *)aSqlStatement, // Get statement type OCIAttrGet(

Can you please tell us how set this prefetch attribute in following lines.

Hi all, How to fetch certain number of tuples from a postgres table. Same I am doing in oracle using following lines by setting prefetch attribute. For oracle // Prepare query if( OCIStmtPrepare( myOciStatement, myOciError, (text *)aSqlStatement, // Get statement type OCIAttrGet(

Is there any configuration in postgresql.conf or any other configuration of postgres which will make this possible to listen on particular interface

Hi all, postmaste 2917 postgres3u IPv452341 0t0 TCP *:5432 (LISTEN) postmaste 2917 postgres4u IPv652342 0t0 TCP *:5432 (LISTEN) Above processes are bind on all the interfaces of a machine. Is there any configuration in postgresql.conf or any other

RE: integrate Postgres Users Authentication with our own LDAP Server

use case. Can you please help us or have you any steps by which we can configure any postgres with LDAP? -Original Message- From: Laurenz Albe Sent: Thursday, May 9, 2019 12:12 PM To: M Tarkeshwar Rao ; pgsql-general ; 'postgres-disc...@mailman.lmera.ericsson.se' ; 'pgsql-gene

integrate Postgres Users Authentication with our own LDAP Server

Hi all, We would need to integrate Postgres Users Authentication with our own LDAP Server. Basically as of now we are able to login to Postgress DB with a user/password credential. [cid:image001.png@01D50650.D807AE30] These user objects are the part of Postgres DB server. Now we want that

Facing issue in using special characters

Hi all, Facing issue in using special characters. We are trying to insert records to a remote Postgres Server and our application not able to perform this because of errors. It seems that issue is because of the special characters that has been used in one of the field of a row. Regards