-----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Thursday, February 23, 2017 5:25 PM To: Ertan Küçükoğlu <ertan.kucukoglu@xxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx Subject: Re: Latest PostgreSQL on Raspbian Jessie On 02/23/2017 06:08 AM, Ertan Küçükoğlu wrote: > -----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 > > > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
