the installation of pgadmin4 makes me weep in frustration

On 14/1/19 9:58 π.μ., robert wrote:

Hi There

first, thanks a lot for the great an beautiful software we get from PostgreSQL and all people around it.

But I wonder how it comes, that installing pgadmin4 is so incredibly hard?

And no documentation.

I would like to install pgadmin4 to my ubuntu 18.1 laptop.

Where do I find doku on how to install pgadmin4. Preferably I would like to install it using pip?

it's no longer a standalone app, but rather a web app, follow the README's in the source. At least that was what I did, and I agree that it was not straight forward.

thanks

robert

--
Robert Rottermann CEO

031 333 10 20
robert@redo2oo.ch <mailto:robert@redo2oo.ch>
Sickingerstrasse 3, 3014 Bern <http://maps.apple.com/?q=Sickingerstrasse 3,3014 Bern>

https://Redo2oo.ch <https://redo2oo.ch&gt;

*Ihr Partner wenn es um ERP Lösungen geht.*

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

On Jan 14, 2019, at 7:58 AM, robert <robert@redo2oo.ch> wrote:

Hi There

first, thanks a lot for the great an beautiful software we get from PostgreSQL and all people around it.

But I wonder how it comes, that installing pgadmin4 is so incredibly hard?

And no documentation.

I would like to install pgadmin4 to my ubuntu 18.1 laptop.

Where do I find doku on how to install pgadmin4. Preferably I would like to install it using pip?

pgadmin 4 is nothing to do with the PostgreSQL project itself, it's just a third party client.

There are many other third-party clients listed here - https://wiki.postgresql.org/wiki/PostgreSQL_Clients -
most of them probably better than pgadmin4.

Cheers,
Steve

Just over a year ago, I started to look for free / open source clients for
Postgres, and went through most of that list.

Unless you are willing to pay for a commercial license, most of them are
not close to PG or have some limitations that made them unusable for me.
Several 'free' tools were limited as to the number of tables, databases or
whatever that they could handle.

Currently I am on PGAdmin 4.4, and it works fine for me (on Windows 10),
and has kept up with all the functionality available in Postgres, such as
procedures.

On Mon, 14 Jan 2019 at 12:25, Steve Atkins <steve@blighty.com> wrote:

Hi Robert,

Please try OmniDB: https://omnidb.org/en/

OmniDB is a database management tool that can be installed on Linux,
Windows and
MacOS, offering several features for managing PostgreSQL databases, for
example:

- monitoring dashboard
- query plan visualization
- psql-like console tab
- debugger for PL/pgSQL functions
- support for pglogical, Postgres-BDR and Postgres-XL as OmniDB plugins

OmniDB also offers basic management for Oracle, MariaDB and MySQL databases.
OmniDB is open source software and sponsored by 2ndQuadrant.

Hi Tony, OmniDB has evolved a lot since a year ago. Please checkout new
features
and improvements. A new release comes out every two months.

The developers try to include all the requests done via GitHub issues, so
if you
think something is missing, please just request there.

Best regards,

William

On Mon, Jan 14, 2019 at 9:01 AM Tony Shelver <tshelver@gmail.com> wrote:

Just over a year ago, I started to look for free / open source clients for
Postgres, and went through most of that list.

Unless you are willing to pay for a commercial license, most of them are
not close to PG or have some limitations that made them unusable for me.
Several 'free' tools were limited as to the number of tables, databases or
whatever that they could handle.

Currently I am on PGAdmin 4.4, and it works fine for me (on Windows 10),
and has kept up with all the functionality available in Postgres, such as
procedures.

On Mon, 14 Jan 2019 at 12:25, Steve Atkins <steve@blighty.com> wrote:

On Jan 14, 2019, at 7:58 AM, robert <robert@redo2oo.ch> wrote:

Hi There

first, thanks a lot for the great an beautiful software we get from

PostgreSQL and all people around it.

But I wonder how it comes, that installing pgadmin4 is so incredibly

hard?

And no documentation.

I would like to install pgadmin4 to my ubuntu 18.1 laptop.

Where do I find doku on how to install pgadmin4. Preferably I would

like to install it using pip?

pgadmin 4 is nothing to do with the PostgreSQL project itself, it's just
a third party client.

There are many other third-party clients listed here -
https://wiki.postgresql.org/wiki/PostgreSQL_Clients -
most of them probably better than pgadmin4.

Cheers,
Steve

--
William Ivanski - 2ndQuadrant
PostgreSQL Development, 24x7 Support & Remote DBA, Training & Services

Thanks to Postgres Debian/Ubuntu packaging team, Installing pgAdmin4 is
straightforward task,

1) Create the file /etc/apt/sources.list.d/pgdg.list and add a line for the
repository
deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main

2) Import the repository signing key, and update the package lists
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo
apt-key add -

3) sudo apt-get update

4) sudo apt-get install pgadmin4

Check https://www.postgresql.org/download/linux/ubuntu/ for more
information.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Jan 14, 2019 at 1:29 PM robert <robert@redo2oo.ch> wrote:

pgadmin 4 is nothing to do with the PostgreSQL project itself, it's just a third party client.

There are many other third-party clients listed here - https://wiki.postgresql.org/wiki/PostgreSQL_Clients -
most of them probably better than pgadmin4.

Agreed. I use dbeaver and it is very good.

I know this has already been answered, but for those who are also python
users, there is another and probably better option:

If you already have a python 3.6+ installation, you can download the
pgadmin4 wheel (python installable) from https://www.pgadmin.org/download/

Then do a pip install on it as for any other python module.

I prefer this route as it avoids having multiple python versions loaded on
my machine.

The standard install for the current version of pgadmin4 will download
python along with it.

As far as other tools go, I prefer to design my database using a modeling
tool.

As the only database we use or will use is postgresql, I find
https://pgmodeler.io to be pretty good for e free(ish) product.
It provides support for many postgres-only features such as extensions,
functions, json/jsonb and so on
And for a new python user, the product manual (contribution required) is an
excellent source for postgres-specific design topics.

On Mon, 14 Jan 2019 at 15:49, Murtuza Zabuawala <
murtuza.zabuawala@enterprisedb.com> wrote: