Re: PostgreSQL and GUI management

2023-08-15 Thread Andreas Joseph Krogh 


På tirsdag 15. august 2023 kl. 22:52:48, skrev Rob Sargent <
robjsarg...@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
andr...@visena.com 
www.visena.com

Re: PostgreSQL and GUI management

2023-08-15 Thread Adrian Klaver 

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.kla...@aklaver.com

Re: PostgreSQL and GUI management

2023-08-15 Thread Rob Sargent 

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

2023-08-15 Thread Pavel Stehule 
út 15. 8. 2023 v 20:38 odesílatel Adrian Klaver 
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.kla...@aklaver.com
>
>
>
>

Re: PostgreSQL and GUI management

2023-08-15 Thread Adrian Klaver 

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.kla...@aklaver.com

Re: PostgreSQL and GUI management

2023-08-15 Thread Andreas Joseph Krogh 


På tirsdag 15. august 2023 kl. 20:43:16, skrev Rob Sargent <
robjsarg...@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
andr...@visena.com 
www.visena.com

Re: PostgreSQL and GUI management

2023-08-15 Thread Rob Sargent 

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

2023-08-15 Thread Adrian Klaver 

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.kla...@aklaver.com

Re: AW: PostgreSQL and GUI management

2023-08-15 Thread Jason Long 
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 wrote:  
 
I am using pg_admin in the browser, and it works rather fine for me.
 
-Markus
 
  
 
Von: Jason Long  
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

2023-08-15 Thread Albrecht Dreß 

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  – I use the Eclipse plug-in, but 
there are stand-alone (free) versions, too.

Hth, Albrecht.

pgpQ_nw8Yof5T.pgp
Description: PGP signature

Re: PostgreSQL and GUI management

2023-08-15 Thread Pavel Stehule 
út 15. 8. 2023 v 17:16 odesílatel Pavel Stehule 
napsal:

> Hi
>
> út 15. 8. 2023 v 17:09 odesílatel Jason Long  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.
>>
>

Re: PostgreSQL and GUI management

2023-08-15 Thread Pavel Stehule 
Hi

út 15. 8. 2023 v 17:09 odesílatel Jason Long  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.
>

AW: PostgreSQL and GUI management

2023-08-15 Thread [Quipsy] Markus Karg 
I am using pg_admin in the browser, and it works rather fine for me.
-Markus

Von: Jason Long 
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.

PostgreSQL and GUI management

2023-08-15 Thread Jason Long 
Hello,Does PostgreSQL have a graphical environment for management or is it only 
managed through CLI?


Thank you.