Can PQstatus() be used by Application to check connection to postgres periodically?

Поиск
Список
Период
Сортировка
От sujayr06
Тема Can PQstatus() be used by Application to check connection to postgres periodically?
Дата
Msg-id 1328595410014-5462315.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Can PQstatus() be used by Application to check connection to postgres periodically?  (Pavel Golub <pavel@microolap.com>)
Список pgsql-hackers
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
ofthe
 
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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: double writes using "double-write buffer" approach [WIP]
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Speed dblink using alternate libpq tuple storage