Working with PostgreSQL in LAN

Strog · Post by **Strog** » 05.02.2007, 01:19

Hi everybody! I'm new to this forum and to PostgreSQL/ZEOS combination so I would like to know what do I need on client computer to connect to the serever.

Do I need to install PostgreSQL server on clients as well or I need to do something else ( are there any dll-s that I can just copy to client computers in Win\sys32 dir so they can connect to the server without installing the server )? I tried with installing the server and my program worked just fine, and without server I had some problems so I'm curious about that.

Thanks in advance for your answers!

Best regards, Bojan Kopanja.

btrewern · Post by **btrewern** » 05.02.2007, 10:12

If you use the PostgreSQL-7 protocol in Zeos then you just need the libpq74.dll from the lib folder in the Zeos distribution. If you use the PostgreSQL-8 protocol you will need the following files:

libpq.dll (or libpq81.dll from zeos lib folder)
comerr32.dll
iconv.dll
krb5_32.dll
libeay32.dll
libiconv-2.dll
libintl-2.dll
ssleay32.dll

these can all be found in the bin folder of your PostgreSQL server installation.

Regards,

Ben

Strog · Post by **Strog** » 05.02.2007, 11:30

Thanks a lot! I just came with the same list of dll-s by my self and I wanted to wrote it here but I see that you already did it

.

I just took my program and put it on client without PostgreSQL and I run it then. It gave me a message like "Missign *.dll" every time it started so I justo put those dll-s in the directory with the program and when I put all the dll-s from the list you gave me ( all the dll-s the program was requesting ) it worked with no problems

.

I just neaded to add an IP address of my client computer in pg_hba.conf file on server and that was it. Now everything works OK!

Thanks a lot one more time!

btrewern · Post by **btrewern** » 05.02.2007, 16:16

Could this be added to a README or INSTALL file somewhere?

Regards,

Ben

Strog · Post by **Strog** » 05.02.2007, 16:48

Yes, that would be great because I know that one friend of mine gave up on PostgreSQL because he couldn't connect to it's server through LAN and that's real pity, and I'm sure that he's not the only one. I hope that he'll reconsider his decision now that I can help him, but to prevent that in future it definitely should be noted in some kind of README file...

Best regards,

Bojan Kopanja

okparanoid · Post by **okparanoid** » 13.03.2007, 12:19

Hello,

I have all this dll in my program's folder, however when i try to execute the program in other clients i have a "Requested database driver was not found" message.

Please someone can help me ?

okparanoid · Post by **okparanoid** » 13.03.2007, 14:14

Problem is solved. Thanks.

Don't have add the .pas files of the zeos project to the library path of Delphi when installing ZeosLib.

Perhaps this could be add to a install.txt file too.

varathasiva · Post by **varathasiva** » 28.05.2007, 15:06

Dear Friends,

Here iam trying to configure postgres on windows xp, My windows xp having static ip, i want to access the postgres from outside of my office without using any router portforwading, how to configure like this, i already tried all the ways, now iam tied, anybody having any idea, either my all linux server is working on over the direct static ip, only getting problem in windows xp.

Regards
Siva

Post by **mdaems** » 28.05.2007, 20:02

Maybe it's the build in firewall feature (??) of XP which is blocking connections from outside?

Mark

ste_ba · Post by **ste_ba** » 16.12.2007, 13:16

Hi,

I have trouble with those DLLs, too (comerr32.dll and such). Sometimes in works to put them into the install directory of my client application, sometimes they need to be in the client's c:\Windows\System32, don't know why. Therefore, I would appreciate it if I could return to protocol postgresql-7 to get rid of all this DLL mess. Is this possible when working with postgresql 8.2, or will it get me into more trouble?

Thanks,
ste_ba

jma_sp · Post by **jma_sp** » 18.11.2008, 18:29

Hello everybody, i am using Lazarus 0.9.26. and i was trying to connect with postgreSQL 8.3.4-1 in LAN with ZeosLib 6.6.4-stable.
I am a beginer in BBDD, ¿there is practical examples or tutorial to learn more using zeoslib?
I used the zeoslib graphical components but i was unable to connect. Connection in LAN among pgAdmin III was successful, then i tryed with localhost and zeoslib i wasnt able to connect too.
The info in Lazarus wiki dont help me enough.

Post by **mdaems** » 18.11.2008, 20:41

Try the Knowledge Base on this forum. In the general section there are some good starter documents. Written for IB/Firebird, but that should not make too much difference.

If you can describe you problems more in detail we can help you here. eg. What connection parameters did you set in pgAdmin to connect? What TZConnection properties did you set then. What was the error when calling ZConnection1.Open?

Mark

Khaoz · Post by **Khaoz** » 23.04.2009, 19:37

Hey guys.

I'm trying to deploy my application. I'm using a installer which i create with innosetup and every dll listed here is placed in c:\windows\system32 but my app does no work asking for libpq81.dll or libpq.dll (i'm using libpq.dll).
I have tried to put in windows\system and in my app dir with the executable wihtout success.

It's a windows xp with sp2.

trupka · Post by **trupka** » 23.04.2009, 20:58

Khaoz,
What postgresql version, precisely, are you using?

Khaoz · Post by **Khaoz** » 24.04.2009, 01:19

8.3.6

i will install sp3 because my wife use windows xp with sp3 and everything works fins.