Hello,
I could not decide which forum is more appropriate. I end up posting my
question here.
For a small but important Project, I need to develop a GUI application on
Raspberry Pi with PostgreSQL using Lazarus. PostgreSQL 9.4.10 server will be
running on Raspberry Pi 3 Model B and another PostgreSQL 9.6.2 will be
running on a Windows OS. Lazarus installed on Raspberry Pi is version 1.7
(built from latest subversion trunk sources) using with FreePascal 3.1.1
(also built from latest subversion trunk sources).
Raspberry Pi application will save some data in PostgreSQL running on Pi and
very same application also needs to save some *other* data on PostgreSQL
9.6.2 running on Windows OS. Both OSes will be running in same LAN.
Saving everything on Raspberry Pi and later copying using another
application/method is not allowed by design.
I could not find 9.6.x version of the PostgreSQL to install on Raspberry Pi
in packages. Most recent I can install using APT package system is 9.4.10. I
do not mind that it is rather old.
My problem starts when I try to reach a PostgreSQL 9.6.2 using 9.4.10 pglib
library (I think).
- Connection may hang and application stops responding.
- If connection succeeds a simple select * from query hangs and application
stops responding and after a while terminates for good.
I installed PgAdmin3 on Raspberry Pi to make some tests. I get lots of
warnings and some error messages when I try to connect that database on
Windows OS.
I am new to PostgreSQL and am not sure if there may be some connection
problems from old version libraries to new version PostgreSQL servers. My
limited little experience says I need same version on both systems for best
stability.
I would like to know;
1- Is it possible to install 9.6.2 with same version pglib on Raspberry Pi?
If possible to do on Raspberry Pi, I think I can build my own version from
sources assuming I am provided a good detailed how to document for doing so.
2- If above is not possible, is it possible to build just the latest version
pglib and overcome my connection problem?
3- If I need to select number 2 solution above, is that latest version
library will talk to old version without any problems?
4- I am always open to other suggestions.
Thanks.
Regards,
Ertan Küçükoğlu
