one I set at the database or user level.
>
>> -Original Message-
>> From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On
>Behalf
>> Of Bo Victor Thomsen
>> Sent: Tuesday, October 4, 2022 3:08 PM
>> To: postgis-users@lists.osgeo.org
>> Subject:
GIS Users Discussion
> Subject: Re: [postgis-users] No extension
>
> Search path is set. Because it is set in the database it is independent of the
> port, correct?
>
> Because I need to move forward, I've gone back to using port 5433 and all is
> working.
>
> T
x27;d suggest
>just upgrading to the latest JDBC driver from
>https://jdbc.postgresql.org/download/
>>
>>
>>
>>
>>
>>> -Original Message-
>>> From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org]
>On Behalf
>>> Of Simon Greener
>>> Se
atabase or user level.
> -Original Message-
> From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On
Behalf
> Of Bo Victor Thomsen
> Sent: Tuesday, October 4, 2022 3:08 PM
> To: postgis-users@lists.osgeo.org
> Subject: Re: [postgis-users] No extension
>
g] On Behalf
Of Simon Greener
Sent: Friday, September 30, 2022 4:56 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] No extension
Yes, it is uninstalled.
?39 Cliff View Drive
Allens Rivulet Tas 7150
(W) 0418 396 391?
On 30 Sep 2022, 18:24, at 18:24, Alexandre Neto
wrote:
Did you unins
st JDBC
driver from https://jdbc.postgresql.org/download/
> -Original Message-
> From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf
> Of Simon Greener
> Sent: Friday, September 30, 2022 4:56 AM
> To: PostGIS Users Discussion
> Subject:
t; >> ALTER SYSTEM Set port = '5432';
>> >>
>> >> Then restart the service.
>> >>
>> >> And that registry change I mentioned.
>> >>
>> >> Open regedit.exe
>> >>
>> >>
>> >> HKEY_LOCAL_MACHIN
er extensions such as
> >> postgis or pgAgent that need to connect to the database, they read
> >> the port
> >> number from the registry and default to that. I think pgAdmin4 also
> >> when you
> >> first setup reads port from registry.
> >>
> >
irst setup reads port from registry.
-Original Message-
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On
Behalf
Of Simon SPDBA Greener
Sent: Thursday, September 29, 2022 7:50 PM
To: postgis-users@lists.osgeo.org
Subject: Re: [postgis-users] No extension
Hold that thought.
you
first setup reads port from registry.
-Original Message-
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On
Behalf
Of Simon SPDBA Greener
Sent: Thursday, September 29, 2022 7:50 PM
To: postgis-users@lists.osgeo.org
Subject: Re: [postgis-users] No extension
Ho
rst setup reads port from registry.
> -Original Message-
> From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On
Behalf
> Of Simon SPDBA Greener
> Sent: Thursday, September 29, 2022 7:50 PM
> To: postgis-users@lists.osgeo.org
> Subject: Re: [postgis-u
Hold that thought.
Port 5432 didn't work on DFDB as I thought it did.
Port 5433 works.
Has the default port changed with database installs?
Simon
--
Simon Greener
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(m) +61 418 396 391
(w)www.spdba.com.au
(m)si...@spdba.com.au
You confirmed the port is right the 5433 port (not 5432).
Just still sounds like it’s trying to connect to the wrong service or
server still.
I’d triple check the connection settings, make sure the port and
IP/hostname is right.
I only have one instance running on my box with multiple data
@lists.osgeo.org
Subject: Re: [postgis-users] No extension
Regina,
This I suppose could be a permission issue or search path one.
I used pgAdmin 4 to set the search_path parameter to "$user", public, topology
for all the databases.
Didn't seem to make a difference.
Are you us
I can execute spatial queries in pgAdmin 4 OK.
select count(*)
from df.pit as p
inner join
df.path as t
on (ST_Intersects(t.path_line,ST_Buffer(p.pit_poly,10)))
where p.pit_id = 5
count
2
--
Simon Greener
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
022 2:03 AM
*To:* postgis-users@lists.osgeo.org
*Subject:* Re: [postgis-users] No extension
Regina,
Thanks for the reply.
> What does
> SELECT * FROM geometry_columns;
> Return. I’m guessing maybe QGIS is complaining about lack of
spatial tables.
It returns a data grid showing all
are
able to see. That should give you a clue if it’s a permission issue.
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Simon SPDBA Greener
Sent: Thursday, September 29, 2022 2:03 AM
To: postgis-users@lists.osgeo.org
Subject: Re: [postgis-users] No extension
Regina,
Thanks for the reply.
> What does
SELECT *FROM geometry_columns;
> Return. I’m guessing maybe QGIS is complaining about lack of spatial
tables.
It returns a data grid showing all the spatial layers.
> Looked like your PostgreSQL 13 is running on 5432, you could just
disable it
: Wednesday, September 28, 2022 10:15 PM
To: postgis-users@lists.osgeo.org
Subject: [postgis-users] No extension
When I tried to access my new Postgresql 14 database using qGIS 3.26 I get this
when connecting..
2022-09-29T12:09:14 WARNINGDatabase connection was successful, but the
select postgis_full_version();
"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""140""
GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" LIBXML=""2.9.9""
LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"""
regards
Simon
--
Simon Greener
39 Cliff View Drive, Allens Rivulet, 7150, Tasma
When I tried to access my new Postgresql 14 database using qGIS 3.26 I
get this when connecting..
2022-09-29T12:09:14 WARNING Database connection was successful, but
the accessible tables could not be determined.
2022-09-29T12:10:41 WARNING No PostGIS support in the database.
But the
21 matches
Mail list logo
