PostgreSQL and GUI management

I am using pg_admin in the browser, and it works rather fine for me.
-Markus

Von: Jason Long <hack3rcon@yahoo.com>
Gesendet: Dienstag, 15. August 2023 17:09
An: pgsql-general@lists.postgresql.org
Betreff: PostgreSQL and GUI management

Hello,
Does PostgreSQL have a graphical environment for management or is it only managed through CLI?

Thank you.

Hi

út 15. 8. 2023 v 17:09 odesílatel Jason Long <hack3rcon@yahoo.com> napsal:

Hello,
Does PostgreSQL have a graphical environment for management or is it only
managed through CLI?

https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

Regards

Pavel

út 15. 8. 2023 v 17:16 odesílatel Pavel Stehule <pavel.stehule@gmail.com>
napsal:

Hi

út 15. 8. 2023 v 17:09 odesílatel Jason Long <hack3rcon@yahoo.com> napsal:

Hello,
Does PostgreSQL have a graphical environment for management or is it only
managed through CLI?

https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

better link https://wiki.postgresql.org/wiki/PostgreSQL_Clients

Am 15.08.23 17:08 schrieb(en) Jason Long:

Hello,Does PostgreSQL have a graphical environment for management or is it only managed through CLI?

Have a look at DBeaver <https://dbeaver.io/&gt; – I use the Eclipse plug-in, but there are stand-alone (free) versions, too.

Hth, Albrecht.

Hello,Thank you so much for your reply.Is it free?Has it met all your needs?

Sent from Yahoo Mail on Android

On Tue, Aug 15, 2023 at 6:40 PM, [Quipsy] Markus Karg<karg@quipsy.de> wrote:
I am using pg_admin in the browser, and it works rather fine for me.

-Markus

Von: Jason Long <hack3rcon@yahoo.com>
Gesendet: Dienstag, 15. August 2023 17:09
An: pgsql-general@lists.postgresql.org
Betreff: PostgreSQL and GUI management

Hello,

Does PostgreSQL have a graphical environment for management or is it only managed through CLI?

Thank you.

On 8/15/23 08:08, Jason Long wrote:

Hello,
Does PostgreSQL have a graphical environment for management or is it
only managed through CLI?

There are, but make your life easier and learn to use psql:

https://www.postgresql.org/docs/current/app-psql.html

It ships with Postgres and runs close to the database. Saves you the
time tracking down the issues that the GUI transformation code introduce.

Thank you.

--
Adrian Klaver
adrian.klaver@aklaver.com

On 8/15/23 12:38, Adrian Klaver wrote:

On 8/15/23 08:08, Jason Long wrote:

Hello,
Does PostgreSQL have a graphical environment for management or is it
only managed through CLI?

There are, but make your life easier and learn to use psql:

https://www.postgresql.org/docs/current/app-psql.html

It ships with Postgres and runs close to the database. Saves you the
time tracking down the issues that the GUI transformation code introduce.

Thank you.

Adrian,
Much as I love it, psql is not what I would call a management tool?

På tirsdag 15. august 2023 kl. 20:43:16, skrev Rob Sargent <
robjsargent@gmail.com <mailto:robjsargent@gmail.com>>:
[…]
Adrian,
Much as I love it, psql is not what I would call a management tool?

We have a multi-terabyte cluster in production which we manage using psql.

Locally I use IntelliJ IDEA for development (has syntax highlight, code
completion, introspection etc.). IDEA has a PostgreSQL plugin which is only
commercially available, and uses the same components as DataGrip, AFAIK.

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com&gt;
<https://www.visena.com&gt;

On 8/15/23 11:43, Rob Sargent wrote:

On 8/15/23 12:38, Adrian Klaver wrote:

On 8/15/23 08:08, Jason Long wrote:

Hello,
Does PostgreSQL have a graphical environment for management or is it
only managed through CLI?

There are, but make your life easier and learn to use psql:

https://www.postgresql.org/docs/current/app-psql.html

It ships with Postgres and runs close to the database. Saves you the
time tracking down the issues that the GUI transformation code introduce.

Thank you.

Adrian,
Much as I love it, psql is not what I would call a management tool?

Why not?

--
Adrian Klaver
adrian.klaver@aklaver.com

út 15. 8. 2023 v 20:38 odesílatel Adrian Klaver <adrian.klaver@aklaver.com>
napsal:

On 8/15/23 08:08, Jason Long wrote:

Hello,
Does PostgreSQL have a graphical environment for management or is it
only managed through CLI?

There are, but make your life easier and learn to use psql:

https://www.postgresql.org/docs/current/app-psql.html

It ships with Postgres and runs close to the database. Saves you the
time tracking down the issues that the GUI transformation code introduce.

use with pspg https://github.com/okbob/pspg

regards

Pavel

On 8/15/23 12:57, Adrian Klaver wrote:

On 8/15/23 11:43, Rob Sargent wrote:

On 8/15/23 12:38, Adrian Klaver wrote:

On 8/15/23 08:08, Jason Long wrote:

Hello,
Does PostgreSQL have a graphical environment for management or is
it only managed through CLI?

There are, but make your life easier and learn to use psql:

https://www.postgresql.org/docs/current/app-psql.html

It ships with Postgres and runs close to the database. Saves you the
time tracking down the issues that the GUI transformation code
introduce.

Thank you.

Adrian,
Much as I love it, psql is not what I would call a management tool?

Why not?

All the nice buzzwordy things: dashboards, alarm bells, point-and-click
drop downs for config values (with tool tip descriptions of what they
might do), coffee dispenser.  Things some feel they need in a management
tool.

On 8/15/23 13:52, Rob Sargent wrote:

On 8/15/23 12:57, Adrian Klaver wrote:

On 8/15/23 11:43, Rob Sargent wrote:

On 8/15/23 12:38, Adrian Klaver wrote:

On 8/15/23 08:08, Jason Long wrote:

Hello,
Does PostgreSQL have a graphical environment for management or is
it only managed through CLI?

There are, but make your life easier and learn to use psql:

https://www.postgresql.org/docs/current/app-psql.html

It ships with Postgres and runs close to the database. Saves you the
time tracking down the issues that the GUI transformation code
introduce.

Thank you.

Adrian,
Much as I love it, psql is not what I would call a management tool?

Why not?

All the nice buzzwordy things: dashboards, alarm bells, point-and-click
drop downs for config values (with tool tip descriptions of what they
might do), coffee dispenser.  Things some feel they need in a management
tool.

Ahh, the boss screen. Where you look like you are doing something when
you are not.

--
Adrian Klaver
adrian.klaver@aklaver.com

På tirsdag 15. august 2023 kl. 22:52:48, skrev Rob Sargent <
robjsargent@gmail.com <mailto:robjsargent@gmail.com>>:
[…]
All the nice buzzwordy things: dashboards, alarm bells, point-and-click drop
downs for config values (with tool tip descriptions of what they might do),
coffee dispenser. Things some feel they need in a management tool.

If you need these things, I'm sure there's a budget somewhere for investing in
available commercial tools, some already mentioned in this thread.

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com&gt;
<https://www.visena.com&gt;