[OSGeoLive] problems with pgAdmin3 and PostgreSQL 10

[Angelos Tzotsos]

pgadmin4 packages have just landed in our ppa.
I am wondering how much space they will actually occupy vs pgadmin3

On 6/19/18 12:17 AM, Ben Caradoc-Davies wrote:
> 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
>>
>


-- 
Angelos Tzotsos, PhD
Charter Member
Open Source Geospatial Foundation
http://users.ntua.gr/tzotsos