Re: [GENERAL] Latest PostgreSQL on Raspbian Jessie - solved - Mailing list pgsql-general

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Thursday, February 23, 2017 5:25 PM
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] Latest PostgreSQL on Raspbian Jessie

On 02/23/2017 06:08 AM, Ertan Küçükoğlu wrote:
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Adrian Klaver
> Sent: Thursday, February 23, 2017 3:55 PM
> To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>;
> pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Latest PostgreSQL on Raspbian Jessie
>
>
> 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.

Yeah with the caveat:

"Some psql features might not work."

The older version of psql does not 'know' about new features in 9.6.

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

So the issue is with the Postgres library that Lazarus/FreePascal is using.

What would that library be?

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

Not all that surprising as pgAdmin3 is no longer supported:

https://www.pgadmin.org/download/source.php

As you found out, I don't think the last version of pgAdmin3 is compatible
with 9.6.

>
> Thanks.
> -Ertan
>


Problem solved,

Actually, library works just fine as I indicated that I am not having any
problem with local database connection which is also over TCP/IP
(localhost).

It turned out that I was doing a "simple" select * from query on a table
with more than 1.6 million rows. Obviously, Raspberry Pi memory can't handle
such a result set. After changing my source of select table into a smaller
one things started to be smooth and nice.

Sorry about all the fuss.

Thanks.
-Ertan