Horton

Thread

  1. PostgreSQL and GUI management

    Jason Long <hack3rcon@yahoo.com> — 2023-08-15T15:08:44Z

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


Thank you.

  2. AW: PostgreSQL and GUI management

    [Quipsy] Markus Karg <karg@quipsy.de> — 2023-08-15T15:10:00Z

    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.

  3. Re: PostgreSQL and GUI management

    Pavel Stehule <pavel.stehule@gmail.com> — 2023-08-15T15:16:28Z

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

  4. Re: PostgreSQL and GUI management

    Pavel Stehule <pavel.stehule@gmail.com> — 2023-08-15T15:17:22Z

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

  5. Re: PostgreSQL and GUI management

    Albrecht Dreß <albrecht.dress@posteo.de> — 2023-08-15T15:23:33Z

    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.

  6. Re: AW: PostgreSQL and GUI management

    Jason Long <hack3rcon@yahoo.com> — 2023-08-15T18:27:50Z

    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.

  7. Re: PostgreSQL and GUI management

    Adrian Klaver <adrian.klaver@aklaver.com> — 2023-08-15T18:38:26Z

    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

  8. Re: PostgreSQL and GUI management

    Rob Sargent <robjsargent@gmail.com> — 2023-08-15T18:43:16Z

    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?

  9. Re: PostgreSQL and GUI management

    Andreas Joseph Krogh <andreas@visena.com> — 2023-08-15T18:48:56Z

    
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>

  10. Re: PostgreSQL and GUI management

    Adrian Klaver <adrian.klaver@aklaver.com> — 2023-08-15T18:57:24Z

    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

  11. Re: PostgreSQL and GUI management

    Pavel Stehule <pavel.stehule@gmail.com> — 2023-08-15T19:11:28Z

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

  12. Re: PostgreSQL and GUI management

    Rob Sargent <robjsargent@gmail.com> — 2023-08-15T20:52:48Z

    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.

  13. Re: PostgreSQL and GUI management

    Adrian Klaver <adrian.klaver@aklaver.com> — 2023-08-15T21:46:13Z

    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

  14. Re: PostgreSQL and GUI management

    Andreas Joseph Krogh <andreas@visena.com> — 2023-08-15T23:03:40Z

    
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>