Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

PostGreSQL

teksaport's profile image teksaport posted 4 years ago in General Permalink

I need to access a postgre server and want to use heidi. I retrieved the latest version today (9.3.0.5049). I'm on a Windows 10 64bit machine. I downloaded the installer and it is installed in C:\Program Files\HeidiSQL. When I setup a session for it and click Open I get this error. "Cannot find a usable libpq.dll. Please launch heidisql.exe from the directory where you have installed it.". This is the first time I have installed HeidiSQL on this machine and accordingly it installed the 64bit version. So I am running heidi from the directory where it is installed from. But I also clicked on the heidisql.exe in the installation folder, but I have the same problem. I can confirm that the libpq.dll is in that folder dated 2014-04-15 174kb.

I see that in the Network type drop down it says "PostreSQL (experimental)", does this mean I cannot use HeidiSQL? Or what do I do to make it work?

Thanks John

ansgar's profile image ansgar posted 4 years ago Permalink

I just tried to reproduce your issue, with no luck.

Which installer did you exactly download? There are two different ones. Prefer the 32+64bit version if you took the 32bit-only one.

teksaport's profile image teksaport posted 4 years ago Permalink

This is the link to the installer I used. http://www.heidisql.com/installers/HeidiSQL_9.3.0.5049_Setup.exe

It says 32+64bit installer

Thanks John

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 4 years ago Permalink

Ok, that's the right one. However, did you previously install a 32bit version, or download some .dll into that folder in some way?

I would recommend

  • uninstall HeidiSQL
  • remove the folder c:\Program Files\HeidiSQL\ if that was left
  • install again
teksaport's profile image teksaport posted 4 years ago Permalink

I have never had HeidiSQL on this machine before. This is a brand new installed Window 10, and a brand new install of HeidiSQL. I have never had a 32bit version on here before. I have not downloaded any dll into that folder, but following your instructions and uninstalling and deleting the folder, I still get the same error.

I've done as suggested, I uninstalled, removed the folder (yes it was still there), installed again, created my session, clicked "Open", and the error came up "Cannot find a usable libpq.dll. Please launch heidisql.exe from the directory where you have installed it.".

Thanks John

ansgar's profile image ansgar posted 4 years ago Permalink

Hm, is that then a privilege issue perhaps? Or you have that libpq.dll somewhere else, in your path, because you installed the PostgreSQL server? Should not be a problem normally, but who knows. You can also try to install the 32bit version of HeidiSQL.

teksaport's profile image teksaport posted 4 years ago Permalink

I have opened HeidiSQL with "Run as Administrator" and got the same error.

I do not have the PostgreSQL server but I do have the pgAdmin III client. Please note that I installed pgAdmin III only AFTER HeidiSQL would not connect. So the issue with libpq.dll was before pgAdmin III was on the machine.

So next I closed HeidiSQL, I closed pgAdmin III. I renamed the pgAdmin libpq.dll to libpq.dll.orig. I then opened HeidiSQL (now HeidiSQL is the only program to have libpq.dll), and it failed again with the same error. I then did a search on my hard drive for any other libpq.dll, and the HeidiSQL folder is the only one on my computer.

Thanks John

ansgar's profile image ansgar posted 4 years ago Permalink

What about the portable release? That's a 32bit only version. Please try out.

teksaport's profile image teksaport posted 4 years ago Permalink

Should I remove the 64 bit one?

John

teksaport's profile image teksaport posted 4 years ago Permalink

I have left the 64bit installed, saved the portable to my desktop, ran the portable, created the postgre server info and clicked Open, it gave me the same error.

Thanks John

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
teksaport's profile image teksaport posted 4 years ago Permalink

For testing I uninstalled the 64bit version and verified that the Program Files folder was gone, I tried portable again, same error.

ansgar's profile image ansgar posted 4 years ago Permalink

Scratching my head currently...

teksaport's profile image teksaport posted 4 years ago Permalink

I am willing to do some testing if you need. Thanks

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.