[postgis-users] No extension

[Simon SPDBA Greener]

The old postgresql 13 was running on 5432.

I thought I had shut it down before running the 14 installer.

No matter, your suggestion about 5433 was the key I needed to open the door.

Thanks for all your patience and help: greatly appreciated.

regards

Simon

On 30/09/2022 10:31 am, Regina Obe wrote:
> When you use the PostgreSQL installer on windows,
> If you have a PostgreSQL instance running already on Port 5432, it defaults
> the port to the next available increment port.
>
> So my guess is you had your bitnami running on Port 5432, it detected that,
> so then installed on Port 5433.
>
> So your old would have 5432, your new PostgreSQL 14 would be 5433.
>
> That's why I mentioned, if you wanted it to run on default PostgreSQL 5432,
> you can do the
>
> Run the sql:
> ALTER SYSTEM Set port = '5432';
>
> Then restart the service.
>
> And that registry change I mentioned.
>
> Open regedit.exe
>
>   
>
> HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\postgresql-x64-14\
>
> Key: Port
>
>
> The registry change you do so if you install other 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.
>
>
>
>> -----Original Message-----
>> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
> Behalf
>> Of Simon SPDBA Greener
>> Sent: Thursday, September 29, 2022 7:50 PM
>> To: postgis-users at lists.osgeo.org
>> Subject: Re: [postgis-users] No extension
>>
>> 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)simon at spdba.com.au
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>> --
>> Simon Greener
>> 39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
>> (m) +61 418 396 391
>> (w) www.spdba.com.au
>> (m) simon at spdba.com.au
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-- 
Simon Greener
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(m) +61 418 396 391
(w) www.spdba.com.au
(m) simon at spdba.com.au