Обсуждение: the installation of pgadmin4 makes me weep in frustration

Поиск
Список
Период
Сортировка

the installation of pgadmin4 makes me weep in frustration

От
robert
Дата:

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?


thanks

robert

--
Robert Rottermann CEO

031 333 10 20
robert@redo2oo.ch
Sickingerstrasse 3, 3014 Bern

https://Redo2oo.ch
Ihr Partner wenn es um ERP Lösungen geht.

Re: the installation of pgadmin4 makes me weep in frustration

От
Achilleas Mantzios
Дата:
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
Sickingerstrasse 3, 3014 Bern

https://Redo2oo.ch
Ihr Partner wenn es um ERP Lösungen geht.


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

Re: the installation of pgadmin4 makes me weep in frustration

От
Steve Atkins
Дата:

> 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

Re: the installation of pgadmin4 makes me weep in frustration

От
Tony Shelver
Дата:
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

Re: the installation of pgadmin4 makes me weep in frustration

От
William Ivanski
Дата:
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

Re: the installation of pgadmin4 makes me weep in frustration

От
Murtuza Zabuawala
Дата:
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

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


--
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:

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?


thanks

robert

--
Robert Rottermann CEO

031 333 10 20
robert@redo2oo.ch
Sickingerstrasse 3, 3014 Bern

https://Redo2oo.ch
Ihr Partner wenn es um ERP Lösungen geht.

Re: the installation of pgadmin4 makes me weep in frustration

От
Ravi Krishna
Дата:
>
> 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.

Re: the installation of pgadmin4 makes me weep in frustration

От
Tony Shelver
Дата:
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:
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

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


--
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:

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?


thanks

robert

--
Robert Rottermann CEO

031 333 10 20
robert@redo2oo.ch
Sickingerstrasse 3, 3014 Bern

https://Redo2oo.ch
Ihr Partner wenn es um ERP Lösungen geht.