PHP: How to know if a PostgreSQL persistent connection is already opened?

Question

According to PHP.net manual, pg_pconnect will create a persistent connection, or will return the existing one if it already exists with same connection string.

The problem I have is I want to know whether that call indeed creates a connection or actually returns the same, for example, for loading prepared statements in case it is the first connection.

Can it actually be possible?

UPDATE: With this question I am not referring to the current running PHP script. I want to know if the connection has been opened sometime (maybe by other scripts another time) or this script is the first in open that connection (for example, because I resetted the PostgreSQL server).

Mrigesh Raj Shrestha · Accepted Answer · 2012-06-12 06:46:08Z

1

Check the manual. Solution is given in its description itself. It returns the existing connection if you have enabled persistent connection, which is the enabled by default. I had no problem with it in my experience. Hope this helps out. php.net manual for pg_pconnect()

ANSWER UPDATED: i should add that normally postgres is very possesive towards its connections; it tries to retain the connections even if you reset the service; so it would be wise not use this event of "checking a pre-existing connection" as even if u found a mechanism to detect the new connection returned event, it will be countable by your fingers; very few very rare.

I think you should shift your logic.

edited Jun 12, 2012 at 6:46

answered Jun 12, 2012 at 5:57

Mrigesh Raj Shrestha

6204 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

StormByte Over a year ago

I should have clarified a bit my question, I am sorry for missunderstanding. I will update my question accordingly.

Mrigesh Raj Shrestha Over a year ago

i hope you had read this php.net/manual/en/features.persistent-connections.php

StormByte Over a year ago

Yes, I have read that. Thank you, this was just an idea, not implemented yet, but yes. It seems I need to load the prepared sentence anytime I open the connection (despite it may be already opened) and just ignore if it fails because it is already loaded?

Collectives™ on Stack Overflow

PHP: How to know if a PostgreSQL persistent connection is already opened?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related