pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL and GUI management
12+ messages / 6 participants
[nested] [flat]

* PostgreSQL and GUI management
@ 2023-08-15 15:08 Jason Long <hack3rcon@yahoo.com>
  2023-08-15 15:16 ` Re: PostgreSQL and GUI management Pavel Stehule <pavel.stehule@gmail.com>
  2023-08-15 15:23 ` Re: PostgreSQL and GUI management Albrecht Dreß <albrecht.dress@posteo.de>
  2023-08-15 18:38 ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 3 replies; 12+ messages in thread

From: Jason Long @ 2023-08-15 15:08 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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


Thank you.

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
@ 2023-08-15 15:16 ` Pavel Stehule <pavel.stehule@gmail.com>
  2023-08-15 15:17   ` Re: PostgreSQL and GUI management Pavel Stehule <pavel.stehule@gmail.com>
  2 siblings, 1 reply; 12+ messages in thread

From: Pavel Stehule @ 2023-08-15 15:16 UTC (permalink / raw)
  To: Jason Long <hack3rcon@yahoo.com>; +Cc: pgsql-general@lists.postgresql.org

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


>
> Thank you.
>

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
  2023-08-15 15:16 ` Re: PostgreSQL and GUI management Pavel Stehule <pavel.stehule@gmail.com>
@ 2023-08-15 15:17   ` Pavel Stehule <pavel.stehule@gmail.com>
  0 siblings, 0 replies; 12+ messages in thread

From: Pavel Stehule @ 2023-08-15 15:17 UTC (permalink / raw)
  To: Jason Long <hack3rcon@yahoo.com>; +Cc: pgsql-general@lists.postgresql.org

ú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

>
> Regards
>
> Pavel
>
>
>>
>> Thank you.
>>
>

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
@ 2023-08-15 15:23 ` Albrecht Dreß <albrecht.dress@posteo.de>
  2 siblings, 0 replies; 12+ messages in thread

From: Albrecht Dreß @ 2023-08-15 15:23 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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.

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
@ 2023-08-15 18:38 ` Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 18:43   ` Re: PostgreSQL and GUI management Rob Sargent <robjsargent@gmail.com>
  2023-08-15 19:11   ` Re: PostgreSQL and GUI management Pavel Stehule <pavel.stehule@gmail.com>
  2 siblings, 2 replies; 12+ messages in thread

From: Adrian Klaver @ 2023-08-15 18:38 UTC (permalink / raw)
  To: Jason Long <hack3rcon@yahoo.com>; pgsql-general@lists.postgresql.org

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






^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
  2023-08-15 18:38 ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-08-15 18:43   ` Rob Sargent <robjsargent@gmail.com>
  2023-08-15 18:48     ` Re: PostgreSQL and GUI management Andreas Joseph Krogh <andreas@visena.com>
  2023-08-15 18:57     ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  1 sibling, 2 replies; 12+ messages in thread

From: Rob Sargent @ 2023-08-15 18:43 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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?

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
  2023-08-15 18:38 ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 18:43   ` Re: PostgreSQL and GUI management Rob Sargent <robjsargent@gmail.com>
@ 2023-08-15 18:48     ` Andreas Joseph Krogh <andreas@visena.com>
  1 sibling, 0 replies; 12+ messages in thread

From: Andreas Joseph Krogh @ 2023-08-15 18:48 UTC (permalink / raw)
  To: Rob Sargent <robjsargent@gmail.com>; +Cc: pgsql-general@lists.postgresql.org



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;
 <https://www.visena.com;

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
  2023-08-15 18:38 ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 18:43   ` Re: PostgreSQL and GUI management Rob Sargent <robjsargent@gmail.com>
@ 2023-08-15 18:57     ` Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 20:52       ` Re: PostgreSQL and GUI management Rob Sargent <robjsargent@gmail.com>
  1 sibling, 1 reply; 12+ messages in thread

From: Adrian Klaver @ 2023-08-15 18:57 UTC (permalink / raw)
  To: Rob Sargent <robjsargent@gmail.com>; pgsql-general@lists.postgresql.org

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






^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
  2023-08-15 18:38 ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 18:43   ` Re: PostgreSQL and GUI management Rob Sargent <robjsargent@gmail.com>
  2023-08-15 18:57     ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-08-15 20:52       ` Rob Sargent <robjsargent@gmail.com>
  2023-08-15 21:46         ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 23:03         ` Re: PostgreSQL and GUI management Andreas Joseph Krogh <andreas@visena.com>
  0 siblings, 2 replies; 12+ messages in thread

From: Rob Sargent @ 2023-08-15 20:52 UTC (permalink / raw)
  To: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general@lists.postgresql.org

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.

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
  2023-08-15 18:38 ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 18:43   ` Re: PostgreSQL and GUI management Rob Sargent <robjsargent@gmail.com>
  2023-08-15 18:57     ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 20:52       ` Re: PostgreSQL and GUI management Rob Sargent <robjsargent@gmail.com>
@ 2023-08-15 21:46         ` Adrian Klaver <adrian.klaver@aklaver.com>
  1 sibling, 0 replies; 12+ messages in thread

From: Adrian Klaver @ 2023-08-15 21:46 UTC (permalink / raw)
  To: Rob Sargent <robjsargent@gmail.com>; pgsql-general@lists.postgresql.org

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






^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
  2023-08-15 18:38 ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 18:43   ` Re: PostgreSQL and GUI management Rob Sargent <robjsargent@gmail.com>
  2023-08-15 18:57     ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
  2023-08-15 20:52       ` Re: PostgreSQL and GUI management Rob Sargent <robjsargent@gmail.com>
@ 2023-08-15 23:03         ` Andreas Joseph Krogh <andreas@visena.com>
  1 sibling, 0 replies; 12+ messages in thread

From: Andreas Joseph Krogh @ 2023-08-15 23:03 UTC (permalink / raw)
  To: Rob Sargent <robjsargent@gmail.com>; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general@lists.postgresql.org



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;
 <https://www.visena.com;

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: PostgreSQL and GUI management
  2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
  2023-08-15 18:38 ` Re: PostgreSQL and GUI management Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-08-15 19:11   ` Pavel Stehule <pavel.stehule@gmail.com>
  1 sibling, 0 replies; 12+ messages in thread

From: Pavel Stehule @ 2023-08-15 19:11 UTC (permalink / raw)
  To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: Jason Long <hack3rcon@yahoo.com>; pgsql-general@lists.postgresql.org

ú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




>
> >
> >
> > Thank you.
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>
>
>

^ permalink  raw  reply  [nested|flat] 12+ messages in thread


end of thread, other threads:[~2023-08-15 23:03 UTC | newest]

Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-15 15:08 PostgreSQL and GUI management Jason Long <hack3rcon@yahoo.com>
2023-08-15 15:16 ` Pavel Stehule <pavel.stehule@gmail.com>
2023-08-15 15:17   ` Pavel Stehule <pavel.stehule@gmail.com>
2023-08-15 15:23 ` Albrecht Dreß <albrecht.dress@posteo.de>
2023-08-15 18:38 ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-15 18:43   ` Rob Sargent <robjsargent@gmail.com>
2023-08-15 18:48     ` Andreas Joseph Krogh <andreas@visena.com>
2023-08-15 18:57     ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-15 20:52       ` Rob Sargent <robjsargent@gmail.com>
2023-08-15 21:46         ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-08-15 23:03         ` Andreas Joseph Krogh <andreas@visena.com>
2023-08-15 19:11   ` Pavel Stehule <pavel.stehule@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox