Thread: PostgreSQL and GUI management

PostgreSQL and GUI management

From
Jason Long
Date:
Hello,
Does PostgreSQL have a graphical environment for management or is it only managed through CLI?


Thank you.

AW: PostgreSQL and GUI management

From
"[Quipsy] Markus Karg"
Date:

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.

Re: PostgreSQL and GUI management

From
Pavel Stehule
Date:
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?


Regards

Pavel



Thank you.

Re: PostgreSQL and GUI management

From
Pavel Stehule
Date:


ú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?



Regards

Pavel



Thank you.

Re: PostgreSQL and GUI management

From
Albrecht Dreß
Date:
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/> – I use the Eclipse plug-in, but there are stand-alone (free) versions,
too.

Hth, Albrecht.
Attachment

Re: AW: PostgreSQL and GUI management

From
Jason Long
Date:
Hello,
Thank you so much for your reply.
Is it free?
Has it met all your needs?



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.

Re: PostgreSQL and GUI management

From
Adrian Klaver
Date:
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




Re: PostgreSQL and GUI management

From
Rob Sargent
Date:
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?

Re: PostgreSQL and GUI management

From
Andreas Joseph Krogh
Date:
På tirsdag 15. august 2023 kl. 20:43:16, skrev Rob Sargent <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
 
Attachment

Re: PostgreSQL and GUI management

From
Adrian Klaver
Date:
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




Re: PostgreSQL and GUI management

From
Pavel Stehule
Date:


ú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.


regards

Pavel


 

>
>
> Thank you.

--
Adrian Klaver
adrian.klaver@aklaver.com



Re: PostgreSQL and GUI management

From
Rob Sargent
Date:
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.


Re: PostgreSQL and GUI management

From
Adrian Klaver
Date:
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




Re: PostgreSQL and GUI management

From
Andreas Joseph Krogh
Date:
På tirsdag 15. august 2023 kl. 22:52:48, skrev Rob Sargent <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
 
Attachment