Thread: PostgreSQL Win32 Port / psqlODBC driver
Hi,
I'm actually very interested in the win32 port you are working on.
We today use PostgreSQL on Cygwin/Windows 2000 for our website in production state (over 600000 hits per month) and it works great !
Nevertheless, we encounter several times a day a bug wich seems to be due to psqlodbc (unattended disconnections occur between our webserver and the database) ...
Just 2 questions :
=> Can you advice us where to found clues or support on this problem ? We have on our own already looked for answers on the web. We have found many people facing the same problem but no answers ...
=> In your global win32 project, do you have any plan to release a new version of the psqlODBC driver ?
Thanks in advance for your precious help on this point and globally for all the work you are doing on Postgres !
Stephane Decleire
FYI :
When the bug occures, we get the following message on the PostgreSQL logfile :
2004-03-30 15:19:04 LOG: pq_recvbuf: recv() failed: Connection reset by peer
and simultaneously we get the folowwing message on our scripts on the webserver :
Category = Microsoft OLE DB Provider for ODBC Drivers
Description = Could not connect to the server;Could not connect to remote socket.
Description = Could not connect to the server;Could not connect to remote socket.
Hi, I don't know enough about the ODBC driver to really say something about it. But one question is - does it happen only against Cygwin installations, or also against installatinos with postgresql on a Unix system? If it's the first, then the blame would be on the cygwin port.... Second, the psqlODBC driver is *not* included in the win32 port project. I don't know if there will be a new version of the odbc driver at around the same time - it's quite possible. See the ODBC driver project page at http://gborg.postgresql.org/project/psqlodbc/projdisplay.php //Magnus -----Original Message----- From: Webmaster Bebe Nounou [mailto:webmaster@bebe-nounou.com] Sent: Thursday, April 01, 2004 5:13 PM To: pgsql-hackers-win32@postgresql.org Subject: [pgsql-hackers-win32] PostgreSQL Win32 Port / psqlODBC driver Hi, I'm actually very interested in the win32 port you are working on. We today use PostgreSQL on Cygwin/Windows 2000 for our website in production state (over 600000 hits per month) and it works great ! Nevertheless, we encounter several times a day a bug wich seems to be due to psqlodbc (unattended disconnections occur between our webserver and the database) ... Just 2 questions : => Can you advice us where to found clues or support on this problem ? We have on our own already looked for answers on the web. We have found many people facing the same problem but no answers ... => In your global win32 project, do you have any plan to release a new version of the psqlODBC driver ? Thanks in advance for your precious help on this point and globally for all the work you are doing on Postgres ! Stephane Decleire http://www.bebe-nounou.com FYI : When the bug occures, we get the following message on the PostgreSQL logfile : 2004-03-30 15:19:04 LOG: pq_recvbuf: recv() failed: Connection reset by peer and simultaneously we get the folowwing message on our scripts on the webserver : Category = Microsoft OLE DB Provider for ODBC Drivers Description = Could not connect to the server;Could not connect to remote socket.
Hi, Thanks for the answer. We don't have any Unix platform to test the link without Cygwin ... But we have never encountered any similar problem using Cygwin with the psql client. It's the reason why I have disregarded the cygwin layer in our problem. Am I wrong ? Do you have any specific reason to think the cygwin port could be responsible for our bug ? Concerning the psqlODBC driver, i haven't seen any new release scheduled. It's a bit touchy for me to give my point of view since I don't contribute in your project but here it is : => The most used "API" to connect a database in the win32 world is ODBC. => The great job done by the team working on the win32 port project should lead to a rush on Postgres from Win32 users. For those reasons, both the port of Postgres and the evolutions of the psqlODBC driver shouldn't they be managed by the same person or team ? If you need any reference of postgres database in production for Europe, I would be really happy to help you in that way ... Best regards Stephane Decleire http://www.bebe-nounou.com -----Message d'origine----- De : Magnus Hagander [mailto:mha@sollentuna.net] Envoyé : Friday, April 02, 2004 9:52 AM À : webmaster@bebe-nounou.com; pgsql-hackers-win32@postgresql.org Objet : RE: [pgsql-hackers-win32] PostgreSQL Win32 Port / psqlODBC driver Hi, I don't know enough about the ODBC driver to really say something about it. But one question is - does it happen only against Cygwin installations, or also against installatinos with postgresql on a Unix system? If it's the first, then the blame would be on the cygwin port.... Second, the psqlODBC driver is *not* included in the win32 port project. I don't know if there will be a new version of the odbc driver at around the same time - it's quite possible. See the ODBC driver project page at http://gborg.postgresql.org/project/psqlodbc/projdisplay.php //Magnus -----Original Message----- From: Webmaster Bebe Nounou [mailto:webmaster@bebe-nounou.com] Sent: Thursday, April 01, 2004 5:13 PM To: pgsql-hackers-win32@postgresql.org Subject: [pgsql-hackers-win32] PostgreSQL Win32 Port / psqlODBC driver Hi, I'm actually very interested in the win32 port you are working on. We today use PostgreSQL on Cygwin/Windows 2000 for our website in production state (over 600000 hits per month) and it works great ! Nevertheless, we encounter several times a day a bug wich seems to be due to psqlodbc (unattended disconnections occur between our webserver and the database) ... Just 2 questions : => Can you advice us where to found clues or support on this problem ? We have on our own already looked for answers on the web. We have found many people facing the same problem but no answers ... => In your global win32 project, do you have any plan to release a new version of the psqlODBC driver ? Thanks in advance for your precious help on this point and globally for all the work you are doing on Postgres ! Stephane Decleire http://www.bebe-nounou.com FYI : When the bug occures, we get the following message on the PostgreSQL logfile : 2004-03-30 15:19:04 LOG: pq_recvbuf: recv() failed: Connection reset by peer and simultaneously we get the folowwing message on our scripts on the webserver : Category = Microsoft OLE DB Provider for ODBC Drivers Description = Could not connect to the server;Could not connect to remote socket. --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004