Re: Latest PostgreSQL on Raspbian Jessie

On 02/23/2017 01:56 AM, Ertan Küçükoğlu wrote:
> 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).

Can you show what is you are doing?

If not what happens if you use the Postgres command line client(psql) to
connect to the 9.6.2 database?

> - 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.

What are the warnings/errors?

>
> 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?

Yes:

aklaver(at)arkansas:~$ psql -d postgres -U aklaver -p 5434
Password for user aklaver:
psql (9.6.2, server 9.4.11)
Type "help" for help.

postgres=> select 'test';
?column?
----------
test
(1 row)

> 4- I am always open to other suggestions.
>
> Thanks.
>
> Regards,
> Ertan Küçükoğlu
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com