[OSGeoLive] problems with pgAdmin3 and PostgreSQL 10

[Ben Caradoc-Davies]

On OSGeoLive alpha1 (Bionic), apt-get reports 6.5 MB downloads and 42 MB 
space when I install pgadmin4 from the postgresql repo configured as 
described in <https://wiki.postgresql.org/wiki/Apt>. Most dependencies 
are python3 packages. It starts OK. I have not tried connecting it to a 
database.

pgadmin3 is no longer supported. pgadmin4 is supported on Bionic (by the 
pgadmin team, not yet Ubuntu AFAIK). We should probably upgrade to 
pgadmin4 (and remove pgadmin3). Purging pgadmin3 and pgadmin3-data on 
alpha1 frees about 20 MB.

 From Chris Berg on the Debian ITP for pgadmin4:
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=834129#35
"The missing bit for Debian is that the tarball contains JavaScript
bundles. These bundles consist mostly of the pgAdmin4 source files,
but also some external JS libraries. The list of these external
libraries is documented, so getting this part DFSG-compliant is
feasible. Missing however is the transpiler (minifier) used for
creating the bundles, "yarn". (There is a yarn in Debian which is
something completely different.) Getting yarn into Debian will
probably require a lot more effort, so there is still a lot of work to
be done before pgAdmin4 can enter Debian unstable. Help welcome."

Until then we can install it from the postgresql repo.

Kind regards,
Ben.

On 19/06/18 07:39, Johan Van de Wauw wrote:
> There are things happening at:
> https://salsa.debian.org/postgresql/pgadmin4
> 
> and
> https://www.postgresql.org/download/linux/ubuntu/
> 
> Kind Regards,
> Johan
> 
> On Mon, Jun 18, 2018 at 4:13 PM, Angelos Tzotsos <gcpp.kalxas at gmail.com>
> wrote:
> 
>> Thanks for the feedback Astrid.
>> Lets see if pgadmin4 is available in Bionic...
>>
>> Cheers,
>> Angelos
>>
>> On Mon, Jun 18, 2018 at 11:21 AM, Astrid Emde (OSGeo) <
>> astrid_emde at osgeo.org> wrote:
>>
>>> Hello,
>>>
>>> Bionic offers PostgreSQL 10 and pgAdmin3.
>>>
>>> I noticed that pgAdmn3 has problems with PostgreSQL sequence
>>> visualisation.
>>>
>>> When you click on a sequence you get an error and in the end pgAdmin
>>> crashes.
>>>
>>> ERROR:  column "min_value" does not exist
>>> LINE 1: SELECT last_value, min_value, max_value, cache_value, is_cyc...
>>>
>>>              ^
>>> Reason is that the sequence information changed and that some columns do
>>> not exist anymore.
>>> user at user:/var/www/html/$ psql -U user natural_earth2
>>> psql (10.4 (Ubuntu 10.4-0ubuntu0.18.04))
>>> Type "help" for help.
>>>
>>> natural_earth2=# Select * from ne_10m_lakes_gid_seq;
>>>   last_value | log_cnt | is_called
>>> ------------+---------+-----------
>>>         1343 |      10 | t
>>>
>>>
>>> with PostgreSQl 9.x the table had a different columns
>>> Select * from ne_10m_lakes_gid_seq;
>>>      sequence_name     | last_value | start_value | increment_by |
>>> max_value      | min_value | cache_value | log_cnt | is_cycled | is_called
>>> ----------------------+------------+-------------+----------
>>> ----+---------------------+-----------+-------------+-------
>>> --+-----------+-----------
>>>   ne_10m_lakes_gid_seq |       1343 |           1 |            1 |
>>> 9223372036854775807 |         1 |           1 |       0 | f         | t
>>> (1 row)
>>>
>>> Now my question is whether we should also offer pgAdmin4 with OSGeoLive?
>>>
>>> What do you think about the idea? Do you know why still pgAdmin3 is
>>> provided with bionic and not pgAdmin4? Maybe pgAdmin4 brings other problems
>>> and usability is not so good? But maybe it is good to offer both and have
>>> the choice.
>>>
>>> Astrid
>>>
>>> --
>>>
>>> -------------------------------------------------------------
>>> Astrid Emde
>>> OSGeo Board Member and OSGeo Secretary
>>> Open Source Geospatial Foundation
>>> https://www.osgeo.org/member/astrid-emde/
>>> astrid_emde at osgeo.org
>>> _______________________________________________
>>> osgeolive mailing list
>>> osgeolive at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/osgeolive
>>>
>>
>>
>>
>> --
>> Angelos Tzotsos, PhD
>> OSGeo Charter Member
>> http://users.ntua.gr/tzotsos
>>
>> _______________________________________________
>> osgeolive mailing list
>> osgeolive at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/osgeolive
>>
>>
> 
> 
> 
> _______________________________________________
> osgeolive mailing list
> osgeolive at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/osgeolive
> 

-- 
Ben Caradoc-Davies <ben at transient.nz>
Director
Transient Software Limited <https://transient.nz/>
New Zealand