[AOLSERVER] nspostgres-4.1 released
A new version of the nspostgres module is now available for download at SourceForge, nspostgres-4.1. In this version, Jim Lynch made some improvements to the build process, and cleaned up the error reporting code. Download: http://sourceforge.net/project/showfiles.php?group_id=3152&package_id=41577&release_id=518919 README and ChangeLog: http://sourceforge.net/project/shownotes.php?release_id=518919&group_id=3152 Bug Tracker: http://sourceforge.net/tracker/?group_id=3152&atid=103152 -- Dossy -- Dossy Shiobara | [EMAIL PROTECTED] | http://dossy.org/ Panoptic Computer Network | http://panoptic.com/ "He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on." (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] nspostgres-4.1 released
Hi! Thanks for your work! We are using that module with OpenACS several years. It always has worked Ok. The only problem is that it do not reconnect if we shutdown the Postgres DB. Any pointer to solucionate this? Best regards, Agustin Dossy Shiobara escribió: A new version of the nspostgres module is now available for download at SourceForge, nspostgres-4.1. In this version, Jim Lynch made some improvements to the build process, and cleaned up the error reporting code. Download: http://sourceforge.net/project/showfiles.php?group_id=3152&package_id=41577&release_id=518919 README and ChangeLog: http://sourceforge.net/project/shownotes.php?release_id=518919&group_id=3152 Bug Tracker: http://sourceforge.net/tracker/?group_id=3152&atid=103152 -- Dossy -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] nspostgres-4.1 released
Hi, You say you want to reconnect the driver to a postgres that has been shut down,,, at this moment, I'm not quite understanding: you can't connect to a server which is not running. But, if you mean that you start the server after that and expect aolserver to be watching for this, it would require aolserver to be polling for the connection periodically. I don't believe it would be useful to require aolserver to have to watch for dropped connections to aolserver; that takes an extra process or thread and CPU time that should be used for what aolserver's job is. For all intents and purposes, openacs requires postgres to be up. If you'd like to shut postgres down, it only makes perfect sense that you should also shut the openacs instances using it. Having said all this, would it be possible to add a feature to aolserver where an admin sends a signal to aolserver which responds by trying to open database connections? -Jim -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] nspostgres-4.1 released
On 27 Jun 2007, at 11:54, Jim Lynch wrote: I don't believe it would be useful to require aolserver to have to watch for dropped connections to aolserver; that takes an extra process or thread and CPU time that should be used for what aolserver's job is. The postgres driver could easily do a quick check before every query using PQstatus(), followed by a PQreset() if the result was CONNECTION_BAD. Or only do it when the connection is gotten from the pool. Though I do not know 1) how reliable PQstatus is and 2) how efficient it is. I agree efficiency is the number one priority. I find AOLserver (non-ACS anyway) tends to recover very well from a Postgres restart. Maybe one error page per connection it had open, but that connection seems to then be discarded and a new one created on the next request. In any case, I think it would be best if this were implemented per- driver rather than an AOLserver wide implementation as then it can be done in the most efficient way for the database in question. Having said all this, would it be possible to add a feature to aolserver where an admin sends a signal to aolserver which responds by trying to open database connections? Or just close all existing ones, so new ones are re-opened when required. Cheers, Bas. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] nspostgres-4.1 released
You say you want to reconnect the driver to a postgres that has been shut down,,, at this moment, I'm not quite understanding: you can't connect to a server which is not running. Ok. I want to say shutdown / start. Sorry. But, if you mean that you start the server after that and expect aolserver to be watching for this, it would require aolserver to be polling for the connection periodically. I don't believe it would be useful to require aolserver to have to watch for dropped connections to aolserver; that takes an extra process or thread and CPU time that should be used for what aolserver's job is. For us it will be useful. Restart our OpenACS instances waste aprox. 3-4 minutes. Moreover, we are working with 4 aolservers in cluster. We have to restart all the aolserver instances. For all intents and purposes, openacs requires postgres to be up. If you'd like to shut postgres down, it only makes perfect sense that you should also shut the openacs instances using it. Having said all this, would it be possible to add a feature to aolserver where an admin sends a signal to aolserver which responds by trying to open database connections? This will be a good point. Regards, Agustin -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] nspostgres-4.1 released
On 2007.06.27, Agustin Lopez <[EMAIL PROTECTED]> wrote: > For us it will be useful. Restart our OpenACS instances waste aprox. > 3-4 minutes. Moreover, we are working > with 4 aolservers in cluster. We have to restart all the aolserver > instances. Have you tried "ns_db bouncepool poolname"? When you bounce your Postgres DB, perhaps you could set up a simple .adp page that does a ns_db bouncepool on all the relevant pool names associated with that DB instance? -- Dossy -- Dossy Shiobara | [EMAIL PROTECTED] | http://dossy.org/ Panoptic Computer Network | http://panoptic.com/ "He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on." (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] nspostgres-4.1 released
On Tuesday 26 June 2007, Dossy Shiobara wrote: > A new version of the nspostgres module is now available for download at > SourceForge, nspostgres-4.1. > > In this version, Jim Lynch made some improvements to the build process, > and cleaned up the error reporting code. And looks to have done a fine job. Thanks, Jim! -- Lamar Owen Chief Information Officer Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] nspostgres-4.1 released
Lamar, Thanks for testing, thanks for the success report and the shout out :) Everyone, Hi, the more people testing this the better :) if there are changes you don't understand enough to use, please post here and I'll respond by editing the README (so please read that beforehand; thanks)... I'm especially interested in hearing success/fail reports on varied machines. The main thing, is that if you use the PG_CONFIG approach, it's supposed to take care of everything necessary to link up to the postgres you specify by locating the particular pg_config executable associated with that installation of postgres. On Wed, 5 Sep 2007 14:26:59 -0400 Lamar Owen <[EMAIL PROTECTED]> wrote: > On Tuesday 26 June 2007, Dossy Shiobara wrote: > > A new version of the nspostgres module is now available for download at > > SourceForge, nspostgres-4.1. > > > > In this version, Jim Lynch made some improvements to the build process, > > and cleaned up the error reporting code. > > And looks to have done a fine job. Thanks, Jim! Thanks; glad to do it... it should mean more people can run it with fewer problems. > Lamar Owen > Chief Information Officer > Pisgah Astronomical Research Institute -Jim -- Jam sessions community web site: http://jam.sessionsnet.org -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] nspostgres-4.1 released
On Wednesday 05 September 2007, Jim Lynch wrote: > Lamar, > > Thanks for testing, thanks for the success report and the shout out :) Sure. I'm glad somebody decided to pick it up; I've not run OpenACS is some time now, and really didn't have the need or time to further maintain the PostgreSQL driver. -- Lamar Owen Chief Information Officer Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.