04-29-2003 08:18 AM
04-29-2003 10:36 PM
04-30-2003 09:45 AM
10-28-2009 12:40 PM
Hi,
Im having problem to conect in postgre server .. Someone can help me pls ?
This is the error msg ...
"The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? "
Thx 😃
10-28-2009 01:15 PM
Jim Kring wrote:
Mike,
---x-snip-x---
MySQL is licensed under the GPL, but for about $400 you can buy a comercial license.
---x-snip-x---
I don't think you need a commercial license to use MySQL commercially. Just if you want some support.
I like MySQL, but have never used it with LabVIEW. MySQL does have some decent administration tools available for it. MySQL is also very developer friendly. I think you can get the whole thing running on a USB stick. I remember when I did WAMP (Windows+Apache+MySQL+PHP) development, I had the whole package installed on a USB flash drive and could run it on my work computer or on my home computer. I thought that was fantastic.
10-28-2009 02:02 PM
U need a license of MySQL if u use it in a enterprise for example ...
PostGreSQL i dont think that is needed .. u can just use it when and where u want ...
10-28-2009 02:03 PM
10-28-2009 02:13 PM
07-16-2012 05:52 AM
I have trouble with my Labview Project working at 24/7 mode with PostGRE. The problem consists that my LV project's memory usage increases when my program have insert every new record in PostGRE's table.
Now I've no any possibilities to change this situation, because first of all LabVIEW is not intended for 24/7 mode. PostGRE is working very well and intended for 24/7 mode.
Is anybody help me to solve this growth allocating memory problem with every new record in PostGRE's table ???
Please dear colleagues
03-13-2018 06:06 PM
Hi Mike,
Your OP was 15 years ago! I thought this might still be relevant here, rather than starting a new thread.
I've recently updated my PostgreSQL and MySQL installations, and ran a quick performance comparison with the example code attached below.
The PostgreSQL did inserts at a rate of 1000 tuples in 1400 seconds (terrible) and MySQL at a rate of 1000 per 29 seconds. Something is clearly wrong with the first setup, but I would have expected better performance than 30-40 records per second with MySQL server running on localhost (Xeon processor).
ODBC driver details: PSQLODBC30A.DLL and MYODBC5A.DLL, downloaded in Feb 2018 from PostgreSQL Global Development Group and Oracle Corp., respectively.
Is there anything obviously wrong with the code? The connection configurations (see text in vi) are exactly the same except for driver name, port & login credentials. I hope to get better performance than this, and it would be nice to have the option to use postgreSQL, which is ruled out by the awful results above.
Cheers,
Ted