pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL and GUI management
12+ messages / 6 participants
[nested] [flat]
* PostgreSQL and GUI management
@ 2023-08-15 15:08 Jason Long <hack3rcon@yahoo.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:16 Pavel Stehule <pavel.stehule@gmail.com>
parent: Jason Long <hack3rcon@yahoo.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:17 Pavel Stehule <pavel.stehule@gmail.com>
parent: 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:23 Albrecht Dreß <albrecht.dress@posteo.de>
parent: Jason Long <hack3rcon@yahoo.com>
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 18:38 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Jason Long <hack3rcon@yahoo.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 18:43 Rob Sargent <robjsargent@gmail.com>
parent: 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 18:48 Andreas Joseph Krogh <andreas@visena.com>
parent: Rob Sargent <robjsargent@gmail.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 18:57 Adrian Klaver <adrian.klaver@aklaver.com>
parent: 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 19:11 Pavel Stehule <pavel.stehule@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.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
* Re: PostgreSQL and GUI management
@ 2023-08-15 20:52 Rob Sargent <robjsargent@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.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 21:46 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Rob Sargent <robjsargent@gmail.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 23:03 Andreas Joseph Krogh <andreas@visena.com>
parent: Rob Sargent <robjsargent@gmail.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
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