From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Latest PostgreSQL on Raspbian Jessie |
Date: | 2017-02-23 14:25:06 |
Message-ID: | 63a11bb9-d598-3f61-7b6b-adffefff605e@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/23/2017 06:08 AM, Ertan Küçükoğlu wrote:
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Adrian Klaver
> Sent: Thursday, February 23, 2017 3:55 PM
> To: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>;
> pgsql-general(at)postgresql(dot)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(at)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
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2017-02-23 14:32:56 | Re: Autovacuum stuck for hours, blocking queries |
Previous Message | Ertan Küçükoğlu | 2017-02-23 14:08:42 | Re: Latest PostgreSQL on Raspbian Jessie |