Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qW12A-001ryR-7m for pgsql-general@arkaria.postgresql.org; Tue, 15 Aug 2023 20:52:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qW128-0009m5-Qn for pgsql-general@arkaria.postgresql.org; Tue, 15 Aug 2023 20:52:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qW128-0009lx-Fp for pgsql-general@lists.postgresql.org; Tue, 15 Aug 2023 20:52:56 +0000 Received: from mail-pf1-x42f.google.com ([2607:f8b0:4864:20::42f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qW123-000K2h-AH for pgsql-general@lists.postgresql.org; Tue, 15 Aug 2023 20:52:55 +0000 Received: by mail-pf1-x42f.google.com with SMTP id d2e1a72fcca58-686daaa5f1fso4066387b3a.3 for ; Tue, 15 Aug 2023 13:52:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1692132770; x=1692737570; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=8VTv6r3G9fe0ufKoAVf1F4jGrlrJPcO1FI7OIjIskAY=; b=sUA4tQhP4fnRdYZzM4EBlcnBAq2xA21oQfzpm8W9Cr62iOajpUamPccSl7Gb1Lbkia qAu1YIUD2wY61apH84NtXZxgeZlvmbiJVdJzE5hktr6fNlyAVPpZvJ0IHT/J46VFNzkZ /e0yJoVNz6WEgYRnd1MkhFE5Kz70Ihf/jy3ZjCT1LdTPL6HInniekc622rSGyrrvM6od npHasCPJbmBrfGIn1fRGLpF1/nUYzwFSFKY8K+4pNahL9eqpUTq77HdWhBEexZCNTnW3 Ir4Bpn3LqFqyF1UVCcv1jl+sNdbY1hP16/S9et74gtotkMA588h9EBBlGHlQdudPwx+a cuzQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1692132770; x=1692737570; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=8VTv6r3G9fe0ufKoAVf1F4jGrlrJPcO1FI7OIjIskAY=; b=hTkkNaeeZpMWEQzAKbEJL4SqprE/nZB3LwfSFvm0gtT6M16PQs0D5dn8jFuWQ4xzLm AEYqLw/gud6kdNInhDCipnvb4rXo3FRWApPz5i4sE7jmSFmHF12QMTM7pSuEAFO4DBl+ nlL/hho9i1iqw3nknYYs2Jt1wAVEHMP6bfCqeO8bRNlVoMe+mf9nstUyI+gtgzkt4BCf +2zzsC6D8v6FwF1WwsRS5QA4YiyNJYSaaYCIkGREEpm+o3+vHKlr+4n6Tho+BFcKdQzV lYZ+0NLsWHrRlrQgn0PfFP/ECMx/2u4OzqojYwS4fOfKZzXUMFibQ4cPd9aK9hqV/jUP Dc/Q== X-Gm-Message-State: AOJu0YyvFqnlZiVBmUuJO+QGWm74CGCyYp/FFwa8by0GQ5cMkUVFxzql XfM32UNMCFMgn/cqADTp5h0= X-Google-Smtp-Source: AGHT+IGNxjqLXo45YnAvcqyXrOwtN9xZnfWwzLRJfxbK4ZKrTWSwGSIb2bFM1mILP8PvwXhfm72HHg== X-Received: by 2002:aa7:8889:0:b0:686:ec1d:18e5 with SMTP id z9-20020aa78889000000b00686ec1d18e5mr12951343pfe.28.1692132770122; Tue, 15 Aug 2023 13:52:50 -0700 (PDT) Received: from ?IPV6:2601:681:5a00:f790:f007:49eb:9c82:2062? ([2601:681:5a00:f790:f007:49eb:9c82:2062]) by smtp.gmail.com with ESMTPSA id m18-20020a639412000000b00565a0e66c79sm5408782pge.72.2023.08.15.13.52.49 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 15 Aug 2023 13:52:49 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------gXOsnvVrr0l9dhumrW9mArtO" Message-ID: <8b33b1a1-c2ce-d85f-0e8a-7119bceae21b@gmail.com> Date: Tue, 15 Aug 2023 14:52:48 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: PostgreSQL and GUI management Content-Language: en-CA To: Adrian Klaver , pgsql-general@lists.postgresql.org References: <880841814.2547950.1692112124893.ref@mail.yahoo.com> <880841814.2547950.1692112124893@mail.yahoo.com> <76ab6468-646e-e4bd-974c-27a31884c517@aklaver.com> <7ab7aacc-0373-fa42-8f9d-ba61c0327eac@gmail.com> <0ea33d2d-b169-0782-738a-e3dd13e19202@aklaver.com> From: Rob Sargent In-Reply-To: <0ea33d2d-b169-0782-738a-e3dd13e19202@aklaver.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------gXOsnvVrr0l9dhumrW9mArtO Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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. --------------gXOsnvVrr0l9dhumrW9mArtO Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
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.


--------------gXOsnvVrr0l9dhumrW9mArtO--