Search Postgresql Archives

Re: Latest PostgreSQL on Raspbian Jessie

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Adrian Klaver
Sent: Thursday, February 23, 2017 3:55 PM
To: Ertan Küçükoğlu <ertan.kucukoglu@xxxxxxxxxxx>;
pgsql-general@xxxxxxxxxxxxxx
Subject: 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@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.klaver@xxxxxxxxxxx

Hi,

Sorry about not indenting. Have to use Outlook as e-mail app.

I cannot show any work at the moment, I am just researching right now,
before I start actual job. I have a single form making connection to local
PostgreSQL and remote one. Local seems to be OK in all respects. Remote is a
problem. 

Below you can see some psql output.

postgres@raspberrypi:~$ psql -d test -U postgres -p 5432 -h 192.168.1.105
Password for user postgres: 
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children: 
psql (9.4.10, server 9.6.1)
WARNING: psql major version 9.4, server major version 9.6.
         Some psql features might not work.
Type "help" for help.

test=# select count(*) from sale;
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children: 
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children: 
 count  
--------
 176588
(1 row)

test=#

Btw, I am surprised that psql can make a connection *and* runs a query just
fine.

My main problem with my application is to run a query. Connection seems to
be OK. Trying to run a query and my application simply freeze.

PgAdmin3 gives lots of error messages some objects missing, assertion
failures, etc. After all these messages PgAdmin3 seems to establish a
connection to PostgreSQL 9.6 database on Windows OS. However, PgAdmin3
cannot run a query, too. When I try to do a select, PgAdmin3 freeze. Waiting
only kills my application, or PgAdmin3. No log messages that I can find of.

Thanks.
-Ertan




-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux