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 <[email protected]>
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) <
[email protected]> 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@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/
[email protected]
_______________________________________________
osgeolive mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/osgeolive
--
Angelos Tzotsos, PhD
OSGeo Charter Member
http://users.ntua.gr/tzotsos
_______________________________________________
osgeolive mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/osgeolive
_______________________________________________
osgeolive mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/osgeolive
--
Ben Caradoc-Davies <[email protected]>
Director
Transient Software Limited <https://transient.nz/>
New Zealand
_______________________________________________
osgeolive mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/osgeolive
