Re: [HACKERS] Can PQstatus() be used by Application to check connection to postgres periodically?
2012/2/8 Pavel Golub : > Hello, sujayr06. > > You wrote: > > s> Hello All, > > s> My application has to do a real time data upload to PostgreSQL > s> server. > > s> Every time i have to do a real time upload, i do not wish to > open > s> new connection. > s> I want to open a connection once [when my application comes up] > s> and periodically check if the connection is active. > s> Can PQstatus() be used by application to check the status of the > s> connection already established? > > s> If PQstatus() cannot be used, does PostgreSQL provide alternate > s> interface to check the status of the connection. > > s> Note : I do not wish to open connection on every real time upload > s> as its an overhead for the application. > > s> Appreciate any help! > > You may use PQtransactionStatus for this purpose > (http://www.postgresql.org/docs/9.1/static/libpq-status.html) Only if you don't care about getting the right answer. Neither PQstatus() nor PQtransactionStatus() make any attempt to determine whether the server is still there; they just return the cached status of the connection, without any system calls whatsoever. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Can PQstatus() be used by Application to check connection to postgres periodically?
Hello, sujayr06. You wrote: s> Hello All, s>My application has to do a real time data upload to PostgreSQL s> server. s>Every time i have to do a real time upload, i do not wish to open s> new connection. s>I want to open a connection once [when my application comes up] s> and periodically check if the connection is active. s>Can PQstatus() be used by application to check the status of the s> connection already established? s>If PQstatus() cannot be used, does PostgreSQL provide alternate s> interface to check the status of the connection. s> Note : I do not wish to open connection on every real time upload s> as its an overhead for the application. s>Appreciate any help! You may use PQtransactionStatus for this purpose (http://www.postgresql.org/docs/9.1/static/libpq-status.html) s> WBR, s> Sujay s> s> s> -- s> View this message in context: s> http://postgresql.1045698.n5.nabble.com/Can-PQstatus-be-used-by-Application-to-check-connection-to-postgres-periodically-tp5462315p5462315.html s> Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- With best wishes, Pavel mailto:pa...@gf.microolap.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Can PQstatus() be used by Application to check connection to postgres periodically?
Hello All, My application has to do a real time data upload to PostgreSQL server. Every time i have to do a real time upload, i do not wish to open new connection. I want to open a connection once [when my application comes up] and periodically check if the connection is active. Can PQstatus() be used by application to check the status of the connection already established? If PQstatus() cannot be used, does PostgreSQL provide alternate interface to check the status of the connection. Note : I do not wish to open connection on every real time upload as its an overhead for the application. Appreciate any help! WBR, Sujay -- View this message in context: http://postgresql.1045698.n5.nabble.com/Can-PQstatus-be-used-by-Application-to-check-connection-to-postgres-periodically-tp5462315p5462315.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers